When you purchase through links on our site, we may earn an affiliate commission. Here’s how it works.

Fix: SQL Server 2000 may stop responding to requests

Steven Parker CEO - Neowin.net Neowin @aSteveParker · Jan 25, 2005 03:26 EST with -1 comments

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