Microsoft KB Archive/810185

= SQL Server 2000 hotfix update for SQL Server 2000 Service Pack 3 and 3a =

Article ID: 810185

Article Last Modified on 11/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Service Pack 3
 * Microsoft SQL Server 2000 Service Pack 3a

-



Article contents

 * Summary
 * More information
 * Prerequisites
 * How to identify your SQL Server service pack and version
 * SQL Server 2000 baseline builds
 * Hotfix update information



SUMMARY
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 prior builds will be 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 3 and Microsoft SQL Server 2000 Service Pack 3a.

Here are some important notes regarding the Microsoft SQL Server 2000 hotfixes.  For all the hotfixes, you must have SQL Server 2000 Service Pack 3 or SQL Server 2000 Service Pack 3a installed. For hotfixes earlier than build 8.00.0818, we recommend that you apply build 8.00.0818 instead. Build 8.00.0818 contains security fixes that are documented in Microsoft Security Bulletin MS03-031. For download locations and additional information about the security vulnerability addressed in MS03-031, visit the following Microsoft Web site:

http://www.microsoft.com/technet/security/bulletin/MS03-031.mspx

 Hotfixes that are not part of a security release can only be obtained by contacting Microsoft Product Support Services. For a complete list of Microsoft Product Support Services telephone phone numbers and for information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS

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. To install any hotfix later than build 8.00.0977, you must first install the 8.00.0977 &quot;baseline&quot; build. For more information about &quot;baseline&quot; builds, see the &quot;SQL Server 2000 baseline builds&quot; section. This list does not contain the fixes for Microsoft Data Access Components (MDAC) or for Microsoft SQL Server 2000 Analysis Services.



Prerequisites

 * SQL Server 2000 Service Pack 3 (SP3) or SQL Server 2000 Service Pack 3a (SP3a)

Before you apply the update, you must have SQL Server 2000 Service Pack 3 (SP3) or SQL Server 2000 Service Pack 3a (SP3a) installed. To download SQL Server 2000 Service Pack 3a, visit the following Microsoft Web site:

SQL Server 2000 Service Pack 3a (SP3a)

How to identify your SQL Server service pack and version
To determine which version of SQL Server you are running, see the following article in the Microsoft Knowledge Base:

321185 How to identify your SQL Server service pack version and edition

SQL Server 2000 baseline builds
Microsoft SQL Server may occasionally release &quot;baseline&quot; builds for Microsoft SQL Server 2000. A baseline build provides support for features such as rollback. You may have to install a baseline build may to install any later hotfixes. Here is a list of the baseline builds for SQL Server 2000:
 * SQL Server 2000 build 8.00.0977
 * SQL Server 2000 build 8.00.1007

Hotfix update information
Here is a list of all the public SQL Server 2000 hotfixes that have been released since the release of SQL Server 2000 Service Pack 3 and SQL Server 2000 Service Pack 3a.

SQL Server 2000 build 8.00.0762
814032 FIX: Merge publications cannot synchronize on SQL Server 2000 Service Pack 3

SQL Server 2000 build 8.00.0763
814113 FIX: DTS Designer may generate an access violation after you install SQL Server 2000 Service Pack 3

SQL Server 2000 build 8.00.0765
814916 FIX: Merge Agent for a filtered publication might fail

814894 FIX: The Xp_readmail stored procedure only saves the text of an embedded attachment

814665 FIX: SQL Server Assertion: &quot;nret == FALSE&quot; occurs when you insert or update table data in SQL Server 2000

814509 FIX: A parallel query with a COUNT aggregate function may return unexpected results

814654 FIX: Error 1203 may be logged in the error log when you disconnect from an instance of SQL Server 2000 after you submit queries or transactions



SQL Server 2000 build 8.00.0769
815199 FIX: Profiler does not report CPU column value for RPC:Completed events correctly

815008 FIX: Query with Transaction Isolation Level set to READ UNCOMMITTED fails with error 601

814893 FIX: Error message: &quot;Insufficient key column information for updating&quot; occurs in SQL Server 2000 SP3

