When you try to run a large transaction that affects many records simultaneously, the SQL Server 2000 process that originated the transaction might stop responding. The database might also stop responding until you restart the SQL Server computer. The Microsoft article "FIX: A SQL Server database may stop responding when you run a transaction that affects many records" describes the problem in detail and provides examples of call stacks to help you diagnose the problem. To read the article and download the hotfix, visit the Microsoft TechNet site at<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

   http://support.microsoft.com/?kbid=828017