http://www.sqlservercentral.com/blogs/basits-sql-server-tips/2013/05/08/microsoft-sql-server-2000-builds/

Printed 2014/11/23 09:28PM

Microsoft SQL Server 2000 Builds

By Basit Aalishan Masood-Al-Farooq, 2013/05/08

The following table lists all builds of SQL Server 2000 known hotfixes, service packs and KB articles that have been released by Microsoft.

Quick Overview:

Codename RTM SP1 SP2 SP3 SP4
Shiloh 8.00.194 8.00.384 8.00.532 8.00.760 8.00.2039

Microsoft SQL Server 2000 Builds Breakdown:

Build File version KB / Description Release Date
8.00.2305 2000.80.2305.0 983811 MS12-060: Description of the security update for SQL Server 2000 Service Pack 4 QFE: August 14, 2012 August 14, 2012
8.00.2301 2000.80.2301.0 983809 MS12-027: Description of the security update for Microsoft SQL Server 2000 Service Pack 4 QFE: April 10, 2012 April 10, 2012
8.00.2283 2000.80.2283.0 971524 FIX: An access violation occurs when you run a DELETE statement or an UPDATE statement in the Itanium-based versions of SQL Server 2000 after you install security update MS09-004 June 15, 2009
8.00.2282 2000.80.2282.0 960083 MS09-004: Description of the security update for SQL Server 2000 QFE and for MSDE 2000: February 10, 2009 February 10, 2009
8.00.2279 2000.80.2279.0 959678 FIX: When you run the SPSBackup.exe utility to back up a SQL Server 2000 database that is configured as a back-end database for a Windows SharePoint Services server, the backup operation fails April 8, 2009
8.00.2273 2000.80.2273.0 948111 MS08-040: Description of the security update for SQL Server 2000 QFE and MSDE 2000 July 8, 2008 August 5, 2008
8.00.2271 2000.80.2271.0 946584 FIX: The SPACE function always returns one space in SQL Server 2000 if the SPACE function uses a collation that differs from the collation of the current database March 12, 2008
8.00.2265 2000.80.2265.0 944985 FIX: The data on the publisher does not match the data on the subscriber when you synchronize a SQL Server 2005 Mobile Edition subscriber with a SQL Server 2000 “merge replication” publisher December 19, 2007
8.00.2253 2000.80.2253.0 939317 FIX: The CPU utilization may suddenly increase to 100 percent when there are many connections to an instance of SQL Server 2000 on a computer that has multiple processors October 9, 2007
8.00.2249 2000.80.2249.0 936232 FIX: An access violation may occur when you try to log in to an instance of SQL Server 2000 May 25, 2007
8.00.2248 2000.80.2248.0 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 June 14, 2007
8.00.2246 2000.80.2246.0 935465 An updated version of Sqlvdi.dll is now available for SQL Server 2000 June 18, 2007
8.00.2245 2000.80.2245.0 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 April 24, 2007
8.00.2244 2000.80.2244.0 934203 FIX: A hotfix for Microsoft SQL Server 2000 Service Pack 4 may not update all the necessary files on an x64-based computer May 10, 2007
8.00.2242 2000.80.2242.0 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 March 28, 2007
8.00.2238 2000.80.2238.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 February 21, 2007
8.00.2236 2000.80.2236.0 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 February 2, 2007
8.00.2234 2000.80.2234.0 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″ February 22, 2007
8.00.2232 2000.80.2232.0 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 January 15, 2007
8.00.2231 2000.80.2231.0 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 June 19, 2007
8.00.2229 2000.80.2229.0 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” July 24, 2007
8.00.2226 2000.80.2226.0 925684 FIX: You may experience one or more symptoms when you run a “CREATE INDEX” statement on an instance of SQL Server 2000 November 20, 2006
8.00.2226 2000.80.2226.0 925732 FIX: You may receive inconsistent comparison results when you compare strings by using a width sensitive collation in SQL Server 2000 November 13, 2006
8.00.2223 2000.80.2223.0 925419 FIX: The server stops responding, the performance is slow, and a time-out occurs in SQL Server 2000 July 20, 2007
8.00.2223 2000.80.2223.0 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’” October 31, 2006
8.00.2218 2000.80.2218.0 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 June 19, 2007
8.00.2217 2000.80.2217.0 924664 FIX: You cannot stop the SQL Server service, or many minidump files and many log files are generated in SQL Server 2000 October 25, 2007
8.00.2215 2000.80.2215.0 923796 FIX: Data in a subscriber of a merge publication in SQL Server 2000 differs from the data in the publisher January 12, 2007
8.00.2215 2000.80.2215.0 924662 FIX: The query performance may be slow when you query data from a view in SQL Server 2000 October 5, 2006
8.00.2215 2000.80.2215.0 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” October 30, 2006
8.00.2215 2000.80.2215.0 923327 FIX: You may receive an access violation error message when you import data by using the “Bulk Insert” command in SQL Server 2000 December 28, 2006
8.00.2209 2000.80.2209.0 923797 The Knowledge Base (KB) Article You Requested Is Currently Not Available
8.00.2207 2000.80.2207.0 923344 FIX: A SQL Server 2000 session may be blocked for the whole time that a Snapshot Agent job runs August 28, 2006
8.00.2201 2000.80.2201.0 920930 FIX: Error message when you try to run a query on a linked server in SQL Server 2000 August 21, 2006
8.00.2199 2000.80.2199.0 919221 FIX: SQL Server 2000 may take a long time to complete the synchronization phase when you create a merge publication July 26, 2006
8.00.2197 2000.80.2197.0 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 August 2, 2006
8.00.2197 2000.80.2197.0 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 August 8, 2006
8.00.2197 2000.80.2197.0 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” October 18, 2006
8.00.2196 2000.80.2196.0 919165 FIX: A memory leak occurs when you run a remote query by using a linked server in SQL Server 2000 August 14, 2006
8.00.2194 2000.80.2194.0 917565 FIX: Error 17883 is logged in the SQL Server error log, and the instance of SQL Server 2000 temporarily stops responding February 21, 2007
8.00.2194 2000.80.2194.0 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 September 22, 2006
8.00.2192 2000.80.2192.0 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 August 4, 2006
8.00.2191 2000.80.2191.0 916698 FIX: Error message when you run SQL Server 2000: “Failed assertion = ‘lockFound == TRUE’” July 26, 2006
8.00.2191 2000.80.2191.0 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 October 3, 2006
8.00.2189 2000.80.2189.0 916652 FIX: An access violation may occur when you run a query on a table that has a multicolumn index in SQL Server 2000 July 26, 2006
8.00.2189 2000.80.2189.0 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 SP4 July 19, 2006
8.00.2187 2000.80.2187.0 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 June 18, 2007
8.00.2187 2000.80.2187.0 916287 A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2187 October 16, 2006
8.00.2187 2000.80.2187.0 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 July 26, 2006
8.00.2187 2000.80.2187.0 915065 FIX: Error message when you try to apply a hotfix on a SQL Server 2000-based computer that is configured as a MSCS node: “An error in updating your system has occurred” December 11, 2006
8.00.2180 2000.80.2180.0 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 February 19, 2007
8.00.2180 2000.80.2180.0 913684 FIX: You may receive error messages when you use linked servers in SQL Server 2000 on a 64-bit Itanium processor July 26, 2006
8.00.2175 2000.80.2175.0 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 July 26, 2006
8.00.2172 2000.80.2172.0 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 July 26, 2006
8.00.2171 2000.80.2171.0 909369 FIX: Automatic checkpoints on some SQL Server 2000 databases do not run as expected July 26, 2006
8.00.2168 2000.80.2168.0 907813 FIX: An error occurs when you try to access the Analysis Services performance monitor counter object after you apply Windows Server 2003 SP1 November 21, 2006
8.00.2166 2000.80.2166.0 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 July 26, 2006
8.00.2162 2000.80.2162.0 904660 A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2162 September 15, 2006
8.00.2159 2000.80.2159.0 907250 FIX: You may experience concurrency issues when you run the DBCC INDEXDEFRAG statement in SQL Server 2000 July 26, 2006
8.00.2156 2000.80.2156.0 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 July 25, 2006
8.00.2151 2000.80.2151.0 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 July 25, 2006
8.00.2151 2000.80.2151.0 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 June 13, 2007
8.00.2148 2000.80.2148.0 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 July 25, 2006
8.00.2148 2000.80.2148.0 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 July 25, 2006
8.00.2148 2000.80.2148.0 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 June 1, 2006
8.00.2148 2000.80.2148.0 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 June 1, 2006
8.00.2148 2000.80.2148.0 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 SP4 July 25, 2006
8.00.2148 2000.80.2148.0 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 June 1, 2006
8.00.2148 2000.80.2148.0 902955 FIX: You receive a “Getting registry information” message when you run the Sqldiag.exe utility after you install SQL Server 2000 SP4 July 25, 2006
8.00.2147 2000.80.2147.0 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 June 1, 2006
8.00.2145 2000.80.2145.0 826906 FIX: A query that uses a view that contains a correlated subquery and an aggregate runs slowly October 25, 2005
8.00.2145 2000.80.2145.0 836651 FIX: You receive query results that were not expected when you use both ANSI joins and non-ANSI joins June 7, 2006
8.00.2066 2000.80.2066.0 Microsoft Security Bulletin MS12-060 August 14, 2012
8.00.2065 2000.80.2065.0 983808 MS12-027: Description of the security update for Microsoft SQL Server 2000 Service Pack 4 GDR: April 10, 2012 April 10, 2012
8.00.2055 2000.80.2055.0 959420 MS09-004: Vulnerabilities in Microsoft SQL Server could allow remote code execution February 10, 2009
8.00.2040 2000.80.2040.0 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 August 15, 2006
8.00.2039 2000.80.2039.0 SQL Server 2000 Service Pack 4 (SP4) May 6, 2005
8.00.2026 2000.80.2026.0 SQL Server 2000 Service Pack 4 (SP4) Beta
8.00.1547 2000.80.1547.0 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 June 1, 2006
8.00.1077 2000.80.1077.0 983814 MS12-070: Description of the security update for SQL Server 2000 Reporting Services Service Pack 2 October 9, 2012
8.00.1037 2000.80.1037.0 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 February 2, 2007
8.00.1036 2000.80.1036.0 929410 FIX: Error message when you run a full-text query in SQL Server 2000: “Error: 17883, Severity: 1, State: 0″ January 11, 2007
8.00.1035 2000.80.1035.0 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 September 22, 2006
8.00.1034 2000.80.1034.0 915328 FIX: You may intermittently experience an access violation error when a query is executed in a parallel plan and the execution plan contains either a HASH JOIN operation or a Sort operation in SQL Server 2000 August 9, 2006
8.00.1029 2000.80.1029.0 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” June 1, 2006
8.00.1027 2000.80.1027.0 900416 FIX: A 17883 error may occur you run a query that uses a hash join in SQL Server 2000 July 25, 2006
8.00.1025 2000.80.1025.0 899428 FIX: You receive incorrect results when you run a query that uses a cross join operator in SQL Server 2000 SP3 June 1, 2006
8.00.1025 2000.80.1025.0 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 July 25, 2006
8.00.1024 2000.80.1024.0 898709 FIX: Error message when you use SQL Server 2000: “Time out occurred while waiting for buffer latch type 3″ July 25, 2006
8.00.1021 2000.80.1021.0 887700 FIX: Server Network Utility may display incorrect protocol properties in SQL Server 2000 July 25, 2006
8.00.1020 2000.80.1020.0 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 SP3 July 25, 2006
8.00.1019 2000.80.1019.0 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 June 1, 2006
8.00.1017 2000.80.1017.0 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 June 1, 2006
8.00.1014 2000.80.1014.0 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 June 1, 2006
8.00.1014 2000.80.1014.0 895187 FIX: You receive an error message when you try to delete records by running a Delete Transact-SQL statement in SQL Server 2000 July 25, 2006
8.00.1013 2000.80.1013.0 891866 FIX: The query runs slower than you expected when you try to parse a query in SQL Server 2000 June 1, 2006
8.00.1009 2000.80.1009.0 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 June 1, 2006
8.00.1007 2000.80.1007.0 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 June 1, 2006
8.00.1003 2000.80.1003.0 892923 FIX: Differential database backups may not contain database changes in the Page Free Space (PFS) pages in SQL Server 2000 June 1, 2006
8.00.1001 2000.80.1001.0 892205 FIX: You may receive a 17883 error message when SQL Server 2000 performs a very large hash operation June 1, 2006
8.00.1000 2000.80.1000.0 891585 FIX: Database recovery does not occur, or a user database is marked as suspect in SQL Server 2000 June 1, 2006
8.00.997 2000.80.997.0 891311 FIX: You cannot create new TCP/IP socket based connections after error messages 17882 and 10055 are written to the Microsoft SQL Server 2000 error log July 18, 2006
8.00.996 2000.80.996.0 891017 FIX: SQL Server 2000 may stop responding to other requests when you perform a large deallocation operation June 1, 2006
8.00.996 2000.80.996.0 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 June 1, 2006
8.00.994 2000.80.994.0 890942 FIX: Some complex queries are slower after you install SQL Server 2000 Service Pack 2 or SQL Server 2000 Service Pack 3 June 1, 2006
8.00.994 2000.80.994.0 890768 FIX: You experience non-convergence in a replication topology when you unpublish or drop columns from a dynamically filtered publication in SQL Server 2000 June 1, 2006
8.00.994 2000.80.994.0 890767 FIX: You receive a “Server: Msg 107, Level 16, State 3, Procedure TEMP_VIEW_Merge, Line 1″ error message when the sum of the length of the published column names in a merge publication exceeds 4,000 characters in SQL Server 2000 June 1, 2006
8.00.993 2000.80.993.0 890925 FIX: The @@ERROR system function may return an incorrect value when you execute a Transact-SQL statement that uses a parallel execution plan in SQL Server 2000 32-bit or in SQL Server 2000 64-bit June 1, 2006
8.00.993 2000.80.993.0 888444 FIX: You receive a 17883 error in SQL Server 2000 Service Pack 3 or in SQL Server 2000 Service Pack 3a when a worker thread becomes stuck in a registry call June 1, 2006
8.00.993 2000.80.993.0 890742 FIX: Error message when you use a loopback linked server to run a distributed query in SQL Server 2000: “Could not perform the requested operation because the minimum query memory is not available” May 15, 2006
8.00.991 2000.80.991.0 889314 FIX: Non-convergence may occur in a merge replication topology if the primary connection to the publisher is disconnected June 1, 2006
8.00.990 2000.80.990.0 890200 FIX: SQL Server 2000 stops listening for new TCP/IP Socket connections unexpectedly after error message 17882 is written to the SQL Server 2000 error log June 1, 2006
8.00.988 2000.80.988.0 889166 FIX: You receive a “Msg 3628″ error message when you run an inner join query in SQL Server 2000 June 1, 2006
8.00.985 2000.80.985.0 889239 FIX: Start times in the SQL Profiler are different for the Audit:Login and Audit:Logout Events in SQL Server 2000 June 1, 2006
8.00.980 2000.80.980.0 887974 FIX: A fetch on a dynamic cursor can cause unexpected results in SQL Server 2000 Service Pack 3 June 1, 2006
8.00.977 2000.80.977.0 888007 You receive a “The product does not have a prerequisite update installed” error message when you try to install a SQL Server 2000 post-Service Pack 3 hotfix August 31, 2005
8.00.973 2000.80.973.0 884554 FIX: A SPID stops responding with a NETWORKIO (0×800) waittype in SQL Server Enterprise Manager when SQL Server tries to process a fragmented TDS network packet June 1, 2006
8.00.972 2000.80.972.0 885290 FIX: An assertion error occurs when you insert data in the same row in a table by using multiple connections to an instance of SQL Server June 1, 2006
8.00.970 2000.80.970.0 872842 FIX: A CHECKDB statement reports a 2537 corruption error after SQL Server transfers data to a sql_variant column in SQL Server 2000 June 1, 2006
8.00.967 2000.80.967.0 878501 FIX: You may receive an error message when you run a SET IDENTITY_INSERT ON statement on a table and then try to insert a row into the table in SQL Server 2000 June 1, 2006
8.00.962 2000.80.962.0 883415 FIX: A user-defined function returns results that are not correct for a query June 1, 2006
8.00.961 2000.80.961.0 873446 FIX: An access violation exception may occur when multiple users try to perform data modification operations at the same time that fire triggers that reference a deleted or an inserted table in SQL Server 2000 on a computer that is running SMP June 1, 2006
8.00.959 2000.80.959.0 878500 FIX: An Audit Object Permission event is not produced when you run a TRUNCATE TABLE statement June 1, 2006
8.00.957 2000.80.957.0 870994 FIX: An access violation exception may occur when you run a query that uses index names in the WITH INDEX option to specify an index hint June 1, 2006
8.00.955 2000.80.955.0 867798 FIX: The @date_received parameter of the xp_readmail extended stored procedure incorrectly returns the date and the time that an e-mail message is submitted by the sender in SQL Server 2000 January 8, 2007
8.00.954 2000.80.954.0 843282 FIX: The Osql.exe utility does not run a Transact-SQL script completely if you start the program from a remote session by using a background service and then log off the console session January 5, 2007
8.00.952 2000.80.952.0 867878 FIX: The Log Reader Agent may cause 17883 error messages June 1, 2006
8.00.952 2000.80.952.0 867879 FIX: Merge replication non-convergence occurs with SQL Server CE subscribers June 1, 2006
8.00.952 2000.80.952.0 867880 FIX: Merge Agent may fail with an “Invalid character value for cast specification” error message June 1, 2006
8.00.949 2000.80.949.0 843266 FIX: Shared page locks can be held until end of the transaction and can cause blocking or performance problems in SQL Server 2000 Service Pack 3 (SP3) June 2, 2006
8.00.948 2000.80.948.0 843263 FIX: You may receive an 8623 error message when you try to run a complex query on an instance of SQL Server June 1, 2006
8.00.944 2000.80.944.0 839280 FIX: SQL debugging does not work in Visual Studio .NET after you install Windows XP Service Pack 2 June 5, 2006
8.00.937 2000.80.937.0 841776 FIX: Additional diagnostics have been added to SQL Server 2000 to detect unreported read operation failures June 1, 2006
8.00.936 2000.80.936.0 841627 FIX: SQL Server 2000 may underestimate the cardinality of a query expression under certain circumstances June 1, 2006
8.00.935 2000.80.935.0 841401 FIX: You may notice incorrect values for the “Active Transactions” counter when you perform multiple transactions on an instance of SQL Server 2000 that is running on an SMP computer June 1, 2006
8.00.934 2000.80.934.0 841404 FIX: You may receive a “The query processor could not produce a query plan” error message in SQL Server when you run a query that includes multiple subqueries that use self-joins June 1, 2006
8.00.933 2000.80.933.0 840856 FIX: The MSSQLServer service exits unexpectedly in SQL Server 2000 Service Pack 3 June 2, 2006
8.00.929 2000.80.929.0 839529 FIX: 8621 error conditions may cause SQL Server 2000 64-bit to close unexpectedly June 1, 2006
8.00.928 2000.80.928.0 839589 FIX: The thread priority is raised for some threads in a parallel query June 1, 2006
8.00.927 2000.80.927.0 839688 FIX: Profiler RPC events truncate parameters that have a text data type to 16 characters June 1, 2006
8.00.926 2000.80.926.0 839523 FIX: An access violation exception may occur when you update a text column by using a stored procedure in SQL Server 2000 June 1, 2006
8.00.923 2000.80.923.0 838460 FIX: The xp_logininfo procedure may fail with error 8198 after you install Q825042 or any hotfix with SQL Server 8.00.0840 or later June 1, 2006
8.00.922 2000.80.922.0 837970 FIX: You may receive an “Invalid object name…” error message when you run the DBCC CHECKCONSTRAINTS Transact-SQL statement on a table in SQL Server 2000 October 25, 2005
8.00.919 2000.80.919.0 837957 FIX: When you use Transact-SQL cursor variables to perform operations that have large iterations, memory leaks may occur in SQL Server 2000 October 25, 2005
8.00.916 2000.80.916.0 317989 FIX: Sqlakw32.dll May Corrupt SQL Statements September 27, 2005
8.00.915 2000.80.915.0 837401 FIX: Rows are not successfully inserted into a table when you use the BULK INSERT command to insert rows October 25, 2005
8.00.913 2000.80.913.0 836651 FIX: You receive query results that were not expected when you use both ANSI joins and non-ANSI joins June 7, 2006
8.00.911 2000.80.911.0 837957 FIX: When you use Transact-SQL cursor variables to perform operations that have large iterations, memory leaks may occur in SQL Server 2000 October 25, 2005
8.00.910 2000.80.910.0 834798 FIX: SQL Server 2000 may not start if many users try to log in to SQL Server when SQL Server is trying to start October 25, 2005
8.00.908 2000.80.908.0 834290 FIX: You receive a 644 error message when you run an UPDATE statement and the isolation level is set to READ UNCOMMITTED October 25, 2005
8.00.904 2000.80.904.0 834453 FIX: The Snapshot Agent may fail after you make schema changes to the underlying tables of a publication April 22, 2005
8.00.892 2000.80.892.0 833710 FIX: You receive an error message when you try to restore a database backup that spans multiple devices October 25, 2005
8.00.891 2000.80.891.0 836141 FIX: An access violation exception may occur when SQL Server runs many parallel query processing operations on a multiprocessor computer April 1, 2005
8.00.879 2000.80.879.0 832977 FIX: The DBCC PSS Command may cause access violations and 17805 errors in SQL Server 2000 October 25, 2005
8.00.878 2000.80.878.0 831950 FIX: You receive error message 3456 when you try to apply a transaction log to a server October 25, 2005
8.00.876 2000.80.876.0 830912 FIX: Key Names Read from an .Ini File for a Dynamic Properties Task May Be Truncated October 25, 2005
8.00.876 2000.80.876.0 831997 FIX: An invalid cursor state occurs after you apply Hotfix 8.00.0859 or later in SQL Server 2000 October 25, 2005
8.00.876 2000.80.876.0 831999 FIX: An AWE system uses more memory for sorting or for hashing than a non-AWE system in SQL Server 2000 October 25, 2005
8.00.873 2000.80.873.0 830887 FIX: Some queries that have a left outer join and an IS NULL filter run slower after you install SQL Server 2000 post-SP3 hotfix October 25, 2005
8.00.871 2000.80.871.0 830767 FIX: SQL Query Analyzer may stop responding when you close a query window or open a file October 25, 2005
8.00.871 2000.80.871.0 830860 FIX: The performance of a computer that is running SQL Server 2000 degrades when query execution plans against temporary tables remain in the procedure cache October 25, 2005
8.00.870 2000.80.870.0 830262 FIX: Unconditional Update May Not Hold Key Locks on New Key Values October 25, 2005
8.00.869 2000.80.869.0 830588 FIX: Access violation when you trace keyset-driven cursors by using SQL Profiler October 25, 2005
8.00.866 2000.80.866.0 830366 FIX: An access violation occurs in SQL Server 2000 when a high volume of local shared memory connections occur after you install security update MS03-031 January 16, 2006
8.00.865 2000.80.865.0 830395 FIX: An access violation occurs during compilation if the table contains statistics for a computed column October 25, 2005
8.00.865 2000.80.865.0 828945 FIX: You cannot insert explicit values in an IDENTITY column of a SQL Server table by using the SQLBulkOperations function or the SQLSetPos ODBC function in SQL Server 2000 October 25, 2005
8.00.863 2000.80.863.0 829205 FIX: Query performance may be slow and may be inconsistent when you run a query while another query that contains an IN operator with many values is compiled October 25, 2005
8.00.863 2000.80.863.0 829444 FIX: A floating point exception occurs during the optimization of a query October 25, 2005
8.00.859 2000.80.859.0 821334 FIX: Issues that are resolved in SQL Server 2000 build 8.00.0859 March 31, 2005
8.00.858 2000.80.858.0 828637 FIX: Users Can Control the Compensating Change Process in Merge Replication October 25, 2005
8.00.857 2000.80.857.0 828017 The Knowledge Base (KB) Article You Requested Is Currently Not Available
8.00.857 2000.80.857.0 827714 FIX: A query may fail with retail assertion when you use the NOLOCK hint or the READ UNCOMMITTED isolation level November 23, 2005
8.00.857 2000.80.857.0 828308 FIX: An Internet Explorer script error occurs when you access metadata information by using DTS in SQL Server Enterprise Manager October 25, 2005
8.00.856 2000.80.856.0 828096 FIX: Key Locks Are Held Until the End of the Statement for Rows That Do Not Pass Filter Criteria October 25, 2005
8.00.854 2000.80.854.0 828699 FIX: An Access Violation Occurs When You Run DBCC UPDATEUSAGE on a Database That Has Many Objects October 25, 2005
8.00.852 2000.80.852.0 830466 FIX: You may receive an “Internal SQL Server error” error message when you run a Transact-SQL SELECT statement on a view that has many subqueries in SQL Server 2000 April 1, 2005
8.00.852 2000.80.852.0 827954 FIX: Slow Execution Times May Occur When You Run DML Statements Against Tables That Have Cascading Referential Integrity October 25, 2005
8.00.851 2000.80.851.0 826754 FIX: A Deadlock Occurs If You Run an Explicit UPDATE STATISTICS Command October 25, 2005
8.00.850 2000.80.850.0 826860 FIX: Linked Server Query May Return NULL If It Is Performed Through a Keyset Cursor October 25, 2005
8.00.850 2000.80.850.0 826815 FIX: You receive an 8623 error message in SQL Server when you try to run a query that has multiple correlated subqueries October 25, 2005
8.00.850 2000.80.850.0 826906 FIX: A query that uses a view that contains a correlated subquery and an aggregate runs slowly October 25, 2005
8.00.848 2000.80.848.0 826822 FIX: A Member of the db_accessadmin Fixed Database Role Can Create an Alias for the dbo Special User October 25, 2005
8.00.847 2000.80.847.0 826433 PRB: Additional SQL Server Diagnostics Added to Detect Unreported I/O Problems October 25, 2005
8.00.845 2000.80.845.0 826364 FIX: A Query with a LIKE Comparison Results in a Non-Optimal Query Plan When You Use a Hungarian SQL Server Collation October 5, 2005
8.00.845 2000.80.845.0 825854 FIX: No Exclusive Locks May Be Taken If the DisAllowsPageLocks Value Is Set to True October 25, 2005
8.00.844 2000.80.844.0 826080 FIX: SQL Server 2000 protocol encryption applies to JDBC clients October 17, 2006
8.00.842 2000.80.842.0 825043 FIX: Rows are unexpectedly deleted when you run a distributed query to delete or to update a linked server table October 25, 2005
8.00.841 2000.80.841.0 825225 FIX: You receive an error message when you run a parallel query that uses an aggregation function or the GROUP BY clause October 25, 2005
8.00.840 2000.80.840.0 319477 FIX: Extremely Large Number of User Tables on AWE System May Cause BPool::Map Errors September 27, 2005
8.00.840 2000.80.840.0 319477 FIX: Extremely Large Number of User Tables on AWE System May Cause BPool::Map Errors September 27, 2005
8.00.839 2000.80.839.0 823877 FIX: An Access Violation May Occur When You Run a Query That Contains 32,000 or More OR Clauses October 25, 2005
8.00.839 2000.80.839.0 824027 FIX: A Cursor with a Large Object Parameter May Cause an Access Violation on CStmtCond::XretExecute October 25, 2005
8.00.837 2000.80.837.0 820788 FIX: Delayed domain authentication may cause SQL Server to stop responding October 25, 2005
8.00.837 2000.80.837.0 821741 FIX: Lock monitor exception in DeadlockMonitor::ResolveDeadlock October 25, 2005
8.00.837 2000.80.837.0 821548 FIX: A Parallel Query May Generate an Access Violation After You Install SQL Server 2000 SP3 October 25, 2005
8.00.837 2000.80.837.0 821740 FIX: MS DTC Transaction Commit Operation Blocks Itself October 25, 2005
8.00.837 2000.80.837.0 823514 FIX: Build 8.00.0837: A query that contains a correlated subquery runs slowly October 25, 2005
8.00.819 2000.80.819.0 826161 FIX: You are prompted for password confirmation after you change a standard SQL Server login October 25, 2005
8.00.818 2000.80.818.0 821277 MS03-031: Security patch for SQL Server 2000 Service Pack 3 January 9, 2006
8.00.818 2000.80.818.0 821337 FIX: Localized versions of SQL Mail and the Web Assistant Wizard may not work as expected in SQL Server 2000 64 bit March 16, 2005
8.00.818 2000.80.818.0 818388 FIX: A Transact-SQL Statement That Is Embedded in the Database Name Runs with System Administrator Permissions February 10, 2005
8.00.818 2000.80.818.0 826161 FIX: You are prompted for password confirmation after you change a standard SQL Server login October 25, 2005
8.00.818 2000.80.818.0 821280 MS03-031: Security Patch for SQL Server 2000 64-bit March 14, 2006
8.00.816 2000.80.816.0 818766 FIX: Intense SQL Server activity results in spinloop wait October 25, 2005
8.00.814 2000.80.814.0 819662 FIX: Distribution Cleanup Agent Incorrectly Cleans Up Entries for Anonymous Subscribers October 25, 2005
8.00.811 2000.80.811.0 819248 FIX: An access violation exception may occur when you insert a row in a table that is referenced by indexed views in SQL Server 2000 April 3, 2006
8.00.811 2000.80.811.0 819662 FIX: Distribution Cleanup Agent Incorrectly Cleans Up Entries for Anonymous Subscribers October 25, 2005
8.00.811 2000.80.811.0 818897 FIX: Invalid TDS Sent to SQL Server Results in Access Violation October 25, 2005
8.00.807 2000.80.807.0 818899 FIX: Error Message 3628 May Occur When You Run a Complex Query October 25, 2005
8.00.804 2000.80.804.0 818729 FIX: Internal Query Processor Error 8623 When Microsoft SQL Server Tries to Compile a Plan for a Complex Query October 25, 2005
8.00.801 2000.80.801.0 818540 FIX: SQL Server Enterprise Manager unexpectedly quits when you modify a DTS package January 26, 2006
8.00.800 2000.80.800.0 818414 FIX: The Sqldumper.exe File Does Not Generate a Userdump File When It Runs Against a Windows Service September 27, 2005
8.00.800 2000.80.800.0 818097 FIX: An Access Violation May Occur When You Run DBCC DBREINDEX on a Table That Has Hypothetical Indexes September 27, 2005
8.00.800 2000.80.800.0 818188 FIX: Query on the sysmembers Virtual Table May Fail with a Stack Overflow September 27, 2005
8.00.798 2000.80.798.0 817464 FIX: Using Sp_executesql in Merge Agent Operations September 27, 2005
8.00.794 2000.80.794.0 817464 FIX: Using Sp_executesql in Merge Agent Operations September 27, 2005
8.00.794 2000.80.794.0 813524 FIX: OLE DB conversion errors may occur after you select a literal string that represents datetime data as a column September 27, 2005
8.00.794 2000.80.794.0 816440 FIX: Error 8623 is Raised When SQL Server Compiles a Complex Query September 27, 2005
8.00.794 2000.80.794.0 817709 FIX: SQL Server 2000 might produce an incorrect cardinality estimate for outer joins February 11, 2005
8.00.791 2000.80.791.0 815249 FIX: Performance of a query that is run from a client program on a SQL Server SP3 database is slow after you restart the instance of SQL Server September 27, 2005
8.00.790 2000.80.790.0 817081 FIX: You receive an error message when you use the SQL-DMO BulkCopy object to import data into a SQL Server table September 27, 2005
8.00.789 2000.80.789.0 816840 FIX: Error 17883 May Display Message Text That Is Not Correct September 27, 2005
8.00.788 2000.80.788.0 816985 FIX: You cannot install SQL Server 2000 SP3 on the Korean version of SQL Server 2000 September 27, 2005
8.00.781 2000.80.781.0 815057 FIX: SQL Server 2000 Uninstall Option Does Not Remove All Files September 27, 2005
8.00.780 2000.80.780.0 816039 FIX: Code Point Comparison Semantics for SQL_Latin1_General_Cp850_BIN Collation September 27, 2005
8.00.780 2000.80.780.0 816084 FIX: sysindexes.statblob Column May Be Corrupted After You Run a DBCC DBREINDEX Statement September 27, 2005
8.00.780 2000.80.780.0 810185 SQL Server 2000 hotfix update for SQL Server 2000 Service Pack 3 and 3a October 10, 2006
8.00.779 2000.80.779.0 814035 FIX: A Full-Text Population Fails After You Apply SQL Server 2000 Service Pack 3 September 27, 2005
8.00.776 2000.80.776.0 Unidentified
8.00.775 2000.80.775.0 815115 FIX: A DTS package that uses global variables ignores an error message raised by RAISERROR September 27, 2005
8.00.769 2000.80.769.0 814889 FIX: A DELETE statement with a JOIN might fail and you receive a 625 error September 27, 2005
8.00.769 2000.80.769.0 814893 FIX: Error Message: “Insufficient key column information for updating” Occurs in SQL Server 2000 SP3 September 27, 2005
8.00.765 2000.80.765.0 810163 FIX: An Access Violation Occurs if an sp_cursoropen Call References a Parameter That Is Not Defined September 27, 2005
8.00.765 2000.80.765.0 810688 FIX: Merge Agent Can Resend Changes for Filtered Publications September 27, 2005
8.00.765 2000.80.765.0 811611 FIX: Reinitialized SQL Server CE 2.0 subscribers may experience data loss and non-convergence September 27, 2005
8.00.765 2000.80.765.0 813769 FIX: You May Experience Slow Performance When You Debug a SQL Server Service September 27, 2005
8.00.763 2000.80.763.0 814113 FIX: DTS Designer may generate an access violation after you install SQL Server 2000 Service Pack 3 September 27, 2005
8.00.762 2000.80.762.0 814032 FIX: Merge publications cannot synchronize on SQL Server 2000 Service Pack 3 September 27, 2005
8.00.760 2000.80.760.0 SQL Server 2000 Service Pack 3 (SP3 / SP3a) August 27, 2003
8.00.743 2000.80.743.0 818406 FIX: A Transact-SQL query that uses views may fail unexpectedly in SQL Server 2000 SP2 October 18, 2005
8.00.743 2000.80.743.0 818763 FIX: Intense SQL Server Activity Results in Spinloop Wait in SQL Server 2000 Service Pack 2 October 25, 2005
8.00.741 2000.80.741.0 818096 FIX: Many Extent Lock Time-outs May Occur During Extent Allocation February 10, 2005
8.00.736 2000.80.736.0 816937 FIX: A memory leak may occur when you use the sp_OAMethod stored procedure to call a method of a COM object September 27, 2005
8.00.735 2000.80.735.0 814889 FIX: A DELETE statement with a JOIN might fail and you receive a 625 error September 27, 2005
8.00.733 2000.80.733.0 813759 FIX: A Large Number of NULL Values in Join Columns Result in Slow Query Performance September 27, 2005
8.00.730 2000.80.730.0 813769 FIX: You May Experience Slow Performance When You Debug a SQL Server Service September 27, 2005
8.00.728 2000.80.728.0 814460 FIX: Merge Replication with Alternate Synchronization Partners May Not Succeed After You Change the Retention Period September 27, 2005
8.00.725 2000.80.725.0 812995 FIX: A Query with an Aggregate Function May Fail with a 3628 Error September 27, 2005
8.00.725 2000.80.725.0 813494 FIX: Distribution Agent Fails with “Violation of Primary Key Constraint” Error Message September 27, 2005
8.00.723 2000.80.723.0 812798 FIX: A UNION ALL View May Not Use Index If Partitions Are Removed at Compile Time September 27, 2005
8.00.721 2000.80.721.0 812250 FIX: Indexed View May Cause a Handled Access Violation in CIndex::SetLevel1Names September 27, 2005
8.00.721 2000.80.721.0 812393 FIX: Update or Delete Statement Fails with Error 1203 During Row Lock Escalation September 27, 2005
8.00.718 2000.80.718.0 811703 FIX: Unexpected results from partial aggregations based on conversions September 27, 2005
8.00.715 2000.80.715.0 810688 FIX: Merge Agent Can Resend Changes for Filtered Publications September 27, 2005
8.00.715 2000.80.715.0 811611 FIX: Reinitialized SQL Server CE 2.0 subscribers may experience data loss and non-convergence September 27, 2005
8.00.714 2000.80.714.0 811478 FIX: Restoring a SQL Server 7.0 database backup in SQL Server 2000 Service Pack 2 (SP2) may cause an assertion error in the Xdes.cpp file October 18, 2005
8.00.713 2000.80.713.0 811205 FIX: An error message occurs when you perform a database or a file SHRINK operation September 27, 2005
8.00.710 2000.80.710.0 811052 FIX: Latch Time-Out Message 845 Occurs When You Perform a Database or File SHRINK Operation September 27, 2005
8.00.705 2000.80.705.0 810920 FIX: The JOIN queries in the triggers that involve the inserted table or the deleted table may return results that are not consistent September 27, 2005
8.00.703 2000.80.703.0 810526 FIX: Cursors That Have a Long Lifetime May Cause Memory Fragmentation September 27, 2005
8.00.702 2000.80.702.0 328551 FIX: Concurrency enhancements for the tempdb database July 19, 2006
8.00.701 2000.80.701.0 810026 FIX: A DELETE Statement with a Self-Join May Fail and You Receive a 625 Error September 27, 2005
8.00.701 2000.80.701.0 810163 FIX: An Access Violation Occurs if an sp_cursoropen Call References a Parameter That Is Not Defined September 27, 2005
8.00.700 2000.80.700.0 810072 FIX: Merge Replication Reconciler Stack Overflow September 27, 2005
8.00.696 2000.80.696.0 810052 FIX: A Memory Leak Occurs When Cursors Are Opened During a Connection September 27, 2005
8.00.696 2000.80.696.0 810010 FIX: The fn_get_sql System Table Function May Cause Various Handled Access Violations September 27, 2005
8.00.695 2000.80.695.0 331885 FIX: Update/Delete Statement Fails with Error 1203 During Page Lock Escalation September 27, 2005
8.00.695 2000.80.695.0 331965 FIX: The xp_readmail Extended Stored Procedure Overwrites Attachment That Already Exists February 10, 2005
8.00.695 2000.80.695.0 331968 FIX: The xp_readmail and xp_findnextmsg Extended Stored Procedures Do Not Read Mail in Time Received Order February 10, 2005
8.00.693 2000.80.693.0 330212 FIX: Parallel logical operation returns results that are not consistent September 27, 2005
8.00.690 2000.80.690.0 311104 FIX: The SELECT Statement with Parallelism Enabled May Cause an Assertion October 12, 2005
8.00.689 2000.80.689.0 329499 FIX: Replication Removed from Database After Restore WITH RECOVERY October 11, 2005
8.00.688 2000.80.688.0 329487 FIX: Transaction Log Restore Fails with Message 3456 October 11, 2005
8.00.686 2000.80.686.0 316333 SQL Server 2000 Security Update for Service Pack 2 November 24, 2006
8.00.682 2000.80.682.0 319851 FIX: Assertion and Error Message 3314 Occurs If You Try to Roll Back a Text Operation with READ UNCOMMITTED October 18, 2005
8.00.679 2000.80.679.0 316333 SQL Server 2000 Security Update for Service Pack 2 November 24, 2006
8.00.678 2000.80.678.0 328354 FIX: A RESTORE DATABASE WITH RECOVERY Statement Can Fail with Error 9003 or Error 9004 September 27, 2005
8.00.667 2000.80.667.0 2000 SP2+8/14 fix
8.00.665 2000.80.665.0 2000 SP2+8/8 fix
8.00.661 2000.80.661.0 326999 FIX: Lock escalation on a scan while an update query is running causes a 1203 error message to occur September 27, 2005
8.00.655 2000.80.655.0 2000 SP2+7/24 fix
8.00.652 2000.80.652.0 810010 FIX: The fn_get_sql System Table Function May Cause Various Handled Access Violations September 27, 2005
8.00.650 2000.80.650.0 322853 FIX: SQL Server Grants Unnecessary Permissions or an Encryption Function Contains Unchecked Buffers November 5, 2003
8.00.644 2000.80.644.0 324186 FIX: Slow Compile Time and Execution Time with Query That Contains Aggregates and Subqueries September 27, 2005
8.00.636 2000.80.636.0 Microsoft Security Bulletin MS02-039 June 24, 2002
8.00.608 2000.80.608.0 319507 FIX: SQL Extended Procedure Functions Contain Unchecked Buffers June 21, 2004
8.00.604 2000.80.604.0 2000 SP2+3/29 fix
8.00.599 2000.80.599.0 319869 FIX: Improved SQL Manager Robustness for Odd Length Buffer September 27, 2005
8.00.594 2000.80.594.0 319477 FIX: Extremely Large Number of User Tables on AWE System May Cause BPool::Map Errors September 27, 2005
8.00.584 2000.80.584.0 318530 FIX: Reorder outer joins with filter criteria before non-selective joins and outer joins February 4, 2008
8.00.578 2000.80.578.0 317979 FIX: Unchecked Buffer May Occur When You Connect to Remote Data Source September 27, 2005
8.00.578 2000.80.578.0 318045 FIX: SELECT with Timestamp Column That Uses FOR XML AUTO May Fail with Stack Overflow or AV September 27, 2005
8.00.568 2000.80.568.0 317748 FIX: Handle Leak Occurs in SQL Server When Service or Application Repeatedly Connects and Disconnects with Shared Memory Network Library October 30, 2002
8.00.561 2000.80.561.0 2000 SP2+1/29 fix
8.00.558 2000.80.558.0 314003 FIX: Query That Uses DESC Index May Result in Access Violation September 26, 2005
8.00.558 2000.80.558.0 315395 FIX: COM May Not Be Uninitialized for Worker Thread When You Use sp_OA September 27, 2005
8.00.552 2000.80.552.0 313002 The Knowledge Base (KB) Article You Requested Is Currently Not Available
8.00.552 2000.80.552.0 313005 FIX: SELECT from Computed Column That References UDF Causes SQL Server to Terminate September 26, 2005
8.00.534 2000.80.534.0 2000 SP2.01
8.00.532 2000.80.532.0 SQL Server 2000 Service Pack 2 (SP2) February 4, 2003
8.00.475 2000.80.475.0 2000 SP1+1/29 fix
8.00.474 2000.80.474.0 315395 FIX: COM May Not Be Uninitialized for Worker Thread When You Use sp_OA September 27, 2005
8.00.473 2000.80.473.0 314003 FIX: Query That Uses DESC Index May Result in Access Violation September 26, 2005
8.00.471 2000.80.471.0 313302 FIX: Shared Table Lock Is Not Released After Lock Escalation September 26, 2005
8.00.469 2000.80.469.0 313005 FIX: SELECT from Computed Column That References UDF Causes SQL Server to Terminate September 26, 2005
8.00.452 2000.80.452.0 308547 FIX: SELECT DISTINCT from Table with LEFT JOIN of View Causes Error Messages or Client Application May Stop Responding September 26, 2005
8.00.444 2000.80.444.0 307540 FIX: SQLPutData May Result in Leak of Buffer Pool Memory September 26, 2005
8.00.444 2000.80.444.0 307655 FIX: Querying Syslockinfo with Large Numbers of Locks May Cause Server to Stop Responding October 7, 2005
8.00.443 2000.80.443.0 307538 FIX: SQLTrace Start and Stop is Now Reported in Windows NT Event Log for SQL Server 2000 September 26, 2005
8.00.428 2000.80.428.0 304850 FIX: SQL Server Text Formatting Functions Contain Unchecked Buffers August 5, 2004
8.00.384 2000.80.384.0 SQL Server 2000 Service Pack 1 (SP1) June 11, 2001
8.00.296 2000.80.296.0 299717 FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally Have August 9, 2004
8.00.287 2000.80.287.0 297209 FIX: Deletes, Updates and Rank Based Selects May Cause Deadlock of MSSEARCH October 7, 2005
8.00.251 2000.80.251.0 300194 FIX: Error 644 Using Two Indexes on a Column with Uppercase Preference Sort Order October 17, 2003
8.00.250 2000.80.250.0 291683 The Knowledge Base (KB) Article You Requested Is Currently Not Available
8.00.249 2000.80.249.0 288122 FIX: Lock Monitor Uses Excessive CPU September 12, 2003
8.00.239 2000.80.239.0 285290 FIX: Complex ANSI Join Query with Distributed Queries May Cause Handled Access Violation October 9, 2003
8.00.233 2000.80.233.0 282416 FIX: Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes a Long Time October 9, 2003
8.00.231 2000.80.231.0 282279 FIX: Execution of sp_OACreate on COM Object Without Type Information Causes Server Shut Down October 9, 2003
8.00.226 2000.80.226.0 278239 FIX: Extreme Memory Usage When Adding Many Security Roles November 21, 2006
8.00.225 2000.80.225.0 281663 “Access Denied” Error Message When You Try to Use a Network Drive to Modify Windows 2000 Permissions October 30, 2006
8.00.223 2000.80.223.0 280380 FIX: Buffer Overflow Exploit Possible with Extended Stored Procedures June 29, 2004
8.00.222 2000.80.222.0 281769 FIX: Exception Access Violation Encountered During Query Normalization October 7, 2005
8.00.218 2000.80.218.0 279183 FIX: Scripting Object with Several Extended Properties May Cause Exception October 9, 2003
8.00.217 2000.80.217.0 279293 FIX: CASE Using LIKE with Empty String Can Result in Access Violation or Abnormal Server Shutdown October 9, 2003
8.00.211 2000.80.211.0 276329 FIX: Complex Distinct or Group By Query Can Return Unexpected Results with Parallel Execution Plan November 5, 2003
8.00.210 2000.80.210.0 275900 FIX: Linked Server Query with Hyphen in LIKE Clause May Run Slowly October 9, 2003
8.00.205 2000.80.205.0 274330 FIX: Sending Open Files as Attachment in SQL Mail Fails with Error 18025 October 7, 2005
8.00.204 2000.80.204.0 274329 FIX: Optimizer Slow to Generate Query Plan for Complex Queries that have Many Joins and Semi-Joins October 9, 2003
8.00.194 2000.80.194.0 SQL Server 2000 RTM (no SP)
8.00.190 2000.80.190.0 SQL Server 2000 Gold
8.00.100 2000.80.100.0 SQL Server 2000 Beta 2
8.00.078 2000.80.078.0 SQL Server 2000 EAP5
8.00.047 2000.80.047.0 SQL Server 2000 EAP4

 

Note: RTM stands for release to market edition, which is the first supported version of SQL Server 2000, and SP stands for service pack. All SQL Server service packs and hotfixes are cumulative, meaning that each new service pack and hotfixes contains all the fixes that are included with previous service packs, hotfixes and new fixes issues.

Please use comment section, if you find build that is not listed here.



Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.