814889 FIX: A DELETE statement with a JOIN might fail and you receive a 625 error

SQL Server 2000 build 8.00.0775
815115 FIX: A DTS package that uses global variables ignores error message raised by RAISERROR

SQL Server 2000 build 8.00.0779
814035 FIX: A full-text population fails after you apply SQL Server 2000 Service Pack 3

SQL Server 2000 build 8.00.0780
816084 FIX: sysindexes.statblob column may be corrupted after you run a DBCC DBREINDEX statement

816069 FIX: A query with a large IN clause can cause concurrency issues

816039 FIX: Code point comparison semantics for SQL_Latin1_General_Cp850_BIN collation

815593 FIX: Incorrect cardinality estimates for NOT EXISTS predicates after you upgrade to SQL Server 2000 Service Pack 3

815592 FIX: Incorrect remoting of a predicate as a sub-SELECT function after SQL Server 2000 Service Pack 3 upgrade

815114 FIX: Excessive optimizer memory consumption may occur for queries that have multiple OUTER JOINS

815056 FIX: The checkpoint process can delay SQL Server database activity and does not yield Scheduler correctly causing Error: 17883 to occur

815183 FIX: An access violation or error 5180 occurs when you run a parallel query that includes a large IN clause

814997 FIX: The header information may not be included when the query parameter has a COMPUTE clause

812915 FIX: &quot;Performance monitor shared memory setup failed: -1&quot; error message when you start SQL Server

SQL Server 2000 build 8.00.0781
815057 FIX: SQL Server 2000 uninstall option does not remove all files

SQL Server 2000 build 8.00.0788
816985 FIX: You cannot install SQL Server 2000 SP3 on the Korean version of SQL Server 2000

SQL Server 2000 build 8.00.0789
817368 FIX: An INSERT or UPDATE that results in a page split might fail with Error 818

817359 FIX: An access violation may occur when you run an INSERT statement in an nText column

817263 FIX: A SELECT statement against a view might not return qualifying rows

817262 FIX: Complex query may not create an execution plan

817186 FIX: A query that performs join operations between multiple tables may return incorrect results

816840 FIX: Error 17883 may display message text that is not correct

816780 FIX: Merge Agent failures with articles that have indexed views defined

816503 FIX: Floating point exception (Error 3628) might occur for queries that need merged histograms

314128 FIX: Access violation occurs when an RPC call is made that includes a bit parameter value that is not valid

SQL Server 2000 build 8.00.0790
817081 FIX: You receive an error message when you use the SQL-DMO BulkCopy object to import data into a SQL Server table

SQL Server 2000 build 8.00.0791
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

SQL Server 2000 build 8.00.0794
817709 FIX: SQL Server 2000 might produce an incorrect cardinality estimate for outer joins

816883 FIX: SQL Server optimizer may underestimate the cardinality of range queries

816440 FIX: Error 8623 is raised when SQL Server compiles a complex query

813524 FIX: OLE DB conversion errors may occur after you select a literal string that represents datetime data as a column

SQL Server 2000 build 8.00.0798
817464 FIX: Using Sp_executesql in Merge Agent operations

SQL Server 2000 build 8.00.0800
828269 FIX: A Transact-SQL query that uses views may fail unexpectedly in SQL Server 2000 SP3

818188 FIX: Query on the sysmembers virtual table may fail with a stack overflow

818097 FIX: An access violation may occur when you run DBCC DBREINDEX on a table that has hypothetical indexes

818095 FIX: Cursor plans are not removed from the cache when virtual memory depleted

817780 A complex query is not successful on a server that has more than 2 GB of memory

816937 FIX: A memory leak may occur when you use the sp_OAMethod stored procedure to call a method of a COM object

SQL Server 2000 build 8.00.0801
818540 FIX: SQL Server Enterprise Manager quits unexpectedly when you modify a DTS package

818414 FIX: The Sqldumper.exe file does not generate a userdump file when it runs against a Windows service

816834 FIX: Osql.exe may not run batches as fast as other ODBC-based applications

