Microsoft have posted a knowledge base article (KB 891017) that resolves a problem when SQL Server 2000 performs a large deallocation.

When a large deallocation occurs in Microsoft SQL Server 2000, SQL Server may temporarily stop responding to other requests. Operations, like dropping tables, dropping work files, and dropping indexes, that are performed on objects that are multiple gigabytes in size may cause 17883 error messages in the error log, timeouts, or slow performance symptoms.

This hotfix requires Microsoft SQL Server 2000 SP3a. Details of how you can obtain the hotfix can be found here. Microsoft only offer the option to contact Microsoft Support, there is no direct link to download the hotix.

View: KB Article 891017 | SP3a for SQL Server 2000

Additionally you can also choose to deploy the SP4 beta, details of how you can obtain thhis are outlined below:

How to Obtain
To participate in the SQL Server 2000 Service Pack 4 (SP4) Beta, you must fill out and submit a survey before you can gain access to the beta files. To access the survey, follow these steps.
  1. Visit the following Microsoft Beta Web site: https://beta.microsoft.com
    Note: You must have a Microsoft Passport account to access this Web site.

  2. Type s2ksp4 as the Guest ID.
    Note: The Guest ID is case-sensitive.

  3. Under You are Enrolled in the Following Beta Programs, click SQL Server 2000 SP4.

  4. Expand Survey in the left pane, click SQL Server 2000 SP4 Nomination, and then complete the survey.


There is 1 additional comment
Advertisement
Quote this comment Reply to this comment #1 Posted by Siriuss[FN] on 27 Jan 2005 - 11:04
I wish they had ddl for this stuff
[1]

Commenting has either been disabled on this article or you are not logged in. Click here to login or register, its free!

Note: Anonymous commenting is disabled in order to keep the quality of responses to a high standard.


Scroll to the Top
....
My Preferences
....
Communicating with server
Loading
Please Wait...
....
Loading
 X 
....