Running a Transaction That Affects Many Records Can Stop Your Database

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

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.