SQL Server 2000 build 8.00.0804
818729 FIX: Internal query processor Error 8623 when Microsoft SQL Server tries to compile a plan for a complex query

SQL Server 2000 build 8.00.0807
818899 FIX: Error message 3628 may occur when you run a complex query

SQL Server 2000 build 8.00.0811
819955 FIX: Using xp_sendmail with a COMPUTE clause causes an access violation

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

818897 FIX: Invalid TDS sent to SQL Server results in access violation

SQL Server 2000 build 8.00.0814
819662 FIX: Distribution Cleanup Agent incorrectly cleans up entries for anonymous subscribers

SQL Server 2000 build 8.00.0816
820837 FIX: Allocation Caching Mechanisms Enable Faster Allocation of Pages to Objects

820835 FIX: SQL Server Might Take a Long Time to Recover After an Abrupt or Unexpected Server Shutdown

818769 FIX: Trace Flag -T8002 Treats an Affinity Mask Like a Process Affinity

818768 FIX: Cannot Set SQL Server Instance Specific Network Affinity

818767 FIX: Improved CPU Usage for Database Logging When Transaction Log Stalls Occur

818766 FIX: Intense SQL Server activity results in spinloop wait

332004 FIX: SQL Server scalability may be limited if AWE is enabled

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0818
818806 FIX: Some Named Pipes features are not disabled after you disable the Named Pipes protocol

814950 FIX: A computer might transmit nonencrypted data when clients use the Multiprotocol Net-Library with the encryption option enabled

814919 FIX: No message appears when a blank password is set for a system administrator login in SQL Server Enterprise Manager

SQL Server 2000 build 8.00.0819
826161 FIX: You are prompted for password confirmation after you change a standard SQL Server login

SQL Server 2000 build 8.00.0837
825884 FIX: The dynamic query statement appears in the query execution plan of an encrypted stored procedure

825883 FIX: The TextData column of the SP:StmtStarting event and the SP:StmtCompleted event displays the dynamic Transact-SQL statement even when the stored procedure is encrypted

825045 FIX: The Merge Agent takes a long time to download new data when it runs on a new anonymous subscription

825019 FIX: A linked server query fails with the error message &quot;Statement(s) could not be prepared&quot; in SQL Server 2000

824227 FIX: A SELECT statement that contains computed columns and invalid filter condition values may cause an access violation

823514 FIX: Build 8.00.0837: A query that contains a correlated subquery runs slowly

823455 FIX: Visual Basic raises a syntax error when you try to compile a file that was created when you saved a DTS package

822757 FIX: An Insert select command with OPENXML and a Sql_variant type can cause error 2537 to occur

822747 FIX: Error 644 or 8646 may occur during a DELETE or UPDATE against a table that contains a Unicode Column with a Latin1_General_BIN collation

822746 FIX: Incorrect results from a parallel query that uses a UNION and variables or parameters

822668 FIX: &quot;Connection is busy with results for another command&quot; error message occurs when you run a linked server query

821535 FIX: Merge replication fails with error 207 while generating a snapshot

821806 FIX: SQL Server may generate an incorrect SQL script for a table constraint when you use the &quot;Generate SQL Script&quot; option in Enterprise Manager

821688 FIX: A query filter condition that has a LEFT OUTER JOIN clause may cause an incorrect row count estimate in the query execution plan

821548 FIX: A parallel query may generate an access violation after you install SQL Server 2000 SP3

820788 FIX: Delayed domain authentication may cause SQL Server to stop responding

819829 FIX: When you run a program or a Web browser script that uses the Command object in the ADO programming interface to run a SQL Server stored procedure, you may receive an &quot;EXECUTE permission denied on object...&quot; error message in SQL Server 2000

821740 FIX: MS DTC transaction commit operation blocks itself

821537 FIX: A deadlock condition may occur when you perform an UPDATE operation or a DELETE operation against a remote OLE DB provider in SQL Server 2000

