Cumulative Hotfix Package is Available for SQL Server 2000 SP4

(AMSS TESTED and CERTIFIED for MICROSOFT SQL SERVER 2000 SP4 BUILD 2039 - ENTERPRISE EDITION)


AMSSKB® Knowledge Base Collaboration Project

Quick Details
File Name: SQL2000-KB916287-v8.00.2187-x86x64-ENU.exe
Product: SQL Server
Version: 8.00
Build: 2187
Date Published: 3/23/2006
Language: English
Download Size: 14.5 MB

INTRODUCTION
This article contains a list of the Microsoft SQL Server 2000 hotfixes. You can use this list to determine which hotfixes are included in a specific hotfix build. Unless otherwise specified, all the hotfixes in earlier builds are included in later builds. The list includes all the public hotfixes that have been released since the release of Microsoft SQL Server 2000 Service Pack 4 (SP4).

Important Notes:
 
Before you apply any hotfix in this list, you must have SQL Server 2000 SP4 installed. To determine which version of SQL Server you have, see the following article in the Microsoft Knowledge Base:
 
321185 (http://support.microsoft.com/kb/321185/) How to identify your SQL Server version and edition
 
To obtain SQL Server 2000 SP4, visit the following Microsoft Download Center Web site:
 
 
For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
 
119591 (http://support.microsoft.com/kb/119591/) How to obtain Microsoft support files from online services
 
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.
 
Hotfixes that are not part of a security release or a public roll-up package can only be obtained by contacting Microsoft Product Support Services.

For a complete list of Microsoft Product Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:
 
 
Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.
 
This list does not contain the hotfixes for Microsoft Data Access Components (MDAC) or for Microsoft SQL Server 2000 Analysis Services.
 

MORE INFORMATION

The following list includes all public SQL Server 2000 hotfixes that have been released since the release of SQL Server 2000 SP4.

SQL Server 2000 build 8.00.2187

916287 (http://support.microsoft.com/kb/916287/) A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2187
 
914298 (http://support.microsoft.com/kb/914298/) FIX: You may receive an error message, and the SQL Server process may crash when you copy or transfer SQL Server 2000 data

SQL Server 2000 build 8.00.2180

913684 (http://support.microsoft.com/kb/913684/) FIX: You may receive error messages when you use linked servers in SQL Server 2000 on a 64-bit Itanium processor

SQL Server 2000 build 8.00.2175

911678 (http://support.microsoft.com/kb/911678/) FIX: No rows may be returned, and you may receive an error message when you try to import SQL Profiler trace files into tables by using the fn_trace_gettable function in SQL Server 2000

SQL Server 2000 build 8.00.2172

910707 (http://support.microsoft.com/kb/910707/) FIX: When you query a view that was created by using the VIEW_METADATA option, an access violation may occur in SQL Server 2000
 
910710 (http://support.microsoft.com/kb/910710/) FIX: You receive an error message when a Visual Basic application opens a dynamic cursor on a GROUP BY query in SQL Server 2000 Service Pack 4

SQL Server 2000 build 8.00.2171

908156 (http://support.microsoft.com/kb/908156/) FIX: You receive an error message when MS DTC for SQL Server 2000 reuses a server process identifier (SPID) to enlist in a distributed transaction
 
909089 (http://support.microsoft.com/kb/909089/) FIX: An access violation may occur when you try to run a Transact-SQL query in SQL Server 2000
 
909369 (http://support.microsoft.com/kb/909369/) FIX: Automatic checkpoints on some SQL Server 2000 databases do not run as expected
 
909380 (http://support.microsoft.com/kb/909380/) FIX: Error message 17883 may be logged in the error log when you try to manually update table statistics in SQL Server 2000
 
910392 (http://support.microsoft.com/kb/910392/) FIX: You may receive incorrect results when you run a Transact-SQL query in SQL Server 2000
 
910895 (http://support.microsoft.com/kb/910895/) FIX: You may receive an error message when you set the database collation to Thai_CI_AS and you try to run a Transact-SQL update query in SQL Server 2000

SQL Server 2000 build 8.00.2166

909734 (http://support.microsoft.com/kb/909734/) FIX: An error message is logged, and new diagnostics do not capture the thread stack when the SQL Server User Mode Scheduler (UMS) experiences a nonyielding thread in SQL Server 2000 Service Pack 4

SQL Server 2000 build 8.00.2162

904660 (http://support.microsoft.com/kb/904660/) A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2162

SQL Server 2000 build 8.00.2159

907250 (http://support.microsoft.com/kb/907250/) FIX: You may experience concurrency issues when you run the DBCC INDEXDEFRAG statement in SQL Server 2000

SQL Server 2000 build 8.00.2156

906890 (http://support.microsoft.com/kb/906890/) FIX: You receive an access violation error message when a user-defined function is in a high-stress scenario in SQL Server 2000
 
906790 (http://support.microsoft.com/kb/906790/) FIX: You receive an error message when you try to rebuild the master database after you have installed hotfix builds in SQL Server 2000 SP4 64-bit

SQL Server 2000 build 8.00.2151

903742 (http://support.microsoft.com/kb/903742/) FIX: You receive an “Error: 8526, Severity: 16, State: 2” error message in SQL Profiler when you use SQL Query Analyzer to start or to enlist into a distributed transaction after you have installed SQL Server 2000 SP4
 
905417 (http://support.microsoft.com/kb/905417/) FIX: Error message when you try to open SQL Server 2000 Data Transformation Services (DTS) packages in SQL Server Management Studio: "SQL Server 2000 DTS Designer components are required to edit DTS packages"

SQL Server 2000 build 8.00.2148

895123 (http://support.microsoft.com/kb/895123/) FIX: You may receive error message 701, error message 802, and error message 17803 when many hashed buffers are available in SQL Server 2000
 
901200 (http://support.microsoft.com/kb/901200/) FIX: You may receive a “Server: Msg 7358, Level 16, State 1, Line 1” error message after you run a linked server query in SQL Server 2000 Service Pack 4
 
900629 (http://support.microsoft.com/kb/900629/) FIX: You receive a "Failed to open a table" error message when you try to open a trace table by using SQL Profiler after you upgrade to SQL Server 2000 Service Pack 4
 
902150 (http://support.microsoft.com/kb/902150/) FIX: Some 32-bit applications that use SQL-DMO and SQL-VDI APIs may stop working after you install SQL Server 2000 Service Pack 4 on an Itanium-based computer
 
900404 (http://support.microsoft.com/kb/900404/) FIX: The results of the query may be returned much slower than you expect when you run a query that includes a GROUP BY statement in SQL Server 2000
 
901212 (http://support.microsoft.com/kb/901212/) FIX: You receive an error message if you use the sp_addalias or sp_dropalias procedures when the IMPLICIT_TRANSACTIONS option is set to ON in SQL Server 2000 Service Pack 4
 
900390 (http://support.microsoft.com/kb/900390/) FIX: The Mssdmn.exe process may use lots of CPU capacity when you perform a SQL Server 2000 full text search of Office Word documents
 
898626 (http://support.microsoft.com/kb/898626/) FIX: An access violation may occur when a deadlock graph is written to the error log in SQL Server 2000
 
899430 (http://support.microsoft.com/kb/899430/) FIX: An access violation may occur when you run a SELECT query and the NO_BROWSETABLE option is set to ON in Microsoft SQL Server 2000
 
902955 (http://support.microsoft.com/kb/902955/) FIX: You receive a "Getting registry information" message when you run the Sqldiag.exe utility after you install SQL Server 2000 Service Pack 4
 
899431 (http://support.microsoft.com/kb/899431/) FIX: An access violation occurs in the Mssdi98.dll file, and SQL Server crashes when you use SQL Query Analyzer to debug a stored procedure in SQL Server 2000 Service Pack 4
 
903086 (http://support.microsoft.com/kb/903086/) FIX: The batch job stops running, and job output is truncated when you run a Transact-SQL script as a SQL Server Agent job in SQL Server 2000
 
900470 (http://support.microsoft.com/kb/900470/) FIX: You may receive an error message when you perform transactional replication in SQL Server 2000
 
899410 (http://support.microsoft.com/kb/899410/) FIX: You may experience slow server performance when you start a trace in an instance of SQL Server 2000 that runs on a computer that has more than four processors

SQL Server 2000 build 8.00.2040

899761 (http://support.microsoft.com/kb/899761/) FIX: Not all memory is available when AWE is enabled on a computer that is running a 32-bit version of SQL Server 2000 SP4

REFERENCES

For more information about the naming schema for Microsoft SQL Server updates, click the following article number to view the article in the Microsoft Knowledge Base:
 
822499 (http://support.microsoft.com/kb/822499/) New naming schema for Microsoft SQL Server software update packages
 
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
 
824684 (http://support.microsoft.com/kb/824684/) Description of the standard terminology that is used to describe Microsoft software updates
 

AMSS COMMUNITY HUB
James K. Murray (MCSA, MCSD)
President
A. M. Software Services, Inc.
347.247.6680
JamesMurray@AMSoftwareServices.com
http://www.amsoftwareservices.net
 
A. M. Software Services, Inc. is a Microsoft Certified Partner