Cumulative list of the hotfixes that are available for SQL Server 2000 SP4 (894905)

The information in this article applies to:

Microsoft SQL Server 2000 Enterprise Edition 64-bit
Microsoft SQL Server 2000 Developer Edition 64 bit
Microsoft SQL Server 2000 Workgroup Edition
Microsoft SQL Server 2000 Standard Edition
Microsoft SQL Server 2000 Personal Edition
Microsoft SQL Server 2000 Enterprise Edition
Microsoft SQL Server 2000 Developer Edition
Microsoft SQL Server 2000 Desktop Engine (MSDE)

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 How to identify your SQL Server version and edition
To obtain SQL Server 2000 SP4, visit the following Microsoft Download Center Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5
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 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:
http://support.microsoft.com/contactus/?ws=support
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 A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2187

914298 FIX: You may receive an error message, and the SQL Server process may crash when you copy or transfer SQL Server 2000 data

914384 FIX: The database status changes to Suspect when you perform a bulk copy in a transaction and then roll back the transaction in SQL Server 2000

SQL Server 2000 build 8.00.2180

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 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

911569 FIX: You may receive an access violation error message when you run a linked server query that includes a subquery

SQL Server 2000 build 8.00.2172

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 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 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 FIX: An access violation may occur when you try to run a Transact-SQL query in SQL Server 2000

909369 FIX: Automatic checkpoints on some SQL Server 2000 databases do not run as expected

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 FIX: You may receive incorrect results when you run a Transact-SQL query in SQL Server 2000

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 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 A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2162

SQL Server 2000 build 8.00.2159

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 FIX: You receive an access violation error message when a user-defined function is in a high-stress scenario in SQL Server 2000

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

909379 FIX: You receive a 17883 error message when you run a complex query against SQL Server 2000

SQL Server 2000 build 8.00.2151

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 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 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 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 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 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 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 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 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 FIX: An access violation may occur when a deadlock graph is written to the error log in SQL Server 2000

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 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 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 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 FIX: You may receive an error message when you perform transactional replication in SQL Server 2000

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 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 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 Description of the standard terminology that is used to describe Microsoft software updates

Modification Type:	Major	Last Reviewed:	9/14/2006
Keywords:	kbbug kbfix kbQFE KB894905 kbAudITPRO kbAudDeveloper