820727 FIX: A long-running cursor fetch may lead to an assertion failure when you try to access a SQL Server 2000 database from an application

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0839
824028 FIX: An outer or semi JOIN query that results in hash role reversal followed by a spill may return incorrect results

824027 FIX: A cursor with a large object parameter may cause an access violation on CStmtCond::XretExecute

824018 FIX: Parallel query that uses an indexed bit column may return results that are not correct

823877 FIX: An access violation may occur when you run a query that contains 32,000 or more OR clauses

SQL Server 2000 build 8.00.0840
825042 FIX: SQL Server jobs that are owned by non-sysadmin users may not start

825025 FIX: You cannot synchronize between a replication publisher and a replication republisher

824430 FIX: Performance decreases over time when you back up files in SQL Server 2000

319477 FIX: Extremely large number of user tables on AWE system may cause BPool::Map errors

825197 FIX: You receive error 3624 and the user database is marked suspect after you perform a bulk insert operation in SQL Server 2000

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0841
825225 FIX: You receive an error message when you run a parallel query that uses an aggregation function or the GROUP BY clause

SQL Server 2000 build 8.00.0842
825043 FIX: Rows are unexpectedly deleted when you run a distributed query to delete or to update a linked server table

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0844
826080 FIX: SQL Server 2000 protocol encryption applies to JDBC clients

SQL Server 2000 build 8.00.0845
826364 FIX: A query with a LIKE comparison results in a non-optimal query plan when you use a Hungarian SQL Server collation

825854 FIX: No exclusive locks may be taken if the DisAllowsPageLocks value is set to true

SQL Server 2000 build 8.00.0847
826433 PRB: Additional SQL Server diagnostics added to detect unreported I/O problems

SQL Server 2000 build 8.00.0848
826822 FIX: A member of the db_accessadmin fixed database role can create an alias for the dbo special user

SQL Server 2000 build 8.00.0850
826906 FIX: A query that uses a view that contains a correlated subquery and an aggregate runs slowly

826860 FIX: Linked server query may return NULL if it is performed through a keyset cursor

826815 FIX: You receive an 8623 error message in SQL Server when you try to run a query that has multiple correlated subqueries

SQL Server 2000 build 8.00.0851
826754 FIX: A deadlock occurs if you run an explicit UPDATE STATISTICS command

827178 FIX: You may receive a 644 error message when you run concurrent transactions on a heap

827175 FIX: Incorrect parameter numbering occurs in custom stored procedures that are generated with the Sp_scriptpublicationcustomprocs stored procedure

SQL Server 2000 build 8.00.0852
830466 FIX: You may receive an &quot;Internal SQL Server error&quot; error message when you run a Transact-SQL SELECT statement on a view that has many subqueries in SQL Server 2000

827954 FIX: Slow execution times may occur when you run DML statements against tables that have cascading referential integrity

SQL Server 2000 build 8.00.0854
828699 FIX: An access violation occurs when you run DBCC UPDATEUSAGE on a database that has many objects

818079 FIX: SQL Profiler displays incorrect TextData value when you run a nested stored procedure by using a remote procedure call

SQL Server 2000 build 8.00.0856
828096 FIX: Key locks are held until the end of the statement for rows that do not pass filter criteria

SQL Server 2000 build 8.00.0857
828308 FIX: An Internet Explorer script error occurs when you access metadata information by using DTS in SQL Server Enterprise Manager

827714 FIX: A query may fail with retail assertion when you use the NOLOCK hint or the READ UNCOMMITTED isolation level

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0858
828637 FIX: Users can control the compensating change process in Merge Replication

SQL Server 2000 build 8.00.0859
821334 FIX: Issues that are resolved in SQL Server 2000 Build 8.00.0859

SQL Server 2000 build 8.00.0863
829444 FIX: A floating point exception occurs during the optimization of a query

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

SQL Server 2000 build 8.00.0865
830395 FIX: An access violation occurs during compilation if the table contains statistics for a computed column

830382 FIX: Distributed queries may incorrectly use SQL Server startup account permissions when SQL Server is running in Fiber mode

