文章編號: 810185 - 上次校閱: 2006年4月20日 - 版次: 5.0 SQL Server 2000 Service Pack 3 和 3a 適用的 SQL Server 2000 Hotfix 更新在此頁中本文內容結論本文包含
Microsoft SQL Server 2000 Hotfix 的清單。您可以利用這份清單來判斷特定的 Hotfix 組建包含哪些
Hotfix。除非另有其他指定，先前組建中的所有 Hotfix 將會隨附於後續組建。這份清單包括了在 Microsoft SQL Server 2000
Service Pack 3 和 Microsoft SQL Server 2000 Service Pack 3a 之後發行的所有公用
Hotfix。 這裡提供有關 Microsoft SQL Server 2000 Hotfix 的重要注意事項。
其他相關資訊先決條件
套用更新之前，您必須先安裝 SQL Server 2000 Service Pack 3 (SP3) 或 SQL Server 2000 Service Pack 3a (SP3a)。如果要下載 SQL Server 2000 Service Pack 3a，請造訪下列 Microsoft 網站： SQL Server 2000 Service Pack 3a (SP3a)
(http://support.microsoft.com/?kbid=290211)
如何識別您的 SQL Server Service Pack 和版本如果要判斷您所執行的 SQL Server 版本，請參閱「Microsoft 知識庫」中的下列文件：321185?
(http://support.microsoft.com/kb/321185/
)
如何識別 SQL Server 的版本
SQL Server 2000 基礎組建Microsoft SQL Server 可能不定時發行 Microsoft SQL Server 2000 的「基礎」組建。此基礎組建提供諸如復原等功能的支援。您可能必須安裝基礎組建，才能安裝任何以後的 Hotfix。下列為 SQL Server 2000 基礎組建的清單：
Hotfix 更新資訊下列清單包含所有在 SQL Server 2000 Service Pack 3 和 SQL Server 2000 Service Pack 3a 之後發行的公用 SQL Server 2000 Hotfix。SQL Server 2000 組建 8.00.0762814032?
(http://support.microsoft.com/kb/814032/
)
FIX: Merge publications cannot synchronize on SQL Server 2000 Service Pack 3
SQL Server 2000 組建 8.00.0763 814113?
(http://support.microsoft.com/kb/814113/
)
FIX: DTS Designer may generate an access violation after you install SQL Server 2000 Service Pack 3
SQL Server 2000 組建 8.00.0765814916 ?
(http://support.microsoft.com/kb/814916/
)
FIX: Merge Agent for a filtered publication might fail
814894?
(http://support.microsoft.com/kb/814894/
)
FIX: The Xp_readmail stored procedure only saves the text of an embedded attachment
814665 ?
(http://support.microsoft.com/kb/814665/
)
FIX: SQL Server Assertion:"nret == FALSE" occurs when you insert or update table data in SQL Server 2000
814509?
(http://support.microsoft.com/kb/814509/
)
FIX: A parallel query with a COUNT aggregate function may return unexpected results
814654?
(http://support.microsoft.com/kb/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 組建 8.00.0769815199?
(http://support.microsoft.com/kb/815199/
)
FIX: Profiler does not report CPU column value for RPC:Completed events correctly
815008?
(http://support.microsoft.com/kb/815008/
)
FIX: Query with Transaction Isolation Level set to READ UNCOMMITTED fails with error 601
814893?
(http://support.microsoft.com/kb/814893/
)
FIX: Error message: "Insufficient key column information for updating" occurs in SQL Server 2000 SP3
814889?
(http://support.microsoft.com/kb/814889/
)
FIX: A DELETE statement with a JOIN might fail and you receive a 625 error
SQL Server 2000 組建 8.00.0775815115?
(http://support.microsoft.com/kb/815115/
)
FIX: A DTS package that uses global variables ignores error message raised by RAISERROR
SQL Server 2000 組建 8.00.0779814035?
(http://support.microsoft.com/kb/814035/
)
FIX: A full-text population fails after you apply SQL Server 2000 Service Pack 3
SQL Server 2000 組建 8.00.0780816084?
(http://support.microsoft.com/kb/816084/
)
FIX: sysindexes.statblob column may be corrupted after you run a DBCC DBREINDEX statement
816069?
(http://support.microsoft.com/kb/816069/
)
FIX: A query with a large IN clause can cause concurrency issues
816039?
(http://support.microsoft.com/kb/816039/
)
FIX: Code point comparison semantics for SQL_Latin1_General_Cp850_BIN collation
815593?
(http://support.microsoft.com/kb/815593/
)
FIX: Incorrect cardinality estimates for NOT EXISTS predicates after you upgrade to SQL Server 2000 Service Pack 3
815592?
(http://support.microsoft.com/kb/815592/
)
FIX: Incorrect remoting of a predicate as a sub-SELECT function after SQL Server 2000 Service Pack 3 upgrade
815114?
(http://support.microsoft.com/kb/815114/
)
FIX: Excessive optimizer memory consumption may occur for queries that have multiple OUTER JOINS
815056?
(http://support.microsoft.com/kb/815056/
)
FIX：如果檢查點處理程序延遲了 SQL Server 資料庫活動，而且沒有正確產生排程器的話，就會出現「錯誤：17883」錯誤訊息。
815183?
(http://support.microsoft.com/kb/815183/
)
FIX: You receive error 5180 when you run a parallel query and the combined maximum size of all of the search arguments exceeds 8 KB
814997?
(http://support.microsoft.com/kb/814997/
)
FIX: The header information may not be included when the query parameter has a COMPUTE clause
812915?
(http://support.microsoft.com/kb/812915/
)
FIX: "Performance monitor shared memory setup failed:-1" error message when you start SQL Server
SQL Server 2000 組建 8.00.0781815057?
(http://support.microsoft.com/kb/815057/
)
FIX: SQL Server 2000 uninstall option does not remove all files
SQL Server 2000 組建 8.00.0788816985?
(http://support.microsoft.com/kb/816985/
)
FIX: You cannot install SQL Server 2000 SP3 on the Korean version of SQL Server 2000
SQL Server 2000 組建 8.00.0789817368?
(http://support.microsoft.com/kb/817368/
)
FIX: An INSERT or UPDATE that results in a page split might fail with Error 818
817359?
(http://support.microsoft.com/kb/817359/
)
FIX: An access violation may occur when you run an INSERT statement in an nText column
817263?
(http://support.microsoft.com/kb/817263/
)
FIX: A SELECT statement against a view might not return qualifying rows
817262?
(http://support.microsoft.com/kb/817262/
)
FIX: Complex query may not create an execution plan
817186?
(http://support.microsoft.com/kb/817186/
)
FIX: A query that performs join operations between multiple tables may return incorrect results
816840?
(http://support.microsoft.com/kb/816840/
)
FIX: Error 17883 may display message text that is not correct
816780?
(http://support.microsoft.com/kb/816780/
)
FIX: Merge Agent failures with articles that have indexed views defined
816503?
(http://support.microsoft.com/kb/816503/
)
FIX: Floating point exception (Error 3628) might occur for queries that need merged histograms
314128?
(http://support.microsoft.com/kb/314128/
)
FIX: Access violation occurs when an RPC call is made that includes a bit parameter value that is not valid
SQL Server 2000 組建 8.00.0790817081?
(http://support.microsoft.com/kb/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 組建 8.00.0791815249?
(http://support.microsoft.com/kb/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 組建 8.00.0794817709?
(http://support.microsoft.com/kb/817709/
)
FIX: SQL Server 2000 might produce an incorrect cardinality estimate for outer joins
816883?
(http://support.microsoft.com/kb/816883/
)
FIX: SQL Server optimizer may underestimate the cardinality of range queries
816440?
(http://support.microsoft.com/kb/816440/
)
FIX: Error 8623 is raised when SQL Server compiles a complex query
813524?
(http://support.microsoft.com/kb/813524/
)
FIX: OLE DB conversion errors may occur after you select a literal string that represents datetime data as a column
SQL Server 2000 組建 8.00.0798817464?
(http://support.microsoft.com/kb/817464/
)
FIX: Using Sp_executesql in Merge Agent operations
SQL Server 2000 組建 8.00.0800828269?
(http://support.microsoft.com/kb/828269/
)
FIX: A Transact-SQL query that uses views may fail unexpectedly in SQL Server 2000 SP3
818188?
(http://support.microsoft.com/kb/818188/
)
FIX: Query on the sysmembers virtual table may fail with a stack overflow
818097?
(http://support.microsoft.com/kb/818097/
)
FIX: An access violation may occur when you run DBCC DBREINDEX on a table that has hypothetical indexes
818095?
(http://support.microsoft.com/kb/818095/
)
FIX: Cursor plans are not removed from the cache when virtual memory depleted
817780?
(http://support.microsoft.com/kb/817780/
)
FIX: A complex query is not successful on a server that has more than 2 GB of memory
816937?
(http://support.microsoft.com/kb/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 組建 8.00.0801818540?
(http://support.microsoft.com/kb/818540/
)
FIX: SQL Server Enterprise Manager quits unexpectedly when you modify a DTS package
818414?
(http://support.microsoft.com/kb/818414/
)
FIX: The Sqldumper.exe file does not generate a userdump file when it runs against a Windows service
816834?
(http://support.microsoft.com/kb/816834/
)
FIX: Osql.exe may not run batches as fast as other ODBC-based applications
SQL Server 2000 組建 8.00.0804818729?
(http://support.microsoft.com/kb/818729/
)
FIX: Internal query processor Error 8623 when Microsoft SQL Server tries to compile a plan for a complex query
SQL Server 2000 組建 8.00.0807818899?
(http://support.microsoft.com/kb/818899/
)
FIX: Error message 3628 may occur when you run a complex query
SQL Server 2000 組建 8.00.0811819955?
(http://support.microsoft.com/kb/819955/
)
FIX: Using xp_sendmail with a COMPUTE clause causes an access violation
819248?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/818897/
)
FIX: Invalid TDS sent to SQL Server results in access violation
SQL Server 2000 組建 8.00.0814819662?
(http://support.microsoft.com/kb/819662/
)
FIX: Distribution Cleanup Agent incorrectly cleans up entries for anonymous subscribers
SQL Server 2000 組建 8.00.0816820837?
(http://support.microsoft.com/kb/820837/
)
FIX: Allocation Caching Mechanisms Enable Faster Allocation of Pages to Objects
820835?
(http://support.microsoft.com/kb/820835/
)
FIX: SQL Server Might Take a Long Time to Recover After an Abrupt or Unexpected Server Shutdown
818769?
(http://support.microsoft.com/kb/818769/
)
FIX: Trace Flag -T8002 Treats an Affinity Mask Like a Process Affinity
818768?
(http://support.microsoft.com/kb/818768/
)
FIX: Cannot Set SQL Server Instance Specific Network Affinity
818767?
(http://support.microsoft.com/kb/818767/
)
FIX: Improved CPU Usage for Database Logging When Transaction Log Stalls Occur
818766?
(http://support.microsoft.com/kb/818766/
)
FIX: Intense SQL Server activity results in spinloop wait
332004?
(http://support.microsoft.com/kb/332004/
)
FIX: SQL Server scalability may be limited if AWE is enabled
SQL Server 2000 組建 8.00.0818818806?
(http://support.microsoft.com/kb/818806/
)
FIX: 停用具名管道通訊協定之後，某些具名管道功能並沒有被停用
814950?
(http://support.microsoft.com/kb/814950/
)
FIX: A computer might transmit nonencrypted data when clients use the Multiprotocol Net-Library with the encryption option enabled
814919?
(http://support.microsoft.com/kb/814919/
)
FIX: No message appears when a blank password is set for a system administrator login in SQL Server Enterprise Manager
SQL Server 2000 組建 8.00.0819826161?
(http://support.microsoft.com/kb/826161/
)
FIX: 在變更標準 SQL Server 登入後提示您確認密碼
SQL Server 2000 組建 8.00.0837825884?
(http://support.microsoft.com/kb/825884/
)
FIX: The dynamic query statement appears in the query execution plan of an encrypted stored procedure
825883?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/825045/
)
FIX: The Merge Agent takes a long time to download new data when it runs on a new anonymous subscription
825019?
(http://support.microsoft.com/kb/825019/
)
FIX: A linked server query fails with the error message "Statement(s) could not be prepared" in SQL Server 2000
824227?
(http://support.microsoft.com/kb/824227/
)
FIX: A SELECT statement that contains computed columns and invalid filter condition values may cause an access violation
823514?
(http://support.microsoft.com/kb/823514/
)
FIX: Build 8.00.0837:A query that contains a correlated subquery runs slowly
823455?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/822757/
)
FIX: An Insert select command with OPENXML and a Sql_variant type can cause error 2537 to occur
822747?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/822746/
)
FIX: Incorrect results from a parallel query that uses a UNION and variables or parameters
822668?
(http://support.microsoft.com/kb/822668/
)
FIX: "Connection is busy with results for another command" error message occurs when you run a linked server query
821535?
(http://support.microsoft.com/kb/821535/
)
FIX: Merge replication fails with error 207 while generating a snapshot
821806?
(http://support.microsoft.com/kb/821806/
)
FIX: SQL Server may generate an incorrect SQL script for a table constraint when you use the "Generate SQL Script" option in Enterprise Manager
821688?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/821548/
)
FIX: A parallel query may generate an access violation after you install SQL Server 2000 SP3
820788?
(http://support.microsoft.com/kb/820788/
)
FIX: Delayed domain authentication may cause SQL Server to stop responding
819829?
(http://support.microsoft.com/kb/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 "EXECUTE permission denied on object..." error message in SQL Server 2000
821740?
(http://support.microsoft.com/kb/821740/
)
FIX: MS DTC transaction commit operation blocks itself
821537?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/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
SQL Server 2000 組建 8.00.0839824028?
(http://support.microsoft.com/kb/824028/
)
FIX: An outer or semi JOIN query that results in hash role reversal followed by a spill may return incorrect results
824027?
(http://support.microsoft.com/kb/824027/
)
FIX: A cursor with a large object parameter may cause an access violation on CStmtCond::XretExecute
824018?
(http://support.microsoft.com/kb/824018/
)
FIX: Parallel query that uses an indexed bit column may return results that are not correct
823877?
(http://support.microsoft.com/kb/823877/
)
FIX: An access violation may occur when you run a query that contains 32,000 or more OR clauses
SQL Server 2000 組建 8.00.0840825042?
(http://support.microsoft.com/kb/825042/
)
FIX: SQL Server jobs that are owned by non-sysadmin users may not start
825025?
(http://support.microsoft.com/kb/825025/
)
FIX: You cannot synchronize between a replication publisher and a replication republisher
824430?
(http://support.microsoft.com/kb/824430/
)
FIX: Performance decreases over time when you back up files in SQL Server 2000
319477?
(http://support.microsoft.com/kb/319477/
)
FIX: Extremely large number of user tables on AWE system may cause BPool::Map errors
825197?
(http://support.microsoft.com/kb/825197/
)
FIX: You receive error 3624 and the user database is marked suspect after you perform a bulk insert operation in SQL Server 2000
SQL Server 2000 組建 8.00.0841825225?
(http://support.microsoft.com/kb/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 組建 8.00.0842825043?
(http://support.microsoft.com/kb/825043/
)
FIX: Rows are unexpectedly deleted when you run a distributed query to delete or to update a linked server table
SQL Server 2000 組建 8.00.0844826080?
(http://support.microsoft.com/kb/826080/
)
FIX: SQL Server 2000 protocol encryption applies to JDBC clients
SQL Server 2000 組建 8.00.0845826364?
(http://support.microsoft.com/kb/826364/
)
FIX: A query with a LIKE comparison results in a non-optimal query plan when you use a Hungarian SQL Server collation
825854?
(http://support.microsoft.com/kb/825854/
)
FIX: No exclusive locks may be taken if the DisAllowsPageLocks value is set to true
SQL Server 2000 組建 8.00.0847826433?
(http://support.microsoft.com/kb/826433/
)
PRB: Additional SQL Server diagnostics added to detect unreported I/O problems
SQL Server 2000 組建 8.00.0848826822?
(http://support.microsoft.com/kb/826822/
)
FIX: A member of the db_accessadmin fixed database role can create an alias for the dbo special user
SQL Server 2000 組建 8.00.0850826906?
(http://support.microsoft.com/kb/826906/
)
FIX: A query that uses a view that contains a correlated subquery and an aggregate runs slowly
826860?
(http://support.microsoft.com/kb/826860/
)
FIX: Linked server query may return NULL if it is performed through a keyset cursor
826815?
(http://support.microsoft.com/kb/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 組建 8.00.0851826754?
(http://support.microsoft.com/kb/826754/
)
FIX: A deadlock occurs if you run an explicit UPDATE STATISTICS command
827178?
(http://support.microsoft.com/kb/827178/
)
FIX: You may receive a 644 error message when you run concurrent transactions on a heap
827175?
(http://support.microsoft.com/kb/827175/
)
FIX: Incorrect parameter numbering occurs in custom stored procedures that are generated with the Sp_scriptpublicationcustomprocs stored procedure
SQL Server 2000 組建 8.00.0852830466?
(http://support.microsoft.com/kb/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
827954?
(http://support.microsoft.com/kb/827954/
)
FIX: Slow execution times may occur when you run DML statements against tables that have cascading referential integrity
SQL Server 2000 組建 8.00.0854828699?
(http://support.microsoft.com/kb/828699/
)
FIX: An access violation occurs when you run DBCC UPDATEUSAGE on a database that has many objects
818079?
(http://support.microsoft.com/kb/818079/
)
FIX: SQL Profiler displays incorrect TextData value when you run a nested stored procedure by using a remote procedure call
SQL Server 2000 組建 8.00.0856828096?
(http://support.microsoft.com/kb/828096/
)
FIX: Key locks are held until the end of the statement for rows that do not pass filter criteria
SQL Server 2000 組建 8.00.0857828308?
(http://support.microsoft.com/kb/828308/
)
FIX: An Internet Explorer script error occurs when you access metadata information by using DTS in SQL Server Enterprise Manager
827714?
(http://support.microsoft.com/kb/827714/
)
FIX: A query may fail with retail assertion when you use the NOLOCK hint or the READ UNCOMMITTED isolation level
SQL Server 2000 組建 8.00.0858828637?
(http://support.microsoft.com/kb/828637/
)
FIX: Users can control the compensating change process in Merge Replication
SQL Server 2000 組建 8.00.0859821334?
(http://support.microsoft.com/kb/821334/
)
FIX: Issues that are resolved in SQL Server 2000 Build 8.00.0859
SQL Server 2000 組建 8.00.0863829444?
(http://support.microsoft.com/kb/829444/
)
FIX: A floating point exception occurs during the optimization of a query
829205?
(http://support.microsoft.com/kb/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 組建 8.00.0865830395?
(http://support.microsoft.com/kb/830395/
)
FIX: An access violation occurs during compilation if the table contains statistics for a computed column
830382?
(http://support.microsoft.com/kb/830382/
)
FIX: Distributed queries may incorrectly use SQL Server startup account permissions when SQL Server is running in Fiber mode
830375?
(http://support.microsoft.com/kb/830375/
)
FIX: The global variable @@ERROR may return an incorrect value after a remote procedure call
830298?
(http://support.microsoft.com/kb/830298/
)
FIX: SQL Server 2000 SP3 may generate slower query plans and bad cardinality estimates
828945?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/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
SQL Server 2000 組建 8.00.0867830366?
(http://support.microsoft.com/kb/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 組建 8.00.0869830596?
(http://support.microsoft.com/kb/830596/
)
FIX: You receive an error message when the xp_logininfo extended stored procedure runs
830588?
(http://support.microsoft.com/kb/830588/
)
FIX: Access violation when you trace keyset-driven cursors by using SQL Profiler
SQL Server 2000 組建 8.00.0870830262?
(http://support.microsoft.com/kb/830262/
)
FIX: Unconditional update may not hold key locks on new key values
SQL Server 2000 組建 8.00.0871831302?
(http://support.microsoft.com/kb/831302/
)
FIX: SQL Server underestimates the cardinality of a query expression and query performance may be slow
830860?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/830767/
)
FIX: SQL Query Analyzer may stop responding when you close a query window or open a file
829386?
(http://support.microsoft.com/kb/829386/
)
FIX: You cannot install MSDE 2000 if the server service is not running
SQL Server 2000 組建 8.00.0873831675?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/830912/
)
FIX: Key names read from an .ini file for a dynamic properties task may be truncated
830887?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/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 組建 8.00.0876831999?
(http://support.microsoft.com/kb/831999/
)
FIX: An AWE system uses more memory for sorting or for hashing than a non-AWE system in SQL Server 2000
831997?
(http://support.microsoft.com/kb/831997/
)
FIX: An invalid cursor state occurs after you apply hotfix 8.00.0859 or later in SQL Server 2000
SQL Server 2000 組建 8.00.0878832674?
(http://support.microsoft.com/kb/832674/
)
FIX: You receive a "Failed to reserve contiguous memory of Size= <size>" error message when you run a query that has many predicates that are a sql_variant data type in SQL Server 2000
832437?
(http://support.microsoft.com/kb/832437/
)
FIX: A CHECKDB statement reports corruption after SQL Server transfers sql_variant data in SQL Server 2000
831950?
(http://support.microsoft.com/kb/831950/
)
FIX: You receive error message 3456 when you try to apply a transaction log to a server
SQL Server 2000 組建 8.00.0879832977?
(http://support.microsoft.com/kb/832977/
)
FIX: The DBCC PSS command may cause access violations and 17805 errors in SQL Server 2000
SQL Server 2000 組建 8.00.0891836141?
(http://support.microsoft.com/kb/836141/
)
FIX: An access violation exception may occur when SQL Server runs many parallel query processing operations on a multiprocessor computer
833406?
(http://support.microsoft.com/kb/833406/
)
FIX: Cardinality estimates for literals that are outside the histogram range are very low
SQL Server 2000 組建 8.00.0892833710?
(http://support.microsoft.com/kb/833710/
)
FIX: You receive an error message when you try to restore a database backup that spans multiple devices
SQL Server 2000 組建 8.00.0904834453?
(http://support.microsoft.com/kb/834453/
)
FIX: The Snapshot Agent may fail after you make schema changes to the underlying tables of a publication
834451?
(http://support.microsoft.com/kb/834451/
)
FIX: Restoring transaction log files takes longer than expected in SQL Server 2000
SQL Server 2000 組建 8.00.0908834688?
(http://support.microsoft.com/kb/834688/
)
FIX: You may receive a 913 error message if your query includes user-defined functions, derived tables, and JOINs
834290?
(http://support.microsoft.com/kb/834290/
)
FIX: You receive a 644 error message when you run an UPDATE statement and the isolation level is set to READ UNCOMMITTED
SQL Server 2000 組建 8.00.0910835864?
(http://support.microsoft.com/kb/835864/
)
FIX: Intermittent query slowdowns and corresponding high CPU utilization
834798?
(http://support.microsoft.com/kb/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
SQL Server 2000 組建 8.00.0911836136?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/834923/
)
FIX: The SQL Server cluster resource may be marked as Fail when you try to take it offline
834720?
(http://support.microsoft.com/kb/834720/
)
FIX: An error in a remote procedure call does not roll back the local operation
SQL Server 2000 組建 8.00.0913836839?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/836651/
)
FIX: You receive query results that were not expected when you use both ANSI joins and non-ANSI joins
309802?
(http://support.microsoft.com/kb/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 組建 8.00.0915837401?
(http://support.microsoft.com/kb/837401/
)
FIX: Rows are not successfully inserted into a table when you use the BULK INSERT command to insert rows
SQL Server 2000 組建 8.00.0916317989?
(http://support.microsoft.com/kb/317989/
)
FIX: Sqlakw32.dll may corrupt SQL statements
SQL Server 2000 組建 8.00.0919837957?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/837890/
)
FIX: The CPU column in the sysprocesses system table contains a negative value or an abnormal variation for some processes
SQL Server 2000 組建 8.00.0922838459?
(http://support.microsoft.com/kb/838459/
)
FIX: You may receive a BPool::Map warning when you create or rebuild indexes by using the awe enabled configuration option
837970?
(http://support.microsoft.com/kb/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
837969?
(http://support.microsoft.com/kb/837969/
)
FIX: You may receive an access violation in the CRowsetTraceData::FGetNextRow function when you trace server activity with SQL Profiler
837231?
(http://support.microsoft.com/kb/837231/
)
FIX: Distribution Agent may fail after you add or drop a column for a published article
833045?
(http://support.microsoft.com/kb/833045/
)
FIX: The xp_sendmail extended stored procedure does not run successfully in SQL Server 2000 SP2 or later
SQL Server 2000 組建 8.00.0923838460?
(http://support.microsoft.com/kb/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
SQL Server 2000 組建 8.00.0926839523?
(http://support.microsoft.com/kb/839523/
)
FIX: An access violation exception may occur when you update a text column by using a stored procedure in SQL Server 2000
839458?
(http://support.microsoft.com/kb/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 組建 8.00.0927839688?
(http://support.microsoft.com/kb/839688/
)
FIX: Profiler RPC events truncate parameters that have a text data type to 16 characters
SQL Server 2000 組建 8.00.0928840166?
(http://support.microsoft.com/kb/840166/
)
FIX: The dynamic Snapshot Agent may fail when you use a dynamic snapshot for merge publications in SQL Server 2000
839884?
(http://support.microsoft.com/kb/839884/
)
FIX: A System.ExecutionEngineException exception occurs when you try to access the DTS DynamicPropertiesTaskAssignments collection
839589?
(http://support.microsoft.com/kb/839589/
)
FIX: The thread priority is raised for some threads in a parallel query
SQL Server 2000 組建 8.00.0929840208?
(http://support.microsoft.com/kb/840208/
)
FIX: You receive a "Msg 8649" error message when you execute the DBCC CHECKDB statement in SQL Server 2000 Service Pack 3 (SP3)
839529?
(http://support.microsoft.com/kb/839529/
)
FIX: 8621 error conditions may cause SQL Server 2000 64-bit to close unexpectedly
SQL Server 2000 組建 8.00.0933840856?
(http://support.microsoft.com/kb/840856/
)
FIX: The MSSQLServer service exits unexpectedly in SQL Server 2000 Service Pack 3
840406?
(http://support.microsoft.com/kb/840406/
)
FIX: Queries that join a view may run slowly if the view contains outer joins
SQL Server 2000 組建 8.00.0934841404?
(http://support.microsoft.com/kb/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
841175?
(http://support.microsoft.com/kb/841175/
)
FIX: You may receive an exception access violation for the Ssnetlib.dll file in SQL Server 2000
SQL Server 2000 組建 8.00.0935841401?
(http://support.microsoft.com/kb/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
SQL Server 2000 組建 8.00.0936841627?
(http://support.microsoft.com/kb/841627/
)
FIX: SQL Server 2000 may underestimate the cardinality of a query expression under certain circumstances
838409?
(http://support.microsoft.com/kb/838409/
)
FIX: SQL Server 2000 Service Pack 1 (SP1) and later builds may not generate an execution plan for a query, and you receive error message 8623
SQL Server 2000 組建 8.00.0937841776?
(http://support.microsoft.com/kb/841776/
)
FIX: Additional diagnostics have been added to SQL Server 2000 to detect unreported read operation failures
SQL Server 2000 組建 8.00.0944839280?
(http://support.microsoft.com/kb/839280/
)
FIX: SQL debugging does not work in Visual Studio .NET after you install Windows XP Service Pack 2
SQL Server 2000 組建 8.00.0948843263?
(http://support.microsoft.com/kb/843263/
)
FIX: You may receive an 8623 error message when you try to run a complex query on an instance of SQL Server
SQL Server 2000 組建 8.00.0949843267?
(http://support.microsoft.com/kb/843267/
)
FIX: Dynamic cursor retrieves the same row two times when you update the non-clustered index key to the same value
843266?
(http://support.microsoft.com/kb/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)
SQL Server 2000 組建 8.00.0952867880?
(http://support.microsoft.com/kb/867880/
)
FIX: Merge Agent may fail with an "Invalid character value for cast specification" error message
867879?
(http://support.microsoft.com/kb/867879/
)
FIX: Merge replication non-convergence occurs with SQL Server CE subscribers
867878?
(http://support.microsoft.com/kb/867878/
)
FIX: The Log Reader Agent may cause 17883 error messages
839096?
(http://support.microsoft.com/kb/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 組建 8.00.0954870972?
(http://support.microsoft.com/kb/870972/
)
FIX: The performance of a DML operation that fires a trigger may decrease when the trigger execution plan recompiles repeatedly
843282?
(http://support.microsoft.com/kb/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 組建 8.00.0955867798?
(http://support.microsoft.com/kb/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 組建 8.00.0957870994?
(http://support.microsoft.com/kb/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 組建 8.00.0959878500?
(http://support.microsoft.com/kb/878500/
)
FIX: An Audit Object Permission event is not produced when you run a TRUNCATE TABLE statement
872842?
(http://support.microsoft.com/kb/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 組建 8.00.0961875445?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/872843/
)
FIX: The Log Reader Agent may fail and you receive an assertion error message
SQL Server 2000 組建 8.00.0962883415?
(http://support.microsoft.com/kb/883415/
)
FIX: A user-defined function returns results that are not correct for a query
SQL Server 2000 組建 8.00.0967884772?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/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
SQL Server 2000 組建 8.00.0970884855?
(http://support.microsoft.com/kb/884855/
)
FIX: You receive an error message when you run a statement on a table that contains a trigger in SQL Server 2000
884854?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/884853/
)
FIX: Performance is slow when you update a subscribed table on a subscriber that uses queued updating in SQL Server 2000
885158?
(http://support.microsoft.com/kb/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
SQL Server 2000 組建 8.00.0972885290?
(http://support.microsoft.com/kb/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 組建 8.00.0973884856?
(http://support.microsoft.com/kb/884856/
)
FIX: The non-clustered index is corrupted after you perform a self-update query in SQL Server 2000
884554?
(http://support.microsoft.com/kb/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
注意 SQL Server 2000 組建 8.00.097 是提供後續 Hotfix 復原功能的基礎組建。安裝 SQL Server
2000 組建 8.00.097 以後的任何 Hotfix 之前，您必須先安裝 SQL Server 2000 組建 8.00.097。Hotfix
只可以復原至 8.00.097 基礎組建。SQL Server 2000 組建 8.00.0977885442?
(http://support.microsoft.com/kb/885442/
)
FIX: You receive a "Server:Msg 8624, Level 16, State 1, Line 3 Internal SQL Server error." error message when you compile a delete query that contains sub-queries that use "NOT IN" clauses in SQL Server 2000
884850?
(http://support.microsoft.com/kb/884850/
)
FIX: When you run ad-hoc queries in Microsoft SQL Server 2000, ad-hoc query processing performance degradation may occur
843534?
(http://support.microsoft.com/kb/843534/
)
FIX: You may receive a 3628 error in SQL Server 2000 when you query many items that have an IN clause
884850?
(http://support.microsoft.com/kb/884850/
)
FIX: When you run ad-hoc queries in Microsoft SQL Server 2000, ad-hoc query processing performance degradation may occur
SQL Server 2000 組建 8.00.0980887974?
(http://support.microsoft.com/kb/887974/
)
FIX: A fetch on a dynamic cursor can cause unexpected results in SQL Server 2000 Service Pack 3
886708?
(http://support.microsoft.com/kb/886708/
)
FIX: Inserting lots of text, ntext, or image data over multiple concurrent connections takes a long time in SQL Server 2000
SQL Server 2000 組建 8.00.0985889239?
(http://support.microsoft.com/kb/889239/
)
FIX: Start times in the SQL Profiler are different for the Audit:Login and Audit:Logout Events in SQL Server 2000
888444?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/888429/
)
FIX: LIKE pattern matching may consider half-width and full-width characters to be equal even if width-sensitive collation is specified
890730?
(http://support.microsoft.com/kb/890730/
)
FIX: You receive a 17883 error message when you perform large in-memory sort operations in SQL Server 2000
888998?
(http://support.microsoft.com/kb/888998/
)
FIX: A query that joins two tables on smalldatetime data type columns, may produce incorrect results in SQL Server 2000
SQL Server 2000 組建 8.00.0988890637?
(http://support.microsoft.com/kb/890637/
)
FIX: A 17883 error is written to the SQL Server 2000 error log and the LogWriter component does not yield correctly
889170?
(http://support.microsoft.com/kb/889170/
)
FIX: You receive a "Not enough storage is available to complete this operation" error message when you run a Data Transformation Services package in SQL Server 2000
889166?
(http://support.microsoft.com/kb/889166/
)
FIX: You receive a "Msg 3628" error message when you run an inner join query in SQL Server 2000
SQL Server 2000 組建 8.00.0990890200?
(http://support.microsoft.com/kb/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 組建 8.00.0991889314?
(http://support.microsoft.com/kb/889314/
)
FIX: Non-convergence may occur in a merge replication topology if the primary connection to the publisher is disconnected
SQL Server 2000 組建 8.00.0993890925?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/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
SQL Server 2000 組建 8.00.0994890768?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/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
890942?
(http://support.microsoft.com/kb/890942/
)
FIX: Some complex queries are slower after you install SQL Server 2000 Service Pack 2 or SQL Server 2000 Service Pack 3
SQL Server 2000 組建 8.00.0996891268?
(http://support.microsoft.com/kb/891268/
)
FIX: You receive a 17883 error message and SQL Server 2000 may stop responding to other requests when you perform large in-memory sort operations
891017?
(http://support.microsoft.com/kb/891017/
)
FIX: SQL Server 2000 may stop responding to other requests when you perform a large deallocation operation
891201?
(http://support.microsoft.com/kb/891201/
)
FIX: Performance is significantly reduced when you set trace flag 9134 to prevent error message 601 in SQL Server 2000
注意 下列組建不包含在 SQL Server 2000 Service Pack 4 中。 如需有關 SQL Server 2000 Service Pack 4 的詳細資訊，請按一下下面的文件編號，檢視「Microsoft 知識庫」中的文件： 290211?
(http://support.microsoft.com/kb/290211/
)
如何取得最新版 SQL Server 2000 Service Pack
SQL Server 2000 組建 8.00.1000891585?
(http://support.microsoft.com/kb/891585/
)
FIX: Database recovery does not occur, or a user database is marked as suspect in SQL Server 2000
SQL Server 2000 組建 8.00.1000892392?
(http://support.microsoft.com/kb/892392/
)
FIX: Query performance may be slower if the query contains both a GROUP BY clause and a DISTINCT keyword on the same column
SQL Server 2000 組建 8.00.1001891719?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/892205/
)
FIX: You may receive a 17883 error message when SQL Server 2000 performs a very large hash operation
892551?
(http://support.microsoft.com/kb/892551/
)
FIX: You receive a SqlException error message when you call the sp_addmergepublication stored procedure when the Active Directory directory service is not available in SQL Server 2000
SQL Server 2000 組建 8.00.1003892923?
(http://support.microsoft.com/kb/892923/
)
FIX: Differential database backups may not contain database changes in the Page Free Space (PFS) pages in SQL Server 2000
SQL Server 2000 組建 8.00.1007893402?
(http://support.microsoft.com/kb/893402/
)
FIX: Two SQL Server user logins may be created for the same user in SQL Server 2000
893172?
(http://support.microsoft.com/kb/893172/
)
FIX: An access violation may occur when you use the READPAST lock hint and you use a non-clustered index in your query in SQL Server 2000
893312?
(http://support.microsoft.com/kb/893312/
)
FIX: You may receive a "SQL Server could not spawn process_loginread thread" error message, and a memory leak may occur when you cancel a remote query in SQL Server 2000
892940?
(http://support.microsoft.com/kb/892940/
)
FIX: You experience delays and receive a 17883 error message when SQL Server 2000 performs a large and complex query plan that uses hash operators on a 64-bit computer that has 16 GB or more GB of physical RAM
892840?
(http://support.microsoft.com/kb/892840/
)
FIX: 17883 errors may be written to the SQL Server error log when you run a query that generates many floating point exception errors in SQL Server 2000
891640?
(http://support.microsoft.com/kb/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?
(http://support.microsoft.com/kb/892059/
)
FIX: Hotfix packages that have build number 977 may not be installed correctly on SQL Server 2000 64-bit
SQL Server 2000 組建 8.00.1009894254?
(http://support.microsoft.com/kb/894254/
)
FIX: A complex query that includes a UNION ALL operator and an EXISTS clause may fail in SQL Server 2000
894257?
(http://support.microsoft.com/kb/894257/
)
FIX: You receive an "Incorrect syntax near ')'" error message when you run a script that was generated by SQL-DMO for an Operator object in SQL Server 2000
SQL Server 2000 組建 8.00.1013891866?
(http://support.microsoft.com/kb/891866/
)
FIX: The query runs slower than you expected when you try to parse a query in SQL Server 2000
SQL Server 2000 組建 8.00.1014892985?
(http://support.microsoft.com/kb/892985/
)
FIX: You may experience unexpected delays in query execution and unexpected time-out situations, and you may receive error message 17883 when you use the BULK INSERT command in SQL Server 2000
895123?
(http://support.microsoft.com/kb/895123/
)
FIX: You may receive error message 701, error message 802, and error message 17803 when many hashed buffers are available in SQL Server 2000
SQL Server 2000 組建 8.00.1017896425?
(http://support.microsoft.com/kb/896425/
)
FIX: The BULK INSERT statement silently skips insert attempts when the data value is NULL and the column is defined as NOT NULL for INT, SMALLINT, and BIGINT data types in SQL Server 2000
Microsoft及(或)其供應商不就任何在本伺服器上發表的文字資料及其相關圖表資訊的恰當性作任何承諾。所有文字資料及其相關圖表均以「現狀」供應，不負任何擔保責任。Microsoft及(或)其供應商謹此聲明，不負任何對與此資訊有關之擔保責任，包括關於適售性、適用於某一特定用途、權利或不侵權的明示或默示擔保責任。Microsoft及(或)其供應商無論如何不對因或與使用本伺服器上資訊或與資訊的實行有關而引起的契約、過失或其他侵權行為之訴訟中的特別的、間接的、衍生性的損害或任何因使用而喪失所導致的之損害、資料或利潤負任何責任。 | 文章翻譯
|
| United States | Change | | | All Microsoft Sites |
回此頁最上方
|
