SQL Server 2000 articles, fixes and updates - September 2005

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2000 that have been released in September 2005. The list is daily updated.

• 817081 FIX: You receive an error message when you use the SQL-DMO BulkCopy object to import data into a SQL Server table Q817081 KB817081 September 27, 2005
• 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 Q815249 KB815249 September 27, 2005
• 812915 FIX: "Performance monitor shared memory setup failed: -1" error message when you start SQL Server Q812915 KB812915 September 27, 2005
• 812558 FIX: SQL Server ODBC Driver Does Not Report Canceled Query Q812558 KB812558 September 27, 2005
• 810195 FIX: Parallel Index Operations Might Cause Latch Warning Messages Q810195 KB810195 September 27, 2005
• 330458 FIX: A Query That Causes Hash Role Reversal May Return Incorrect Results Q330458 KB330458 September 27, 2005
• 330212 FIX: Parallel logical operation returns results that are not consistent Q330212 KB330212 September 27, 2005
• 329375 FIX: Access Violations May Occur with SQL Mail When You Use XP_SENDMAIL Q329375 KB329375 September 27, 2005
• 328920 FIX: Querying Sysmembers Might Result in a Leak of Buffer Pool Memory Q328920 KB328920 September 27, 2005
• 328736 FIX: Updates That Run at a Read Uncommitted Isolation Level Fail with a 644 Error Message Q328736 KB328736 September 27, 2005
• 328569 FIX: Ad Hoc Access Incorrectly Permitted If DisallowAdhocAccess Registry Key Is Missing Q328569 KB328569 September 27, 2005
• 328550 FIX: Resource Contention Occurs When You Update Multiple Tables That Have a Timestamp Column Q328550 KB328550 September 27, 2005
• 328354 FIX: A RESTORE DATABASE WITH RECOVERY Statement Can Fail with Error 9003 or Error 9004 Q328354 KB328354 September 27, 2005
• 328187 FIX: A Query That Uses a Hash Match with a Residual Predicate Might Return Incorrect Results Q328187 KB328187 September 27, 2005
• 327637 FIX: Dynamic Snapshot Generation May Experience Slow Performance Q327637 KB327637 September 27, 2005
• 327562 FIX: Joins with a UNION ALL View May Take a Long Time to Compile and May Use Large Amounts of Memory Q327562 KB327562 September 27, 2005
• 327289 FIX: The Distribution Agent Might Shut Down with a Syntax Error or Queued Updating Subscribers Might Become Unsynchronized Q327289 KB327289 September 27, 2005
• 326999 FIX: Lock escalation on a scan while an update query is running causes a 1203 error message to occur Q326999 KB326999 September 27, 2005
• 326934 FIX: Query Compilation Fails with Error 701 After It Uses Up Buffer Pool Memory Q326934 KB326934 September 27, 2005
• 326810 FIX: A query that references a view that uses UNION operator may return incorrect results Q326810 KB326810 September 27, 2005
• 326314 FIX: Cardinality Estimation of ISNULL Function Does Not Account for Null Values Q326314 KB326314 September 27, 2005
• 325902 FIX: The Distribution Agent May Fail After You Add an Article to an Existing Transactional Publication Q325902 KB325902 September 27, 2005
• 325658 FIX: Parameterized Query with Several IN Clauses Fails with Error: 8623 Q325658 KB325658 September 27, 2005
• 325607 FIX: The fn_get_sql function returns SQL text for handle in the Sysprocesses system table Q325607 KB325607 September 27, 2005
• 325492 FIX: Input Parameters to the OLE Automation (sp_OA) Stored Procedures Truncate at 4000 Characters Q325492 KB325492 September 27, 2005
• 325197 FIX: Reading a Profiler Trace with the ::fn_trace_gettable Function and SPID 1000 Might Cause Errors Q325197 KB325197 September 27, 2005
• 324630 FIX: DBCC INDEXDEFRAG May Cause an Assertion Failure If the Index Includes Variable-Length Columns Q324630 KB324630 September 27, 2005
• 324563 FIX: If You Use the sp_reinitmergesubscription Stored Procedure with @UPLOAD_FIRST Set to TRUE Data Loss May Occur for SQL Server CE Subscribers Q324563 KB324563 September 27, 2005
• 324515 FIX: Update Conflict for Unique Key Columns for Queued Updating Subscriber Results in Non-Convergence Q324515 KB324515 September 27, 2005
• 324186 FIX: Slow Compile Time and Execution Time with Query That Contains Aggregates and Subqueries Q324186 KB324186 September 27, 2005
• 323721 FIX: Filter Not Pushed Below Aggregate If Subquery Uses the DISTINCT Keyword Q323721 KB323721 September 27, 2005
• 323609 FIX: Distribution Agent May Fail with Syntax Error Q323609 KB323609 September 27, 2005
• 323550 FIX: The Replication Queue Reader Agent Utility Shuts Down After Error 2601 Occurs Q323550 KB323550 September 27, 2005
• 323545 FIX: The Distribution Agent Shuts Down and Error 2627 or Error 2601 Are Generated When You Apply a Command to a Queued Updating Subscriber Q323545 KB323545 September 27, 2005
• 323248 FIX: Lock Timeout on Scrollable Cursor May Occur if Page Locking is Disabled Q323248 KB323248 September 27, 2005
• 323213 FIX: Subquery That Returns One Row May Cause CPU Spin and Excessive Optimizer Memory Usage Q323213 KB323213 September 27, 2005
• 323212 FIX: Optimizer May Consume Too Much Memory if Address Windowing Extensions (AWE) is Enabled Q323212 KB323212 September 27, 2005
• 323038 FIX: Infinite Loop During Full-Text Catalog Population Q323038 KB323038 September 27, 2005
• 322871 FIX: Incorrect Results May Occur with Index Spool and Parallel Plan Q322871 KB322871 September 27, 2005
• 322868 FIX: Deadlock May Occur During Update Statistics on System Tables Q322868 KB322868 September 27, 2005
• 322865 FIX: 8623 Error Message Occurs When Opening a Fast Forward Only Cursor on a View Q322865 KB322865 September 27, 2005
• 322854 FIX: Reordering Joins May Cause MISSING JOIN PREDICATE Warning Q322854 KB322854 September 27, 2005
• 322668 FIX: Inconsistent Results on Parallel Update That Causes Page Splits Q322668 KB322668 September 27, 2005
• 322384 FIX: Replication Queued Updating Supports Unique Constraints Q322384 KB322384 September 27, 2005
• 322379 FIX: Bulk Insert Operation May Cause Blocking Q322379 KB322379 September 27, 2005
• 321879 FIX: IDENTITY Columns May Be Incorrectly Reseeded If SQL Server Shuts Down Unexpectedly Q321879 KB321879 September 27, 2005
• 321873 FIX: SQL Enterprise Manager May Experience an Access Violation When It Monitors Remote Servers Over Slow Connections Q321873 KB321873 September 27, 2005
• 321870 FIX: SQL Enterprise Manager May Experience an Access Violation in the COleUtilEnumConnections::Release Function Q321870 KB321870 September 27, 2005
• 321858 FIX: MDAC: Patch Available for Script Injection with XML Tag and Unchecked Buffer in SQLXML ISAPI Extension Vulnerabilities Q321858 KB321858 September 27, 2005
• 321820 FIX: Non-OCR/Non-Display TIFF Data Indexed by SQL Server Full-Text Q321820 KB321820 September 27, 2005
• 321460 FIX: Patch Available for Script Injection with XML Tag and Unchecked Buffer in SQLXML ISAPI Extension Vulnerabilities Q321460 KB321460 September 27, 2005
• 320434 FIX: Bulk Insert with TABLOCK Hint May Result in Errors 8929 and 8965 When You Run CHECKDB Q320434 KB320434 September 27, 2005
• 319962 FIX: Access Violation May Occur If You Log Off After You Cancel A Linked Server Query Q319962 KB319962 September 27, 2005
• 319961 FIX: Merge Agent Fails with Error Message: "The publisher has been restored from a backup whose schema change version is different..." Q319961 KB319961 September 27, 2005
• 319869 FIX: Improved SQL Manager Robustness for Odd Length Buffer Q319869 KB319869 September 27, 2005
• 319610 FIX: You may receive unexpected results when you use a text column and an OR operator to combine criteria from multiple subqueries Q319610 KB319610 September 27, 2005
• 319455 FIX: Xp_msver Returns Null for Most of the Properties of a Non-English SQL Server Installation Q319455 KB319455 September 27, 2005
• 319258 FIX: Anonymous or Local Merge Subscriber Fails with Error 8152 Q319258 KB319258 September 27, 2005
• 319184 FIX: Parallel Query May Fail with Error Message 1203 and an Assertion Q319184 KB319184 September 27, 2005
• 318878 FIX: ALTER DATABASE SET READ_ONLY Statement May Lead to an Assertion If the Transaction Log is Full Q318878 KB318878 September 27, 2005
• 318874 FIX: Parallel Query May Cause an Access Violation in CBitSet::Incl Q318874 KB318874 September 27, 2005
• 318870 FIX: Incorrect Values with Queued Updating Replication When Money Values Are Between 0 and 1 Q318870 KB318870 September 27, 2005
• 318606 FIX: SQL Server ODBC Driver Resets Connection Attributes When Used in Connection Pooling Q318606 KB318606 September 27, 2005
• 318592 FIX: Snapshots Created on SQL Server Service Pack 2 Cannot Be Delivered Through FTP to Pre-SQL Server 2000 Service Pack 2 Subscribers Q318592 KB318592 September 27, 2005
• 318045 FIX: SELECT with Timestamp Column That Uses FOR XML AUTO May Fail with Stack Overflow or AV Q318045 KB318045 September 27, 2005
• 317979 FIX: Unchecked Buffer May Occur When You Connect to Remote Data Source Q317979 KB317979 September 27, 2005
• 317973 FIX: Abort by DTC Transaction Timeout Not Recognized on a Client Application Q317973 KB317973 September 27, 2005
• 317847 FIX: Incorrect Results Are Returned When You Use ROWCOUNT and an INSERT INTO Statement Q317847 KB317847 September 27, 2005
• 317748 FIX: Handle Leak Occurs in SQL Server When Service or Application Repeatedly Connects and Disconnects with Shared Memory Network Library Q317748 KB317748 September 27, 2005
• 317015 FIX: Complex Linked Server Query May Cause Handled AV in COleDbParams::ClearParamBuf Q317015 KB317015 September 27, 2005
• 316541 FIX: Error 913 May Occur on a SELECT from a Linked Server That Uses a Check Constraint That References a User-Defined Function Q316541 KB316541 September 27, 2005
• 316331 FIX: DTSTransferObjects with Events Generates an Error Message and an Access Violation in Visual Basic Q316331 KB316331 September 27, 2005
• 315662 FIX: Parallel Query May Encounter Undetected Deadlock with Itself Q315662 KB315662 September 27, 2005
• 315649 FIX: LIKE Operator with Japanese Repeating Character That Follows a Wildcard Does Not Return Expected Results Q315649 KB315649 September 27, 2005
• 315447 FIX: SQL Server 2000 may be more aggressive with Lazy Writes than SQL Server 7.0 Q315447 KB315447 September 27, 2005
• 315395 FIX: COM May Not Be Uninitialized for Worker Thread When You Use sp_OA Q315395 KB315395 September 27, 2005
• 314406 FIX: Updates Do Not Replicate to Subscriber After Drop or Add of Columns Q314406 KB314406 September 26, 2005
• 314304 FIX: Query Results in Message Body of xp_sendmail are Empty If You Use ansi_attachments Option Q314304 KB314304 September 26, 2005
• 314003 FIX: Query That Uses DESC Index May Result in Access Violation Q314003 KB314003 September 26, 2005
• 313302 FIX: Shared Table Lock Is Not Released After Lock Escalation Q313302 KB313302 September 26, 2005
• 313005 FIX: SELECT from Computed Column That References UDF Causes SQL Server to Terminate Q313005 KB313005 September 26, 2005
• 312578 FIX: Index Scans on Frequently Modified Table May Return Incorrect Results Q312578 KB312578 September 26, 2005
• 312091 FIX: Optimized Lock Manager Lookup on SMP Systems Q312091 KB312091 September 26, 2005
• 311155 FIX: "ODBC SQL Server Driver" Error Message When You Use the MDAC 2.6 ODBC Driver from SP1 or SP2 Q311155 KB311155 September 26, 2005
• 311120 FIX: Abort of Bulk Insert May Result in Error Message 8979 from CHECKDB Q311120 KB311120 September 26, 2005
• 311096 FIX: Retrieves Inconsistent Results Returned by Indexed Access OLEDB Provider Q311096 KB311096 September 26, 2005
• 310639 BUG: SP_ADD_JOBSTEP Does Not Recognize Server Names Longer Than 30 Characters Q310639 KB310639 September 26, 2005
• 309678 FIX: Thesaurus Support is Not Available for Full-Text Search Q309678 KB309678 September 26, 2005
• 309568 FIX: Error Message 8624 "Internal SQL Server" Occurs with Cold Index Retrieval OLE DB Provider Q309568 KB309568 September 26, 2005
• 309251 FIX: Execution of Sp_addsynctriggers Results in Syntax Error After ALTER TABLE Q309251 KB309251 September 26, 2005
• 308547 FIX: SELECT DISTINCT from Table with LEFT JOIN of View Causes Error Messages or Client Application May Stop Responding Q308547 KB308547 September 26, 2005
• 307948 FIX: SQL Mail Attachments Contain Leading Space Before First Column of Each Result Row Q307948 KB307948 September 26, 2005
• 307540 FIX: SQLPutData May Result in Leak of Buffer Pool Memory Q307540 KB307540 September 26, 2005
• 307538 FIX: SQLTrace Start and Stop is Now Reported in Windows NT Event Log for SQL Server 2000 Q307538 KB307538 September 26, 2005
• 306998 FIX: Complex CASE Clause on Query May Cause Error 8621 and Terminate Batch Q306998 KB306998 September 26, 2005
• 306199 FIX: Dynamic IP Addresses Cannot Connect to SQL Server 2000 Q306199 KB306199 September 26, 2005
• 306096 FIX: Infinite Loop Occurs in ESQL Application That Uses Keyset Cursor Q306096 KB306096 September 26, 2005
• 304847 FIX: Abort of DTC Transaction in tempdb May Cause 7105 Errors, Assertions, and Possible Shutdown of SQL Server Q304847 KB304847 September 26, 2005
• 303446 FIX: SQLOLEDB Returns No Data When Using AutoFetch Option with Fast Forward Cursors Q303446 KB303446 September 26, 2005
• 303120 FIX: ConnectionWrite Error When You Use Lightweight Pooling Q303120 KB303120 September 26, 2005
• 302676 PRB: SQL Enterprise Manager Does Not Retain All Custom View Settings Q302676 KB302676 September 26, 2005
• 302248 FIX: SQLOLEDB Does Not Work with DBACCESSOR_OPTIMIZED Flag and SSPROP_ENABLEFASTLOAD Q302248 KB302248 September 26, 2005
• 301953 Unenlisting from active transaction using SQLOLEDB provider of MDAC 2.6 release against SQL Server 7.0 causes hang and drain abort entry Q301953 KB301953 September 26, 2005
• 300447 FIX: Snapshot Delivery Failure During BCP IN Not Recognized by Merge Agent Q300447 KB300447 September 26, 2005
• 300420 FIX: Connection to SQL Server Database Using IP Address Is Unusually Slow Q300420 KB300420 September 26, 2005
• 299765 FIX: SQL Server 2000 ODBC Driver fails to return SQL Server 7.0 server names on client computers that have MDAC 2.6 installed Q299765 KB299765 September 26, 2005
• 299423 FIX: XML for SQL Server 2000 Web Release 1 Hotfix Rollup Q299423 KB299423 September 26, 2005
• 297266 FIX: SQLOLEDB: Incorrect Transaction Enlistment Causes Hang and Drain Abort Entry Q297266 KB297266 September 26, 2005
• 295757 FIX: Second SQLExecute on Prepared Statement with SQL_NOSCAN_ON Causes Client-Side AV Q295757 KB295757 September 26, 2005
• 295054 FIX: Insert with OPENXML Statement Generates Duplicate Key Error Q295054 KB295054 September 26, 2005
• 291838 FIX: Crash in SQLXMLX Hangs Web Service Threads Q291838 KB291838 September 26, 2005
• 286359 FIX: SQL Server ODBC Driver Generates Error When Executing a Stored Procedure on SQL Server 2000 Q286359 KB286359 September 26, 2005
• 285006 FIX: You receive error message 6603 or text data may be truncated when you select a text data type through the OPENXML provider in SQL Server 2000 Q285006 KB285006 September 26, 2005
• 282455 FIX: SQL Server Fails to Start When Computer Binds 48 or More Socket Addresses Q282455 KB282455 September 26, 2005
• 281633 FIX: SQLOLEDB Provider incorrectly leaves transaction open Q281633 KB281633 September 26, 2005
• 279526 FIX: SQL Server ODBC Driver Ignores Authentication Setting Q279526 KB279526 September 26, 2005
• 273813 FIX: "Incorrect Syntax near the Keyword 'by' " Error Message with Column Names of "C", "CA" or "CAS" Q273813 KB273813 September 26, 2005
• 835188 The IDENT_CURRENT Transact-SQL statement returns an unexpected value for an empty table that has an identity column Q835188 KB835188 September 20, 2005
• 823545 Insert or update operations that are not correct occur when you synchronize a SQL Server CE subscriber with a publisher Q823545 KB823545 September 9, 2005
• 816629 Cannot remove SQL Server CE Server Tools from a computer running Windows Server 2003 Q816629 KB816629 September 9, 2005
• 329742 You receive an error message when you try to run a sample application in the Japanese version of SQL Server CE 2.0 Q329742 KB329742 September 9, 2005
• 328314 FIX: Cannot upload null values in Sql_variant data type by using SQL Server CE merge replication Q328314 KB328314 September 9, 2005
• 325806 How to use the SQL Server CE Connectivity Management utility Q325806 KB325806 September 9, 2005
• 323143 FIX: SQL Server CE is missing the Oledb.lib file for eMbedded Visual C++ 4.0 Q323143 KB323143 September 9, 2005
• 313533 FIX: SQL Server CE subscriptions may not be correctly marked as expired Q313533 KB313533 September 9, 2005
• 894558 FIX: You receive an error message in SQL Server 2000 Driver for JDBC when you submit a converted SQL statement that is generated by the Connection.nativeSQL() method to the SQL database. Q894558 KB894558 September 1, 2005