830375 FIX: The global variable @@ERROR may return an incorrect value after a remote procedure call

830298 FIX: SQL Server 2000 SP3 may generate slower query plans and bad cardinality estimates

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

829183 FIX: The xp_sendmail extended stored procedure returns incorrect result set column widths when data in one of the result set columns contain DBCS characters in SQL Server 2000

821537 FIX: A deadlock condition may occur when you perform an UPDATE operation or a DELETE operation against a remote OLE DB provider in SQL Server 2000

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0867
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

SQL Server 2000 build 8.00.0869
830596 FIX: You receive an error message when the xp_logininfo extended stored procedure runs

830588 FIX: Access violation when you trace keyset-driven cursors by using SQL Profiler

SQL Server 2000 build 8.00.0870
830262 FIX: Unconditional update may not hold key locks on new key values

SQL Server 2000 build 8.00.0871
831302 FIX: SQL Server underestimates the cardinality of a query expression and query performance may be slow

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

830767 FIX: SQL Query Analyzer may stop responding when you close a query window or open a file

829386 FIX: You cannot install MSDE 2000 if the server service is not running

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0873
831675 FIX: You may receive incorrect results when you run a query that contains a UNION ALL operator, a TOP clause, and an ORDER BY clause

830912 FIX: Key names read from an .ini file for a dynamic properties task may be truncated

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

830773 FIX: You receive an EXCEPTION_ACCESS_VIOLATION error message when you try to save a DTS package in SQL Server 2000

SQL Server 2000 build 8.00.0876
831999 FIX: An AWE system uses more memory for sorting or for hashing than a non-AWE system in SQL Server 2000

831997 FIX: An invalid cursor state occurs after you apply hotfix 8.00.0859 or later in SQL Server 2000

SQL Server 2000 build 8.00.0878
832674 FIX: You receive a &quot;Failed to reserve contiguous memory of Size= &quot; error message when you run a query that has many predicates that are a sql_variant data type in SQL Server 2000

832437 FIX: A CHECKDB statement reports corruption after SQL Server transfers sql_variant data in SQL Server 2000

831950 FIX: You receive error message 3456 when you try to apply a transaction log to a server

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0879
832977 FIX: The DBCC PSS command may cause access violations and 17805 errors in SQL Server 2000

SQL Server 2000 build 8.00.0891
836141 FIX: An access violation exception may occur when SQL Server runs many parallel query processing operations on a multiprocessor computer

833406 FIX: Cardinality estimates for literals that are outside the histogram range are very low

SQL Server 2000 build 8.00.0892
833710 FIX: You receive an error message when you try to restore a database backup that spans multiple devices

SQL Server 2000 build 8.00.0904
834453 FIX: The Snapshot Agent may fail after you make schema changes to the underlying tables of a publication

834451 FIX: Restoring transaction log files takes longer than expected in SQL Server 2000

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0908
834688 FIX: You may receive a 913 error message if your query includes user-defined functions, derived tables, and JOINs

834290 FIX: You receive a 644 error message when you run an UPDATE statement and the isolation level is set to READ UNCOMMITTED

835581 FIX: An &quot;Error 17883&quot; error message may be logged, and SQL Server 2000 or SQL Server 7.0 may stop responding when you run an application that creates COM objects by using the sp_OACreate function

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0910
835864 FIX: Intermittent query slowdowns and corresponding high CPU utilization

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

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0911
836136 FIX: The compile time for a query that uses at least one outer join may be greater for SQL Server post-SP3 builds

836096 FIX: You may receive a 625 error message when you run a query that has a query plan that uses a nested loop join strategy

834923 FIX: The SQL Server cluster resource may be marked as Fail when you try to take it offline

834720 FIX: An error in a remote procedure call does not roll back the local operation

SQL Server 2000 build 8.00.0913
836839 FIX: Extended stored procedures in SQL Server 2000 may take longer to run when multiple users run the extended stored procedures at the same time

836651 FIX: You receive query results that were not expected when you use both ANSI joins and non-ANSI joins

