Windows Live
Facebook
Twitter
Linkedin
Digg it
Yahoo
Delicious
StumbleUpon
Yammer
Reddit
Technorati
FriendFeed
EmailArticle ID: 894905 - Last Review: July 20, 2009 - Revision: 7.0 Cumulative list of the hotfixes that are available for SQL Server 2000 SP4
On This PageINTRODUCTIONThis 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:
MORE INFORMATIONThe 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.2040899761
(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 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
(http://support.microsoft.com/kb/935897/
)
An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems
SQL Server 2000 build 8.00.2145836651
(http://support.microsoft.com/kb/836651/
)
FIX: You receive query results that were not expected when you use both ANSI joins and non-ANSI joins
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
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
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
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
900470
(http://support.microsoft.com/kb/900470/
)
FIX: You may receive an error message when you perform transactional replication in SQL Server 2000
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
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
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
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
SQL Server 2000 build 8.00.2146909100
(http://support.microsoft.com/kb/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.2148895123
(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
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
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
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
SQL Server 2000 build 8.00.2151903742
(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 Service Pack 4
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"
904244
(http://support.microsoft.com/kb/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.2156906790
(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
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
909379
(http://support.microsoft.com/kb/909379/
)
FIX: You receive a 17883 error message when you run a complex query against SQL Server 2000
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
SQL Server 2000 build 8.00.2159887700
(http://support.microsoft.com/kb/887700/
)
FIX: Server Network Utility may display incorrect protocol properties in SQL Server 2000
891017
(http://support.microsoft.com/kb/891017/
)
FIX: SQL Server 2000 may stop responding to other requests when you perform a large deallocation operation
891201
(http://support.microsoft.com/kb/891201/
)
FIX: Performance is significantly reduced when you set trace flag 9134 to prevent error message 601 in SQL Server 2000
891268
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/891585/
)
FIX: Database recovery does not occur, or a user database is marked as suspect in SQL Server 2000
892205
(http://support.microsoft.com/kb/892205/
)
FIX: You may receive a 17883 error message when SQL Server 2000 performs a very large hash operation
892392
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/892923/
)
FIX: Differential database backups may not contain database changes in the Page Free Space (PFS) pages in SQL Server 2000
892935
(http://support.microsoft.com/kb/892935/
)
FIX: You experience slow performance when you join local partitioned views with a table in SQL Server 2000
892940
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/900625/
)
FIX: The error message that the SELECT statement returns may contain user data in SQL Server 2000
907250
(http://support.microsoft.com/kb/907250/
)
FIX: You may experience concurrency issues when you run the DBCC INDEXDEFRAG statement in SQL Server 2000
892310
(http://support.microsoft.com/kb/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.2162887700
(http://support.microsoft.com/kb/887700/
)
FIX: Server Network Utility may display incorrect protocol properties in SQL Server 2000
891017
(http://support.microsoft.com/kb/891017/
)
FIX: SQL Server 2000 may stop responding to other requests when you perform a large deallocation operation
891201
(http://support.microsoft.com/kb/891201/
)
FIX: Performance is significantly reduced when you set trace flag 9134 to prevent error message 601 in SQL Server 2000
891268
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/891585/
)
FIX: Database recovery does not occur, or a user database is marked as suspect in SQL Server 2000
891866
(http://support.microsoft.com/kb/891866/
)
FIX: The query runs slower than you expected when you try to parse a query in SQL Server 2000
892205
(http://support.microsoft.com/kb/892205/
)
FIX: You may receive a 17883 error message when SQL Server 2000 performs a very large hash operation
892310
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/892923/
)
FIX: Differential database backups may not contain database changes in the Page Free Space (PFS) pages in SQL Server 2000
892935
(http://support.microsoft.com/kb/892935/
)
FIX: You experience slow performance when you join local partitioned views with a table in SQL Server 2000
892940
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/894254/
)
FIX: A complex query that includes a UNION ALL operator and an EXISTS clause may fail in SQL Server 2000
894257
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/898709/
)
FIX: Error message when you use SQL Server 2000: "Time out occurred while waiting for buffer latch type 3"
900335
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/900416/
)
FIX: A 17883 error may occur you run a query that uses a hash join in SQL Server 2000
900625
(http://support.microsoft.com/kb/900625/
)
FIX: The error message that the SELECT statement returns may contain user data in SQL Server 2000
902851
(http://support.microsoft.com/kb/902851/
)
FIX: SQL Server 2000 may intermittently appear to stop responding (hang) during a scheduled maintenance DBCC DBREINDEX operation
902852
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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.2164909089
(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
SQL Server 2000 build 8.00.2166909734
(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.2171908156
(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
909369
(http://support.microsoft.com/kb/909369/
)
FIX: Automatic checkpoints on some SQL Server 2000 databases do not run as expected
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.2172910707
(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.2175911569
(http://support.microsoft.com/kb/911569/
)
FIX: You may receive an access violation error message when you run a linked server query that includes a subquery
911677
(http://support.microsoft.com/kb/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
(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.2177912468
(http://support.microsoft.com/kb/912468/
)
FIX: The connection that processes the cube stops responding, and the cube is locked in SQL Server 2000 Analysis Services
913049
(http://support.microsoft.com/kb/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.2180913684
(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
913789
(http://support.microsoft.com/kb/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.2181914085
(http://support.microsoft.com/kb/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.2184913991
(http://support.microsoft.com/kb/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
(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
914384
(http://support.microsoft.com/kb/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.2185914439
(http://support.microsoft.com/kb/914439/
)
FIX: The synchronization process may take a long time when you synchronize merge replication publications in SQL Server 2000
915340
(http://support.microsoft.com/kb/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.2187914298
(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.2189913438
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/915436/
)
FIX: Error message when you run a complex insert query or a stored procedure in SQL Server 2000: "Internal SQL Server error"
916652
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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.2190916097
(http://support.microsoft.com/kb/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.2191916698
(http://support.microsoft.com/kb/916698/
)
FIX: Error message when you run SQL Server 2000: "Failed assertion = 'lockFound == TRUE'"
916950
(http://support.microsoft.com/kb/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.2192917593
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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.2194893312
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/917565/
)
FIX: Error 17883 is logged in the SQL Server error log, and the instance of SQL Server 2000 temporarily stops responding
917972
(http://support.microsoft.com/kb/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.2196919165
(http://support.microsoft.com/kb/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.2197919068
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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.2199919221
(http://support.microsoft.com/kb/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.2200920121
(http://support.microsoft.com/kb/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.2201920930
(http://support.microsoft.com/kb/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.2203922040
(http://support.microsoft.com/kb/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.2204921929
(http://support.microsoft.com/kb/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.2207923344
(http://support.microsoft.com/kb/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.2209923327
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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.2215924662
(http://support.microsoft.com/kb/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.2216925000
(http://support.microsoft.com/kb/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.2217924664
(http://support.microsoft.com/kb/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.2218925297
(http://support.microsoft.com/kb/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.2220925745
(http://support.microsoft.com/kb/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.2223925678
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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.2226925684
(http://support.microsoft.com/kb/925684/
)
FIX: You may experience one or more symptoms when you run a "CREATE INDEX" statement on an instance of SQL Server 2000
925732
(http://support.microsoft.com/kb/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.2229927186
(http://support.microsoft.com/kb/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.2231928079
(http://support.microsoft.com/kb/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.2232928568
(http://support.microsoft.com/kb/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.2234929131
(http://support.microsoft.com/kb/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
(http://support.microsoft.com/kb/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.2238929410
(http://support.microsoft.com/kb/929410/
)
FIX: Error message when you run a full-text query in SQL Server 2000: "Error: 17883, Severity: 1, State: 0"
931932
(http://support.microsoft.com/kb/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.2239930484
(http://support.microsoft.com/kb/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.2241932697
(http://support.microsoft.com/kb/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.2244934203
(http://support.microsoft.com/kb/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.2245933573
(http://support.microsoft.com/kb/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.2246935465
(http://support.microsoft.com/kb/935465/
)
An updated version of Sqlvdi.dll is now available for SQL Server 2000
SQL Server 2000 build 8.00.2248935950
(http://support.microsoft.com/kb/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.2249936232
(http://support.microsoft.com/kb/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
(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
APPLIES TO
| Other Resources Other Support Sites
CommunityGet Help NowArticle Translations
|
Back to the top
