Article ID: 894905
Article Last Modified on 12/5/2007
APPLIES TO
- Microsoft SQL Server 2000 Enterprise Edition 64-bit
- Microsoft SQL Server 2000 Developer Edition
- 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 (Windows)
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:
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
- 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.
- This article also describes a list of the SQL Server 2000 SP3-based hotfixes that are not included in SQL Server 2000 SP4. The reason is that the ship date of these hotfixes is later than the ship date of SQL Server 2000 SP4. These hotfixes are first included in this build.
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.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 Service Pack 4
SQL Server 2000 build 8.00.2040 includes the same hotfix that SQL Server 2000 build 8.00.2141 includes. SQL Server 2000 build 8.00.2040 is a general distribution release (GDR) update. The hotfix that is included in SQL Server 2000 build 8.00.2040 is the first hotfix that was released after SQL Server 2000 SP4.
For more information about a GDR, click the following article number to view the article in the Microsoft Knowledge Base:
935897 An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems
SQL Server 2000 build 8.00.2145
836651 FIX: You receive query results that were not expected when you use both ANSI joins and non-ANSI joins
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
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
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
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
900470 FIX: You may receive an error message when you perform transactional replication in SQL Server 2000
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
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
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
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
SQL Server 2000 build 8.00.2146
909100 FIX: The performance of the statement that raises an error differs from the performance of the statement that does not raise an error when you trace exception events in SQL Server 2000 on an IA-64 computer
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
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
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
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
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 Service Pack 4
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"
904244 FIX: Incorrect data is inserted unexpectedly when you perform a bulk copy operation by using the DB-Library API in SQL Server 2000 Service Pack 4
SQL Server 2000 build 8.00.2156
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
906890 FIX: You receive an access violation error message when a user-defined function is in a high-stress scenario in SQL Server 2000
909379 FIX: You receive a 17883 error message when you run a complex query against SQL Server 2000
909380 FIX: Error message 17883 may be logged in the error log when you try to manually update table statistics in SQL Server 2000
SQL Server 2000 build 8.00.2159
887700 FIX: Server Network Utility may display incorrect protocol properties in SQL Server 2000
891017 FIX: SQL Server 2000 may stop responding to other requests when you perform a large deallocation operation
891201 FIX: Performance is significantly reduced when you set trace flag 9134 to prevent error message 601 in SQL Server 2000
891268 FIX: You receive a 17883 error message and SQL Server 2000 may stop responding to other requests when you perform large in-memory sort operations
891585 FIX: Database recovery does not occur, or a user database is marked as suspect in SQL Server 2000
892205 FIX: You may receive a 17883 error message when SQL Server 2000 performs a very large hash operation
892392 FIX: Query performance may be slower if the query contains both a GROUP BY clause and a DISTINCT keyword on the same column
892551 FIX: You receive a SqlException error message when you call the sp_addmergepublication stored procedure when the Active Directory directory service is not available in SQL Server 2000
892840 FIX: 17883 errors may be written to the SQL Server error log when you run a query that generates many floating point exception errors in SQL Server 2000
892923 FIX: Differential database backups may not contain database changes in the Page Free Space (PFS) pages in SQL Server 2000
892935 FIX: You experience slow performance when you join local partitioned views with a table in SQL Server 2000
892940 FIX: You experience delays and receive a 17883 error message when SQL Server 2000 performs a large and complex query plan that uses hash operators
893172 FIX: An access violation may occur when you use the READPAST lock hint and you use a non-clustered index in your query in SQL Server 2000
894257 FIX: You receive an "Incorrect syntax near ')'" error message when you run a script that was generated by SQL-DMO for an Operator object in SQL Server 2000
896985 FIX: The Subscriber may not be able to upload changes to the Publisher when you incrementally add an article to a publication in SQL Server 2000 Service Pack 3
897572 FIX: You may receive a memory-related error message when you repeatedly create and destroy an out-of-process COM object within the same batch or stored procedure in SQL Server 2000
897578 FIX: Only the master database and the tempdb database are listed when you try to create a new job in SQL Server Enterprise Manager
900625 FIX: The error message that the SELECT statement returns may contain user data in SQL Server 2000
907250 FIX: You may experience concurrency issues when you run the DBCC INDEXDEFRAG statement in SQL Server 2000
892310 FIX: The results are different every time that you run a complex query that contains a hash outer join operator in SQL Server 2000
SQL Server 2000 build 8.00.2162
887700 FIX: Server Network Utility may display incorrect protocol properties in SQL Server 2000
891017 FIX: SQL Server 2000 may stop responding to other requests when you perform a large deallocation operation
891201 FIX: Performance is significantly reduced when you set trace flag 9134 to prevent error message 601 in SQL Server 2000
891268 FIX: You receive a 17883 error message and SQL Server 2000 may stop responding to other requests when you perform large in-memory sort operations
891585 FIX: Database recovery does not occur, or a user database is marked as suspect in SQL Server 2000
891866 FIX: The query runs slower than you expected when you try to parse a query in SQL Server 2000
892205 FIX: You may receive a 17883 error message when SQL Server 2000 performs a very large hash operation
892310 FIX: The results are different every time that you run a complex query that contains a hash outer join operator in SQL Server 2000
892392 FIX: Query performance may be slower if the query contains both a GROUP BY clause and a DISTINCT keyword on the same column
892551 FIX: You receive a SqlException error message when you call the sp_addmergepublication stored procedure when the Active Directory directory service is not available in SQL Server 2000
892840 FIX: 17883 errors may be written to the SQL Server error log when you run a query that generates many floating point exception errors in SQL Server 2000
892923 FIX: Differential database backups may not contain database changes in the Page Free Space (PFS) pages in SQL Server 2000
892935 FIX: You experience slow performance when you join local partitioned views with a table in SQL Server 2000
892940 FIX: You experience delays and receive a 17883 error message when SQL Server 2000 performs a large and complex query plan that uses hash operators
892985 FIX: You may experience unexpected delays in query execution and unexpected time-out situations, and you may receive error message 17883 when you use the BULK INSERT command in SQL Server 2000
893172 FIX: An access violation may occur when you use the READPAST lock hint and you use a non-clustered index in your query in SQL Server 2000
894254 FIX: A complex query that includes a UNION ALL operator and an EXISTS clause may fail in SQL Server 2000
894257 FIX: You receive an "Incorrect syntax near ')'" error message when you run a script that was generated by SQL-DMO for an Operator object in SQL Server 2000
895187 FIX: You receive an error message when you try to delete records by running a Delete Transact-SQL statement in SQL Server 2000
896425 FIX: The BULK INSERT statement silently skips insert attempts when the data value is NULL and the column is defined as NOT NULL for INT, SMALLINT, and BIGINT data types in SQL Server 2000
896980 FIX: The query plan may take longer than expected to compile, and you may receive error message 701, error message 8623, or error message 8651 in SQL Server 2000
896985 FIX: The Subscriber may not be able to upload changes to the Publisher when you incrementally add an article to a publication in SQL Server 2000 Service Pack 3
897572 FIX: You may receive a memory-related error message when you repeatedly create and destroy an out-of-process COM object within the same batch or stored procedure in SQL Server 2000
897578 FIX: Only the master database and the tempdb database are listed when you try to create a new job in SQL Server Enterprise Manager
898115 FIX: The subquery in a CASE function is evaluated even if the condition in the WHEN expression is false in SQL Server 2000
898709 FIX: Error message when you use SQL Server 2000: "Time out occurred while waiting for buffer latch type 3"
900335 FIX: The SQL Server 2000 automatic database recovery operation may not succeed if an index contains a FLOAT data type or a REAL data type, and this data type contains a NaN value
900416 FIX: A 17883 error may occur you run a query that uses a hash join in SQL Server 2000
900625 FIX: The error message that the SELECT statement returns may contain user data in SQL Server 2000
902851 FIX: SQL Server 2000 may intermittently appear to stop responding (hang) during a scheduled maintenance DBCC DBREINDEX operation
902852 FIX: Error message when you run an UPDATE statement that uses two JOIN hints to update a table in SQL Server 2000: "Internal SQL Server error"
905765 FIX: A view is corrupted after you run the DBCC DBREINDEX Transact-SQL statement to rebuild the clustered index on a view in SQL Server 2000
SQL Server 2000 build 8.00.2164
909089 FIX: An access violation may occur when you try to run a Transact-SQL 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.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
909369 FIX: Automatic checkpoints on some SQL Server 2000 databases do not run as expected
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.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.2175
911569 FIX: You may receive an access violation error message when you run a linked server query that includes a subquery
911677 FIX: A query may run more slowly against SQL Server 2000 post-Service Pack 3 hotfix build 8.00.0988 than a query that you run against SQL Server 2000 post-Service Pack 3 hotfix builds that are earlier than build 8.00.0988
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.2177
912468 FIX: The connection that processes the cube stops responding, and the cube is locked in SQL Server 2000 Analysis Services
913049 FIX: The result set contains data for the whole relational source when you execute a query to retrieve a drillthrough result set in SQL Server 2000 Analysis Services
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
913789 FIX: The password that you specify in a BACKUP statement appears in the SQL Server Errorlog file or in the Application event log if the BACKUP statement does not run in SQL Server 2000
SQL Server 2000 build 8.00.2181
914085 FIX: You may receive an error message when you try to use a Japanese user name or a Korean user name to connect to an Analysis Services server
SQL Server 2000 build 8.00.2184
913991 FIX: Hotfix files may not be copied to remote nodes when you install a 32-bit hotfix, and hotfix files may not be removed from remote nodes on a computer that is running SQL Server 2000 in an MSCS environment
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.2185
914439 FIX: The synchronization process may take a long time when you synchronize merge replication publications in SQL Server 2000
915340 FIX: A deadlock occurs when the scheduled SQL Server Agent job that you add or that you update is running in SQL Server 2000
SQL Server 2000 build 8.00.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
SQL Server 2000 build 8.00.2189
913438 FIX: The SQL Server process may end unexpectedly when you turn on trace flag -T1204 and a profiler trace is capturing the Lock:DeadLock Chain event in SQL Server 2000 Service Pack 4
915436 FIX: Error message when you run a complex insert query or a stored procedure in SQL Server 2000: "Internal SQL Server error"
916652 FIX: An access violation may occur when you run a query on a table that has a multicolumn index in SQL Server 2000
916653 FIX: An access violation may occur intermittently in the CQList::Remove function when you run a query in SQL Server 2000
SQL Server 2000 build 8.00.2190
916097 FIX: You may not be able to use Analysis Manager to change server properties for an instance of SQL Server 2000 Analysis Services that is running on an IA-64 server computer after you install Windows Server 2003 S916097 on a client computer
SQL Server 2000 build 8.00.2191
916698 FIX: Error message when you run SQL Server 2000: "Failed assertion = 'lockFound == TRUE'"
916950 FIX: You may experience heap corruption, and SQL Server 2000 may shut down with fatal access violations when you try to browse files in SQL Server 2000 Enterprise Manager on a Windows Server 2003 x64-based computer
SQL Server 2000 build 8.00.2192
917593 FIX: The "Audit Logout" event does not appear in the trace results file when you run a profiler trace against a linked server instance in SQL Server 2000
917606 FIX: You may notice a decrease in performance when you run a query that uses the UNION ALL operator in SQL Server 2000 Service Pack 4
SQL Server 2000 build 8.00.2194
893312 FIX: You may receive a "SQL Server could not spawn process_loginread thread" error message, and a memory leak may occur when you cancel a remote query in SQL Server 2000
917565 FIX: Error 17883 is logged in the SQL Server error log, and the instance of SQL Server 2000 temporarily stops responding
917972 FIX: You receive an access violation error message when you try to perform a read of a large binary large object column in SQL Server 2000
SQL Server 2000 build 8.00.2196
919165 FIX: A memory leak occurs when you run a remote query by using a linked server in SQL Server 2000
SQL Server 2000 build 8.00.2197
919068 FIX: The query may return incorrect results, and the execution plan for the query may contain a "Table Spool" operator in SQL Server 2000
919133 FIX: Each query takes a long time to compile when you execute a single query or when you execute multiple concurrent queries in SQL Server 2000
919399 FIX: A profiler trace in SQL Server 2000 may stop logging events unexpectedly, and you may receive the following error message: "Failed to read trace data"
SQL Server 2000 build 8.00.2199
919221 FIX: SQL Server 2000 may take a long time to complete the synchronization phase when you create a merge publication
SQL Server 2000 build 8.00.2200
920121 FIX: Error message when you add a calculated member to a cube in SQL Server 2000 Analysis Services Service Pack 4: "Unable to update the calculated member"
SQL Server 2000 build 8.00.2201
920930 FIX: Error message when you try to run a query on a linked server in SQL Server 2000
SQL Server 2000 build 8.00.2203
922040 FIX: You cannot uninstall SQL Server 2000 build 2187 when SQL Server 2000 build 2187 is configured as a Microsoft Cluster Service (MSCS) node
SQL Server 2000 build 8.00.2204
921929 BUG: When you click "Build Query" in the "Execute SQL Task Properties" dialog box of the SQL Server 2000 DTS package designer, SQL Server 2005 Management Studio unexpectedly closes
SQL Server 2000 build 8.00.2207
923344 FIX: A SQL Server 2000 session may be blocked for the whole time that a Snapshot Agent job runs
SQL Server 2000 build 8.00.2209
923327 FIX: You may receive an access violation error message when you import data by using the "Bulk Insert" command in SQL Server 2000
923563 FIX: Error message when you configure an immediate updating transactional replication in SQL Server 2000: "Implicit conversion from datatype 'text' to 'nvarchar' is not allowed"
923796 FIX: Data in a subscriber of a merge publication in SQL Server 2000 differs from the data in the publisher
SQL Server 2000 build 8.00.2215
924662 FIX: The query performance may be slow when you query data from a view in SQL Server 2000
SQL Server 2000 build 8.00.2216
925000 FIX: An access violation may occur in SQL Server 2000 Analysis Services when you try to use a 2007 Office system program to open an offline local cube
SQL Server 2000 build 8.00.2217
924664 FIX: You cannot stop the SQL Server service, or many minidump files and many log files are generated in SQL Server 2000
SQL Server 2000 build 8.00.2218
925297 FIX: The result may be sorted in the wrong order when you run a query that uses the ORDER BY clause to sort a column in a table in SQL Server 2000
SQL Server 2000 build 8.00.2220
925745 FIX: The members of a role that uses dynamic security cannot access the SQL Server 2000 Analysis Services database when you run a query against a cube
SQL Server 2000 build 8.00.2223
925678 FIX: Error message when you schedule a Replication Merge Agent job to run after you install SQL Server 2000 Service Pack 4: "The process could not enumerate changes at the 'Subscriber'"
925419 FIX: The server stops responding, the performance is slow, and a time-out occurs in SQL Server 2000
SQL Server 2000 build 8.00.2226
925684 FIX: You may experience one or more symptoms when you run a "CREATE INDEX" statement on an instance of SQL Server 2000
925732 FIX: You may receive inconsistent comparison results when you compare strings by using a width sensitive collation in SQL Server 2000
SQL Server 2000 build 8.00.2229
927186 FIX: Error message when you create a merge replication for tables that have computed columns in SQL Server 2000 Service Pack 4: "The process could not log conflict information"
SQL Server 2000 build 8.00.2231
928079 FIX: The Sqldumper.exe utility cannot generate a filtered SQL Server dump file when you use the Remote Desktop Connection service or Terminal Services to connect to a Windows 2000 Server-based computer in SQL Server 2000
SQL Server 2000 build 8.00.2232
928568 FIX: SQL Server 2000 stops responding when you cancel a query or when a query time-out occurs, and error messages are logged in the SQL Server error log file
SQL Server 2000 build 8.00.2234
929131 FIX: In SQL Server 2000, the synchronization process is slow, and the CPU usage is high on the computer that is configured as the Distributor
929440 FIX: Error messages when you try to update table rows or insert table rows into a table in SQL Server 2000: "644" or "2511"
SQL Server 2000 build 8.00.2238
929410 FIX: Error message when you run a full-text query in SQL Server 2000: "Error: 17883, Severity: 1, State: 0"
931932 FIX: The merge agent fails intermittently when you use merge replication that uses a custom resolver after you install SQL Server 2000 Service Pack 4
SQL Server 2000 build 8.00.2239
930484 FIX: CPU utilization may approach 100 percent on a computer that is running SQL Server 2000 after you run the BACKUP DATABASE statement or the BACKUP LOG statement
SQL Server 2000 build 8.00.2241
932697 FIX: A calculated member that uses the DistinctCount function always returns 0 when you query a virtual cube that contains the calculated member after you install SQL Server 2000 Analysis Services Service Pack 4
SQL Server 2000 build 8.00.2244
934203 FIX: A hotfix for Microsoft SQL Server 2000 Service Pack 4 may not update all the necessary files on an x64-based computer
SQL Server 2000 build 8.00.2245
933573 FIX: You may receive an assertion or database corruption may occur when you use the bcp utility or the "Bulk Insert" Transact-SQL command to import data in SQL Server 2000
SQL Server 2000 build 8.00.2246
935465 An updated version of Sqlvdi.dll is now available for SQL Server 2000
SQL Server 2000 build 8.00.2248
935950 FIX: The foreign key that you created between two tables does not work after you run the CREATE INDEX statement in SQL Server 2000
SQL Server 2000 build 8.00.2249
936232 FIX: An access violation may occur when you try to log in to an instance of SQL Server 2000
REFERENCES
For more information about the naming schema for 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
Additional query words: Cumulative
Keywords: kbbug kbfix kbqfe KB894905