309802 FIX: A call to a RAISERROR statement in a Transact-SQL batch can cause a SQLAgent job to fail and to lose output in SQL Server

SQL Server 2000 build 8.00.0915
837401 FIX: Rows are not successfully inserted into a table when you use the BULK INSERT command to insert rows

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0916
317989 FIX: Sqlakw32.dll may corrupt SQL statements

SQL Server 2000 build 8.00.0919
837957 FIX: When you use Transact-SQL cursor variables to perform operations that have large iterations, memory leaks may occur in SQL Server 2000

837890 FIX: The CPU column in the sysprocesses system table contains a negative value or an abnormal variation for some processes

SQL Server 2000 build 8.00.0922
838459 FIX: You may receive a BPool::Map warning when you create or rebuild indexes by using the awe enabled configuration option

<div class="moreinformation_section">

837970 FIX: You may receive an &quot;Invalid object name...&quot; error message when you run the DBCC CHECKCONSTRAINTS Transact-SQL statement on a table in SQL Server 2000

837969 FIX: You may receive an access violation in the CRowsetTraceData::FGetNextRow function when you trace server activity with SQL Profiler

837231 FIX: Distribution Agent may fail after you add or drop a column for a published article

833045 FIX: The xp_sendmail extended stored procedure does not run successfully in SQL Server 2000 SP2 or later

SQL Server 2000 build 8.00.0923
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

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0926
839523 FIX: An access violation exception may occur when you update a text column by using a stored procedure in SQL Server 2000

839458 FIX: An access violation exception may occur when you try to perform a Bulk Import operation to insert data in a SQL Server table

SQL Server 2000 build 8.00.0927
839688 FIX: Profiler RPC events truncate parameters that have a text data type to 16 characters

SQL Server 2000 build 8.00.0928
840166 FIX: The dynamic Snapshot Agent may fail when you use a dynamic snapshot for merge publications in SQL Server 2000

839884 FIX: A System.ExecutionEngineException exception occurs when you try to access the DTS DynamicPropertiesTaskAssignments collection

839589 FIX: The thread priority is raised for some threads in a parallel query

839986 FIX: The Mail Profile combo box is disabled when you use Enterprise Manager to view SQL Server agent properties, and you receive an error message when you try to use the xp_sendmail stored procedure from a DTS package in SQL Server 2000

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0929
840208 FIX: You receive a &quot;Msg 8649&quot; error message when you execute the DBCC CHECKDB statement in SQL Server 2000 Service Pack 3 (SP3)

839529 FIX: 8621 error conditions may cause SQL Server 2000 64-bit to close unexpectedly

SQL Server 2000 build 8.00.0933
840856 FIX: The MSSQLServer service exits unexpectedly in SQL Server 2000 Service Pack 3

840406 FIX: Queries that join a view may run slowly if the view contains outer joins

SQL Server 2000 build 8.00.0934
841404 FIX: You may receive a &quot;The query processor could not produce a query plan&quot; error message in SQL Server when you run a query that includes multiple subqueries that use self-joins

841175 FIX: You may receive an exception access violation for the Ssnetlib.dll file in SQL Server 2000

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0935
841401 FIX: You may notice incorrect values for the &quot;Active Transactions&quot; counter when you perform multiple transactions on an instance of SQL Server 2000 that is running on an SMP computer

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0936
841627 FIX: SQL Server 2000 may underestimate the cardinality of a query expression under certain circumstances

838409 FIX: SQL Server 2000 Service Pack 1 (S838409) and later builds may not generate an execution plan for a query, and you receive error message 8623

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0937
841776 FIX: Additional diagnostics have been added to SQL Server 2000 to detect unreported read operation failures

SQL Server 2000 build 8.00.0944
839280 FIX: SQL debugging does not work in Visual Studio .NET after you install Windows XP Service Pack 2

SQL Server 2000 build 8.00.0948
843263 FIX: You may receive an 8623 error message when you try to run a complex query on an instance of SQL Server

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0949
843267 FIX: Dynamic cursor retrieves the same row two times when you update the non-clustered index key to the same value

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

