Skip navigation

Microsoft Fixes Deallocation Problem in SQL Server 2000

Microsoft has released a hotfix for a problem that occurs when you perform large deallocation operations. When a large deallocation occurs in SQL Server 2000, SQL Server might temporarily stop responding to other requests. Operations such as dropping tables, dropping work files, and dropping indexes that are performed on objects that are multiple gigabytes in size might cause 17883 error messages in the error log, timeouts, or slow performance symptoms. To find out more about this problem and the supported hotfix, read the Microsoft article "FIX: SQL Server 2000 may stop responding to other requests when you perform a large deallocation operation" 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.