867746 FIX: The UPDATE query blocks the SELECT query when you run an UPDATE query and a SELECT query at the same time in SQL Server 2000

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0952
867880 FIX: Merge Agent may fail with an &quot;Invalid character value for cast specification&quot; error message

867879 FIX: Merge replication non-convergence occurs with SQL Server CE subscribers

867878 FIX: The Log Reader Agent may cause 17883 error messages

839096 FIX: An access violation exception may occur when you use PDH APIs to collect performance data for several instances of SQL Server at the same time

SQL Server 2000 build 8.00.0954
870972 FIX: The performance of a DML operation that fires a trigger may decrease when the trigger execution plan recompiles repeatedly

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

SQL Server 2000 build 8.00.0955
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

SQL Server 2000 build 8.00.0957
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

SQL Server 2000 build 8.00.0959
878500 FIX: An Audit Object Permission event is not produced when you run a TRUNCATE TABLE statement

872842 FIX: A CHECKDB statement reports a 2537 corruption error after SQL Server transfers data to a sql_variant column in SQL Server 2000

SQL Server 2000 build 8.00.0961
875445 FIX: An access violation exception may occur when you try to access SQL Server on a computer that is running under low memory conditions

873482 FIX: The restore process may take longer to complete when SQL Server 2000 restores transaction log files as part of the log shipping process

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

872843 FIX: The Log Reader Agent may fail and you receive an assertion error message

SQL Server 2000 build 8.00.0962
883415 FIX: A user-defined function returns results that are not correct for a query

SQL Server 2000 build 8.00.0967
884772 FIX: You may receive a 1203 error message when you perform a complex select query in SQL Server 2000 build 856 or a later version

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

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0970
884855 FIX: You receive an error message when you run a statement on a table that contains a trigger in SQL Server 2000

884854 FIX: You receive the “Could not find stored procedure” error message when you perform transactional replication with queued updating in SQL Server 2000

884853 FIX: Performance is slow when you update a subscribed table on a subscriber that uses queued updating in SQL Server 2000

885158 FIX: Section names are truncated to a total length of 254 characters when you use Data Transformation Services to create a Dynamic Properties task and you add an .ini file in SQL Server 2000

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0972
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

SQL Server 2000 build 8.00.0973
884856 FIX: The non-clustered index is corrupted after you perform a self-update query in SQL Server 2000

884554 FIX: A SPID stops responding with a NETWORKIO (0x800) waittype in SQL Server Enterprise Manager when SQL Server tries to process a fragmented TDS network packet

Note SQL Server 2000 build 8.00.097 is a baseline build that provides rollback capability for later hotfixes. You must install SQL Server 2000 build 8.00.097 before you install any SQL Server 2000 hotfix later than SQL Server 2000 build 8.00.097. Hotfixes can be rolled back only to the 8.00.097 baseline build.

SQL Server 2000 build 8.00.0977
885442 ] FIX: You receive a &quot;Server: Msg 8624, Level 16, State 1, Line 3 Internal SQL Server error.&quot; error message when you compile a delete query that contains sub-queries that use &quot;NOT IN&quot; clauses in SQL Server 2000

884850 FIX: When you run ad-hoc queries in Microsoft SQL Server 2000, ad-hoc query processing performance degradation may occur

843534 FIX: You may receive a 3628 error in SQL Server 2000 when you query many items that have an IN clause

884850 FIX: When you run ad-hoc queries in Microsoft SQL Server 2000, ad-hoc query processing performance degradation may occur

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0980
887974 FIX: A fetch on a dynamic cursor can cause unexpected results in SQL Server 2000 Service Pack 3

886708 FIX: Inserting lots of text, ntest, or image data over multiple concurrent connections takes a long time in SQL Server 2000

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0985
889239 FIX: Start times in the SQL Profiler are different for the Audit:Login and Audit:Logout Events in SQL Server 2000

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

888429 FIX: LIKE pattern matching may consider half-width and full-width characters to be equal even if width-sensitive collation is specified

890730 FIX: You receive a 17883 error message when you perform large in-memory sort operations in SQL Server 2000

888998 FIX: A query that joins two tables on smalldatetime data type columns, may produce incorrect results in SQL Server 2000

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0988
890637 FIX: You receive a 17883 error in the error log and LogWriter component does not yield correctly in SQL Server 2000

889170 FIX: You receive a &quot;Not enough storage is available to complete this operation&quot; error message when you run a Data Transformation Services package in SQL Server 2000

889166 FIX: You receive a &quot;Msg 3628&quot; error message when you run an inner join query in SQL Server 2000

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0990
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

SQL Server 2000 build 8.00.0991
889314 FIX: Non-convergence may occur in a merge replication topology if the primary connection to the publisher is disconnected

SQL Server 2000 build 8.00.0993
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

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

890742 FIX: Error message when you use a loopback linked server to run a distributed query in SQL Server 2000: &quot;Could not perform the requested operation because the minimum query memory is not available&quot;

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0994
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

890767 FIX: You receive a &quot;Server: Msg 107, Level 16, State 3, Procedure TEMP_VIEW_Merge, Line 1&quot; 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

890942 FIX: Some complex queries are slower after you install SQL Server 2000 Service Pack 2 or SQL Server 2000 Service Pack 3

<div class="moreinformation_section">

SQL Server 2000 build 8.00.0996
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

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

Note The following builds are not included in SQL Server 2000 Service Pack 4.

For more information about SQL Server 2000 Service Pack 4, click the following article number to view the article in the Microsoft Knowledge Base:

290211 How to obtain the latest SQL Server 2000 service pack

SQL Server 2000 build 8.00.1000
891585 FIX: Database recovery does not occur, or a user database is marked as suspect in SQL Server 2000

SQL Server 2000 build 8.00.1000
892392 FIX: Query performance may be slower if the query contains both a GROUP BY clause and a DISTINCT keyword on the same column

<div class="moreinformation_section">

SQL Server 2000 Build 8.00.1001
891719 FIX: You receive a 17803 error message when you run a SORT or CREATE INDEX operation on a computer that has several GB of physical RAM from SQL Server 2000

891707 FIX: A decrease in ad-hoc query processing may occur when you submit many ad-hoc queries without using defined parameters in SQL Server 2000

892205 FIX: You may receive a 17883 error message when SQL Server 2000 performs a very large hash operation

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

<div class="moreinformation_section">

SQL Server 2000 Build 8.00.1003
892923 FIX: Differential database backups may not contain database changes in the Page Free Space (PFS) pages in SQL Server 2000

<div class="moreinformation_section">

SQL Server 2000 Build 8.00.1007
893402 FIX: Two SQL Server user logins may be created for the same user 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

893312 FIX: You may receive a &quot;SQL Server could not spawn process_loginread thread&quot; error message, and a memory leak may occur when you cancel a remote query 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 on a 64-bit computer that has 16 GB or more GB of physical RAM

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

891640 FIX: The installation may fail when you try to install SQL Server 2000 hotfix build 8.00.0977 on a clustered or a stand-alone server computer that has large number of databases

892059 FIX: Hotfix packages that have build number 977 may not be installed correctly on SQL Server 2000 64-bit

<div class="moreinformation_section">

SQL Server 2000 Build 8.00.1009
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 &quot;Incorrect syntax near ')'&quot; error message when you run a script that was generated by SQL-DMO for an Operator object in SQL Server 2000

<div class="moreinformation_section">

SQL Server 2000 Build 8.00.1013
891866 FIX: The query runs slower than you expected when you try to parse a query in SQL Server 2000

<div class="moreinformation_section">

SQL Server 2000 Build 8.00.1014
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

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

<div class="moreinformation_section">

SQL Server 2000 Build 8.00.1017
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

<div class="moreinformation_section">

SQL Server 2000 Build 8.00.1019
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

Keywords: kbmbsmigrate kbsqlserv2000presp4fix kbqfe kbfix kbbug KB810185

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.