SQL Server 2000 articles, fixes and updates - November 2007

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 November 2007. The list is daily updated.

• 309450 FIX: Inconsistent Results Reported by TOP N Using Full-Text CONTAINSTABLE Q309450 KB309450 November 30, 2007
• 298725 PRB: Scheduled DTS Package Fails With "Permission Denied: CreateObject" Q298725 KB298725 November 30, 2007
• 295743 PRB: SQL Server Local Temp Tables Aren't Created When Parameterized ADO Query Is Used Q295743 KB295743 November 30, 2007
• 294160 BUG: Update of Newly Inserted Row Causes DB_E_ERRORSOCCURRED Q294160 KB294160 November 30, 2007
• 279113 FILE: Use Xpvmlog to Dump the Layout of Virtual Memory in SQL Server Q279113 KB279113 November 30, 2007
• 240867 How to move, copy, and back up full-text catalog folders and files Q240867 KB240867 November 30, 2007
• 831862 Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A Q831862 KB831862 November 27, 2007
• 820788 FIX: Delayed domain authentication may cause SQL Server to stop responding Q820788 KB820788 November 27, 2007
• 884525 Additions to the SQL Server 2000 Service Pack 4 readme files Q884525 KB884525 November 26, 2007
• 820675 How To Implement Bidirectional Transactional Replication Q820675 KB820675 November 26, 2007
• 819334 INF: SQL Server 2000 Service Pack 3a Synopsis Q819334 KB819334 November 26, 2007
• 818368 How to add SQL Server 2000 Stored Procedures to Visual SourceSafe by using Visual Studio .NET Q818368 KB818368 November 26, 2007
• 816939 BUG: File growth value for the tempdb database is not persistent when changed from fixed increments to percentage Q816939 KB816939 November 26, 2007
• 298897 SAMPLE Stored Procedures That Helps Map SIDs Between User and Master Databases When A Database Is Moved Q298897 KB298897 November 26, 2007
• 937950 Explanation of error 3928 in SQL Server 2005 and in SQL Server 2000 Q937950 KB937950 November 20, 2007
• 922658 SQL Server 2000 or SQL Server 2005 may temporarily stop responding on a Windows Server 2003 Service Pack 1-based computer Q922658 KB922658 November 20, 2007
• 922209 The SQL Server 2005 Setup program does not remove all IP address cluster resources when you uninstall SQL Server 2005 Q922209 KB922209 November 20, 2007
• 919394 Error message when you install SQL Server 2005: "Beta components detected" Q919394 KB919394 November 20, 2007
• 906649 Unsupported tuning options for some editions of SQL Server 2000 and of SQL Server 2005 Q906649 KB906649 November 20, 2007
• 888799 A list of the bugs that are fixed in SQL Server 2000 Service Pack 4 Q888799 KB888799 November 20, 2007
• 827968 How to estimate the size of a SQL Server CE or SQL Server 2005 Mobile Edition database Q827968 KB827968 November 20, 2007
• 810185 SQL Server 2000 hotfix update for SQL Server 2000 Service Pack 3 and 3a Q810185 KB810185 November 20, 2007
• 329526 File allocation extension in SQL Server 2000 (64-bit) and SQL Server 2005 Q329526 KB329526 November 20, 2007
• 896520 You may receive an "Old format or invalid type library error when processing MOM data" message when the Microsoft Operations Manager (MOM) 2005 Management Server and the MOM 2005 database reside on the same computer Q896520 KB896520 November 16, 2007
• 893515 Cross language support in SQL Server 2000 Q893515 KB893515 November 16, 2007
• 889551 Service Pack 3a for Microsoft SQL Server 2000 April 9, 2003 Q889551 KB889551 November 16, 2007
• 841375 A message stating that an instance of SQL Server is vulnerable to virus attacks is logged in the application event log when you install SQL Server 2000 or MSDE 2000 on a computer that is running Windows XP Service Pack 2 Q841375 KB841375 November 16, 2007
• 300269 FIX: Replication Conflict Viewer Reports That Merge Published Database Is Not Published Q300269 KB300269 November 16, 2007
• 890759 FIX: You may receive the "Server: Msg 7399, Level 16, State 1, Line 1" error message when you run a query against a remote view through a linked server in SQL Server 2000 Q890759 KB890759 November 15, 2007
• 824462 SqlCeCommand objects are not automatically disposed if you use a SqlCeDataAdapter object Q824462 KB824462 November 14, 2007
• 814852 INF: How to Enable Encryption Support for SQL Server CE Databases Q814852 KB814852 November 14, 2007
• 325003 How to manage the SQL Server Desktop Engine (MSDE 2000) or SQL Server 2005 Express Edition by using the osql utility Q325003 KB325003 November 14, 2007
• 324992 How to use replication with SQL Server 2000 Desktop Engine (MSDE 2000) Q324992 KB324992 November 14, 2007
• 322667 DOC: SQL Server Books Online Includes Incorrect Documentation on Distribution Agent Profile Parameters in Transactional Replication Q322667 KB322667 November 14, 2007
• 241397 How to back up a Microsoft Data Engine database by using Transact-SQL Q241397 KB241397 November 14, 2007
• 813953 Description of SQL Server 2000 64-bit Readme.htm additions Q813953 KB813953 November 13, 2007
• 320499 How to manually synchronize replication subscriptions by using backup or restore Q320499 KB320499 November 12, 2007
• 814950 FIX: A computer might transmit nonencrypted data when clients use the Multiprotocol Net-Library with the encryption option enabled Q814950 KB814950 November 7, 2007
• 813842 SQL Server 2000 Evaluation Edition supports security patch Q813842 KB813842 November 7, 2007
• 316333 SQL Server 2000 Security Update for Service Pack 2 Q316333 KB316333 November 7, 2007
• 843267 FIX: Dynamic cursor retrieves the same row two times when you update the non-clustered index key to the same value Q843267 KB843267 November 5, 2007
• 838765 You may notice unpredictable behavior on a multiprocessor computer that is running SQL Server 2000 and has the Physical Addressing Extensions (PAE) specification enabled Q838765 KB838765 November 5, 2007
• 831801 FIX: SQLStatistics function returns incorrect sort order sequence Q831801 KB831801 November 5, 2007
• 937758 You receive an error message when you try to attach a SQL Server 2005 database in SQL Server 2000 Q937758 KB937758 November 2, 2007
• 928324 Error message when you use the dtsrun command prompt utility (Dtsrun.exe) to run a DTS package in SQL Server 2005 Integration Services: "This application has failed to start because SQLResourceLoader.dll was not found" Q928324 KB928324 November 2, 2007
• 926929 You cannot connect to a named instance of SQL Server 2000 by using the shared memory protocol after you remove the default instance Q926929 KB926929 November 2, 2007
• 926466 FIX: A different number of rows may be returned in the result set every time that you run a complex full-text search query in SQL Server 2000 Q926466 KB926466 November 2, 2007
• 925732 FIX: You may receive inconsistent comparison results when you compare strings by using a width sensitive collation in SQL Server 2000 Q925732 KB925732 November 2, 2007
• 925684 FIX: You may experience one or more symptoms when you run a "CREATE INDEX" statement on an instance of SQL Server 2000 Q925684 KB925684 November 2, 2007
• 922879 FIX: Error message when you try to install SQL Server 2000: "Unable to validate product key" Q922879 KB922879 November 2, 2007
• 922660 The bcp utility does not return the correct value of the %ERRORLEVEL% variable on some errors in SQL Server 2000 Q922660 KB922660 November 2, 2007
• 916950 FIX: You may experience heap corruption, and SQL Server 2000 may shut down with fatal access violations when you try to browse files in SQL Server 2000 Enterprise Manager on a Windows Server 2003 x64-based computer Q916950 KB916950 November 2, 2007
• 912414 Error message when you use the Volume Shadow Copy Service (VSS) to back up SQL Server 2000 database files or SQL Server 2000 Desktop Engine (MSDE) database files: "'MSDEWriter' has reported an error 0x800423f4" Q912414 KB912414 November 2, 2007
• 911851 Error message when you run the sp_helpfile stored procedure in SQL Server 2005 or in SQL Server 2000: "Arithmetic overflow error converting expression to data type int" Q911851 KB911851 November 2, 2007
• 910401 How to use Microsoft System Center Data Protection Manager 2006 to help protect a SQL Server database Q910401 KB910401 November 2, 2007
• 909089 FIX: An access violation may occur when you try to run a Transact-SQL query in SQL Server 2000 Q909089 KB909089 November 2, 2007
• 905616 You receive error messages when you try to back up a SQL Server 2000 database to a tape drive after you format and use the tape drive for backups in Windows Server 2003 Q905616 KB905616 November 2, 2007
• 902388 Event ID: 208 may be logged, and a "DBCC failed" error message is logged when you try to use the Database Maintenance Plan Wizard to create a maintenance plan in SQL Server 2000 Q902388 KB902388 November 2, 2007
• 899976 FIX: A query that involves data that is the numeric data type may return incorrect results in SQL Server 2000 SP3 and in earlier SQL Server 2000 service packs Q899976 KB899976 November 2, 2007
• 899761 FIX: Not all memory is available when AWE is enabled on a computer that is running a 32-bit version of SQL Server 2000 SP4 Q899761 KB899761 November 2, 2007
• 899556 You may experience performance issues when you use SQL Server Distributed Management Objects (SQL-DMO) components in a multithreaded environment Q899556 KB899556 November 2, 2007
• 899428 FIX: You receive incorrect results when you run a query that uses a cross join operator in SQL Server 2000 SP3 Q899428 KB899428 November 2, 2007
• 898626 FIX: An access violation may occur when a deadlock graph is written to the error log in SQL Server 2000 Q898626 KB898626 November 2, 2007
• 898115 FIX: The subquery in a CASE function is evaluated even if the condition in the WHEN expression is false in SQL Server 2000 Q898115 KB898115 November 2, 2007
• 898042 Changes to SQL Server 2000 Service Pack 4 operating system support Q898042 KB898042 November 2, 2007
• 897886 BUG: The return data type depends on the location of a UNION operation where char and varchar data types are combined in SQL Server 2000 Q897886 KB897886 November 2, 2007
• 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 Q897572 KB897572 November 2, 2007
• 897349 How to configure SQL Mail to use an Internet mail server by using Outlook 2003 Q897349 KB897349 November 2, 2007
• 896609 The -skipperrors Distribution Agent parameter for SQL Server 2000 may skip more commands than expected Q896609 KB896609 November 2, 2007
• 896556 You receive a "Server: Msg 3624, Level 20, State 1, Line 1" error message when you try to back up a database that is stored on read-only media in SQL Server 2000 Q896556 KB896556 November 2, 2007
• 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 Q895123 KB895123 November 2, 2007
• 895081 FIX: SQL Server 2000 may load an incorrect certificate when the ClusterName value is longer than the ClusterIpAddr value Q895081 KB895081 November 2, 2007
• 894254 FIX: A complex query that includes a UNION ALL operator and an EXISTS clause may fail in SQL Server 2000 Q894254 KB894254 November 2, 2007
• 893402 FIX: Two SQL Server user logins may be created for the same user in SQL Server 2000 Q893402 KB893402 November 2, 2007
• 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 Q893312 KB893312 November 2, 2007
• 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 Q893172 KB893172 November 2, 2007
• 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 Q892985 KB892985 November 2, 2007
• 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 Q892940 KB892940 November 2, 2007
• 892924 FIX: You receive a 7619 error message when you run a full text query that contains certain Japanese character strings on an instance of SQL Server 2000 that is running on a Windows 2000-based computer Q892924 KB892924 November 2, 2007
• 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 Q892840 KB892840 November 2, 2007
• 892803 BUG: You may receive the "Server: Msg 8929" error message or the "Server: Msg 8968" error message when you run a maintenance plan or a command that examines the integrity of the database in SQL Server 2000 Q892803 KB892803 November 2, 2007
• 892451 BUG: You receive an "EXCEPTION_ACCESS_VIOLATION" error message when you use a RIGHT OUTER JOIN clause in SQL Server 2000 Q892451 KB892451 November 2, 2007
• 892406 FIX: The setting for the precision and the scale of the data that is returned from a stored procedure output parameter is (38,0) when a null value is returned in SQL Server 2000 Q892406 KB892406 November 2, 2007
• 892392 FIX: Query performance may be slower if the query contains both a GROUP BY clause and a DISTINCT keyword on the same column Q892392 KB892392 November 2, 2007
• 892310 FIX: The results are different every time that you run a complex query that contains a hash outer join operator in SQL Server 2000 Q892310 KB892310 November 2, 2007
• 892205 FIX: You may receive a 17883 error message when SQL Server 2000 performs a very large hash operation Q892205 KB892205 November 2, 2007
• 891984 Implications of removing the xp_cmdshell stored procedure from SQL Server 2000 Q891984 KB891984 November 2, 2007
• 891866 FIX: The query runs slower than you expected when you try to parse a query in SQL Server 2000 Q891866 KB891866 November 2, 2007
• 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 Q891707 KB891707 November 2, 2007
• 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 Q891640 KB891640 November 2, 2007
• 891553 BUG: There is a decrease in performance when you frequently create and drop temporary tables in SQL Server 2000 Q891553 KB891553 November 2, 2007
• 891311 FIX: You cannot create new TCP/IP socket based connections after error messages 17882 and 10055 are written to the Microsoft SQL Server 2000 error log Q891311 KB891311 November 2, 2007
• 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 Q891268 KB891268 November 2, 2007
• 891201 FIX: Performance is significantly reduced when you set trace flag 9134 to prevent error message 601 in SQL Server 2000 Q891201 KB891201 November 2, 2007
• 891017 FIX: SQL Server 2000 may stop responding to other requests when you perform a large deallocation operation Q891017 KB891017 November 2, 2007
• 890942 FIX: Some complex queries are slower after you install SQL Server 2000 Service Pack 2 or SQL Server 2000 Service Pack 3 Q890942 KB890942 November 2, 2007
• 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 Q890925 KB890925 November 2, 2007
• 890771 You receive an error message when you perform a query that contains an alias that has the same name as two or more columns in the ORDER BY clause Q890771 KB890771 November 2, 2007
• 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 Q890768 KB890768 November 2, 2007
• 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 Q890767 KB890767 November 2, 2007
• 890755 FIX: A "Server: Msg 7105" error message is repeatedly logged in the error log, assertions may be logged in the error log, and you receive a "Server: Msg 8929" error message in SQL Server 2000 Q890755 KB890755 November 2, 2007
• 890742 FIX: Error message when you use a loopback linked server to run a distributed query in SQL Server 2000: "Could not perform the requested operation because the minimum query memory is not available" Q890742 KB890742 November 2, 2007
• 890730 FIX: You receive a 17883 error message when you perform large in-memory sort operations in SQL Server 2000 Q890730 KB890730 November 2, 2007
• 890637 FIX: A 17883 error is written to the SQL Server 2000 error log and the LogWriter component does not yield correctly Q890637 KB890637 November 2, 2007
• 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 Q890200 KB890200 November 2, 2007
• 889696 You may experience a slow response from SQL Server Enterprise Manager when many databases exist in an instance of SQL Server Q889696 KB889696 November 2, 2007
• 889314 FIX: Non-convergence may occur in a merge replication topology if the primary connection to the publisher is disconnected Q889314 KB889314 November 2, 2007
• 889266 FIX: A database is marked suspect when you open the database in SQL Server 2000 Q889266 KB889266 November 2, 2007
• 889239 FIX: Start times in the SQL Profiler are different for the Audit:Login and Audit:Logout Events in SQL Server 2000 Q889239 KB889239 November 2, 2007
• 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 Q889170 KB889170 November 2, 2007
• 888998 FIX: A query that joins two tables on smalldatetime data type columns, may produce incorrect results in SQL Server 2000 Q888998 KB888998 November 2, 2007
• 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 Q888444 KB888444 November 2, 2007
• 888429 FIX: LIKE pattern matching may consider half-width and full-width characters to be equal even if width-sensitive collation is specified Q888429 KB888429 November 2, 2007
• 888008 FIX: Full-text queries that use the NEAR operator may return different results if the NEAR operands are reversed in SQL Server 2000 Q888008 KB888008 November 2, 2007
• 887974 FIX: A fetch on a dynamic cursor can cause unexpected results in SQL Server 2000 Service Pack 3 Q887974 KB887974 November 2, 2007
• 886708 FIX: Inserting lots of text, ntext, or image data over multiple concurrent connections takes a long time in SQL Server 2000 Q886708 KB886708 November 2, 2007
• 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 Q885442 KB885442 November 2, 2007
• 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 Q885290 KB885290 November 2, 2007
• 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 Q885158 KB885158 November 2, 2007
• 884855 FIX: You receive an error message when you run a statement on a table that contains a trigger in SQL Server 2000 Q884855 KB884855 November 2, 2007
• 884853 FIX: Performance is slow when you update a subscribed table on a subscriber that uses queued updating in SQL Server 2000 Q884853 KB884853 November 2, 2007
• 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 Q884772 KB884772 November 2, 2007
• 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 Q884554 KB884554 November 2, 2007
• 883783 BUG: You may receive an error message when you try to initialize full-text indexing for a database on a computer that is running Windows XP SP2 Q883783 KB883783 November 2, 2007
• 883415 FIX: A user-defined function returns results that are not correct for a query Q883415 KB883415 November 2, 2007
• 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 Q878501 KB878501 November 2, 2007
• 878500 FIX: An Audit Object Permission event is not produced when you run a TRUNCATE TABLE statement Q878500 KB878500 November 2, 2007
• 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 Q875445 KB875445 November 2, 2007
• 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 Q873482 KB873482 November 2, 2007
• 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 Q873446 KB873446 November 2, 2007
• 872843 FIX: The Log Reader Agent may fail and you receive an assertion error message Q872843 KB872843 November 2, 2007
• 872842 FIX: A CHECKDB statement reports a 2537 corruption error after SQL Server transfers data to a sql_variant column in SQL Server 2000 Q872842 KB872842 November 2, 2007
• 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 Q870994 KB870994 November 2, 2007
• 867880 FIX: Merge Agent may fail with an "Invalid character value for cast specification" error message Q867880 KB867880 November 2, 2007
• 867879 FIX: Merge replication non-convergence occurs with SQL Server CE subscribers Q867879 KB867879 November 2, 2007
• 867878 FIX: The Log Reader Agent may cause 17883 error messages Q867878 KB867878 November 2, 2007
• 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 Q867798 KB867798 November 2, 2007
• 867677 You receive an ODBC error when you use BCP in SQL Server 2000 Q867677 KB867677 November 2, 2007
• 843534 FIX: You may receive a 3628 error in SQL Server 2000 when you query many items that have an IN clause Q843534 KB843534 November 2, 2007
• 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 Q843282 KB843282 November 2, 2007
• 843263 FIX: You may receive an 8623 error message when you try to run a complex query on an instance of SQL Server Q843263 KB843263 November 2, 2007
• 842960 Description of the 32-bit SQL Server 7.0 and SQL Server 2000 hotfix installer Q842960 KB842960 November 2, 2007
• 841776 FIX: Additional diagnostics have been added to SQL Server 2000 to detect unreported read operation failures Q841776 KB841776 November 2, 2007
• 841627 FIX: SQL Server 2000 may underestimate the cardinality of a query expression under certain circumstances Q841627 KB841627 November 2, 2007
• 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 Q841404 KB841404 November 2, 2007
• 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 Q841401 KB841401 November 2, 2007
• 840406 FIX: Queries that join a view may run slowly if the view contains outer joins Q840406 KB840406 November 2, 2007
• 840166 FIX: The dynamic Snapshot Agent may fail when you use a dynamic snapshot for merge publications in SQL Server 2000 Q840166 KB840166 November 2, 2007
• 839884 FIX: A System.ExecutionEngineException exception occurs when you try to access the DTS DynamicPropertiesTaskAssignments collection Q839884 KB839884 November 2, 2007
• 839688 FIX: Profiler RPC events truncate parameters that have a text data type to 16 characters Q839688 KB839688 November 2, 2007
• 839589 FIX: The thread priority is raised for some threads in a parallel query Q839589 KB839589 November 2, 2007
• 839529 FIX: 8621 error conditions may cause SQL Server 2000 64-bit to close unexpectedly Q839529 KB839529 November 2, 2007
• 839523 FIX: An access violation exception may occur when you update a text column by using a stored procedure in SQL Server 2000 Q839523 KB839523 November 2, 2007
• 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 Q839458 KB839458 November 2, 2007
• 839280 FIX: SQL debugging does not work in Visual Studio .NET after you install Windows XP Service Pack 2 Q839280 KB839280 November 2, 2007
• 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 Q839096 KB839096 November 2, 2007
• 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 Q838460 KB838460 November 2, 2007
• 838459 FIX: You may receive a BPool::Map warning when you create or rebuild indexes by using the awe enabled configuration option Q838459 KB838459 November 2, 2007
• 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 Q838409 KB838409 November 2, 2007
• 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 Q837970 KB837970 November 2, 2007
• 837969 FIX: You may receive an access violation in the CRowsetTraceData::FGetNextRow function when you trace server activity with SQL Profiler Q837969 KB837969 November 2, 2007
• 837957 FIX: When you use Transact-SQL cursor variables to perform operations that have large iterations, memory leaks may occur in SQL Server 2000 Q837957 KB837957 November 2, 2007
• 837890 FIX: The CPU column in the sysprocesses system table contains a negative value or an abnormal variation for some processes Q837890 KB837890 November 2, 2007
• 837401 FIX: Rows are not successfully inserted into a table when you use the BULK INSERT command to insert rows Q837401 KB837401 November 2, 2007
• 837231 FIX: Distribution Agent may fail after you add or drop a column for a published article Q837231 KB837231 November 2, 2007
• 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 Q836839 KB836839 November 2, 2007
• 836651 FIX: You receive query results that were not expected when you use both ANSI joins and non-ANSI joins Q836651 KB836651 November 2, 2007
• 836141 FIX: An access violation exception may occur when SQL Server runs many parallel query processing operations on a multiprocessor computer Q836141 KB836141 November 2, 2007
• 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 Q836096 KB836096 November 2, 2007
• 835864 FIX: Intermittent query slowdowns and corresponding high CPU utilization Q835864 KB835864 November 2, 2007
• 834923 FIX: The SQL Server cluster resource may be marked as Fail when you try to take it offline Q834923 KB834923 November 2, 2007
• 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 Q834798 KB834798 November 2, 2007
• 834720 Fix: An error in a remote procedure call does not roll back the local operation Q834720 KB834720 November 2, 2007
• 834688 FIX: You may receive a 913 error message if your query includes user-defined functions, derived tables, and JOINs Q834688 KB834688 November 2, 2007
• 834453 FIX: The Snapshot Agent may fail after you make schema changes to the underlying tables of a publication Q834453 KB834453 November 2, 2007
• 834451 FIX: Restoring transaction log files takes longer than expected in SQL Server 2000 Q834451 KB834451 November 2, 2007
• 834290 FIX: You receive a 644 error message when you run an UPDATE statement and the isolation level is set to READ UNCOMMITTED Q834290 KB834290 November 2, 2007
• 833710 FIX: You receive an error message when you try to restore a database backup that spans multiple devices Q833710 KB833710 November 2, 2007
• 833045 FIX: The xp_sendmail extended stored procedure does not run successfully in SQL Server 2000 SP2 or later Q833045 KB833045 November 2, 2007
• 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 Q832674 KB832674 November 2, 2007
• 832437 FIX: A CHECKDB statement reports corruption after SQL Server transfers sql_variant data in SQL Server 2000 Q832437 KB832437 November 2, 2007
• 831999 FIX: An AWE system uses more memory for sorting or for hashing than a non-AWE system in SQL Server 2000 Q831999 KB831999 November 2, 2007
• 831997 FIX: An invalid cursor state occurs after you apply Hotfix 8.00.0859 or later in SQL Server 2000 Q831997 KB831997 November 2, 2007
• 831950 FIX: You receive error message 3456 when you try to apply a transaction log to a server Q831950 KB831950 November 2, 2007
• 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 Q831675 KB831675 November 2, 2007
• 831302 FIX: SQL Server underestimates the cardinality of a query expression and query performance may be slow Q831302 KB831302 November 2, 2007
• 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 Q830887 KB830887 November 2, 2007
• 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 Q830860 KB830860 November 2, 2007
• 830773 FIX: You receive an EXCEPTION_ACCESS_VIOLATION error message when you try to save a DTS package in SQL Server 2000 Q830773 KB830773 November 2, 2007
• 830588 FIX: Access violation when you trace keyset-driven cursors by using SQL Profiler Q830588 KB830588 November 2, 2007
• 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 Q830466 KB830466 November 2, 2007
• 830395 FIX: An access violation occurs during compilation if the table contains statistics for a computed column Q830395 KB830395 November 2, 2007
• 830375 FIX: The global variable @@ERROR may return an incorrect value after a remote procedure call Q830375 KB830375 November 2, 2007
• 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 Q830366 KB830366 November 2, 2007
• 829386 FIX: You cannot install MSDE 2000 if the Server service is not running Q829386 KB829386 November 2, 2007
• 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 Q829205 KB829205 November 2, 2007
• 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 Q829183 KB829183 November 2, 2007
• 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 Q828945 KB828945 November 2, 2007
• 828308 FIX: An Internet Explorer script error occurs when you access metadata information by using DTS in SQL Server Enterprise Manager Q828308 KB828308 November 2, 2007
• 827714 FIX: A query may fail with retail assertion when you use the NOLOCK hint or the READ UNCOMMITTED isolation level Q827714 KB827714 November 2, 2007
• 827178 FIX: You may receive a 644 error message when you run concurrent transactions on a heap Q827178 KB827178 November 2, 2007
• 826829 You receive a "General network error" error message when you make a request to an SQL adapter Q826829 KB826829 November 2, 2007
• 826815 FIX: You receive an 8623 error message in SQL Server when you try to run a query that has multiple correlated subqueries Q826815 KB826815 November 2, 2007
• 826754 FIX: A Deadlock Occurs If You Run an Explicit UPDATE STATISTICS Command Q826754 KB826754 November 2, 2007
• 826376 FIX: An access violation may occur when you remove all elements from the procedure cache for a linked server over an interrupted remote access connection Q826376 KB826376 November 2, 2007
• 826080 FIX: SQL Server 2000 protocol encryption applies to JDBC clients Q826080 KB826080 November 2, 2007
• 825884 FIX: The dynamic query statement appears in the query execution plan of an encrypted stored procedure Q825884 KB825884 November 2, 2007
• 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 Q825883 KB825883 November 2, 2007
• 825197 FIX: You receive error 3624 and the user database is marked suspect after you perform a bulk insert operation in SQL Server 2000 Q825197 KB825197 November 2, 2007
• 825043 FIX: Rows are unexpectedly deleted when you run a distributed query to delete or to update a linked server table Q825043 KB825043 November 2, 2007
• 825042 FIX: SQL Server Jobs That Are Owned by Non-sysadmin Users May Not Start Q825042 KB825042 November 2, 2007
• 825019 FIX: A linked server query fails with the error message "Statement(s) could not be prepared" in SQL Server 2000 Q825019 KB825019 November 2, 2007
• 824430 FIX: Performance decreases over time when you back up files in SQL Server 2000 Q824430 KB824430 November 2, 2007
• 824227 FIX: A SELECT statement that contains computed columns and invalid filter condition values may cause an access violation Q824227 KB824227 November 2, 2007
• 823519 PRB: Windows Installer starts in Repair mode when you try to remove an instance of SQL Server 2000 on a computer that has an instance of SQL Server Desktop Engine or SQL Server Desktop Engine (Windows) Q823519 KB823519 November 2, 2007
• 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 Q822747 KB822747 November 2, 2007
• 822668 FIX: "Connection is busy with results for another command" error message occurs when you run a linked server query Q822668 KB822668 November 2, 2007
• 822641 Additional diagnostics added to diagnose long-running or canceled database autogrow operations in SQL Server Q822641 KB822641 November 2, 2007
• 822164 A computer that is running SQL Server 2000 with the AWE option enabled does not support the set working set size option Q822164 KB822164 November 2, 2007
• 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 Q821537 KB821537 November 2, 2007
• 821535 FIX: Merge Replication Fails with Error 207 While Generating a Snapshot Q821535 KB821535 November 2, 2007
• 820835 FIX: SQL Server Might Take a Long Time to Recover After an Abrupt or Unexpected Server Shutdown Q820835 KB820835 November 2, 2007
• 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 Q819829 KB819829 November 2, 2007
• 818540 FIX: SQL Server Enterprise Manager unexpectedly quits when you modify a DTS package Q818540 KB818540 November 2, 2007
• 817186 FIX: A query that performs join operations between multiple tables may return incorrect results Q817186 KB817186 November 2, 2007
• 816937 FIX: A memory leak may occur when you use the sp_OAMethod stored procedure to call a method of a COM object Q816937 KB816937 November 2, 2007
• 815476 FIX: The spacing may not be correct when you run xp_sendmail and the query parameter contains a COMPUTE clause Q815476 KB815476 November 2, 2007
• 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 Q815183 KB815183 November 2, 2007
• 815008 FIX: Query with transaction isolation level set to READ UNCOMMITTED fails with error 601 Q815008 KB815008 November 2, 2007
• 814997 FIX: The header information may not be included when the query parameter has a COMPUTE clause Q814997 KB814997 November 2, 2007
• 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 Q814654 KB814654 November 2, 2007
• 813779 FIX: A DML Operation on a Large Table Can Cause Performance Problems Q813779 KB813779 November 2, 2007
• 813524 FIX: OLE DB conversion errors may occur after you select a literal string that represents datetime data as a column Q813524 KB813524 November 2, 2007
• 813494 FIX: Distribution Agent Fails with "Violation of Primary Key Constraint" Error Message Q813494 KB813494 November 2, 2007
• 813146 FIX: A scan of each partition table may be performed when you run an UPDATE statement on the partitioning column of a partitioned view Q813146 KB813146 November 2, 2007
• 810920 FIX: The JOIN queries in the triggers that involve the inserted table or the deleted table may return results that are not consistent Q810920 KB810920 November 2, 2007
• 331968 FIX: The xp_readmail and xp_findnextmsg Extended Stored Procedures Do Not Read Mail in Time Received Order Q331968 KB331968 November 2, 2007
• 331965 FIX: The xp_readmail Extended Stored Procedure Overwrites Attachment That Already Exists Q331965 KB331965 November 2, 2007
• 331885 FIX: Update/Delete Statement Fails with Error 1203 During Page Lock Escalation Q331885 KB331885 November 2, 2007
• 328616 FIX: A trace file may be reported as corrupted and contains a 128 KB region of zeros in SQL Server 2000 Q328616 KB328616 November 2, 2007
• 321459 PRB: The CryptoAPI Function Generates an Error When You Try to Connect to an Instance of SQL Server 2000 Q321459 KB321459 November 2, 2007
• 319477 FIX: Extremely Large Number of User Tables on AWE System May Cause BPool::Map Errors Q319477 KB319477 November 2, 2007
• 317989 FIX: Sqlakw32.dll May Corrupt SQL Statements Q317989 KB317989 November 2, 2007
• 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 Q309802 KB309802 November 2, 2007
• 298814 PRB: Unable to Manage Named Instances on Windows 98 or Windows ME Computers if DBCS Characters are Used to Name Instances Q298814 KB298814 November 2, 2007
• 291235 FIX: Query Analyzer Hangs After You Drag & Drop Files Into the Query Editor and You Close One of the Newly Created Windows Q291235 KB291235 November 2, 2007
• 290645 FIX: SQL Server Active Directory Registration Always Reports Success Q290645 KB290645 November 2, 2007
• 290643 FIX: Microsoft Search Service Cannot be Stopped During Large Population Q290643 KB290643 November 2, 2007
• 290369 FIX: Updates to New Column Added to Merge Publication Article Are Not Replicated Q290369 KB290369 November 2, 2007
• 288095 Stack overflow occurs when you run a query that contains a large number of arguments inside an IN or a NOT IN clause in SQL Server Q288095 KB288095 November 2, 2007
• 286503 FIX: Publication Options Disabled When Create Publication Wizard Launched from DTS Import/Export Wizard Q286503 KB286503 November 2, 2007
• 286255 FIX: UNION query returns internal query processor error message 8623 Q286255 KB286255 November 2, 2007
• 285025 BUG: SQL 6.5 Logins upgraded to SQL 7.0 and subsequently moved to SQL 2000 through CDW cannot log in Q285025 KB285025 November 2, 2007
• 280294 FIX: SQL Server ODBC Driver reuses incorrect parameter length Q280294 KB280294 November 2, 2007
• 278667 BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or ME Computers Q278667 KB278667 November 2, 2007
• 277626 FIX: Distributed partitioned view by using UNION may not use optimal plan Q277626 KB277626 November 2, 2007
• 273833 BUG: Restore of a Large Database on Windows 98 May Fail with 3257 Error Message Q273833 KB273833 November 2, 2007
• 273586 The behavior of the IDENTITY function when used with SELECT INTO or INSERT .. SELECT queries that contain an ORDER BY clause Q273586 KB273586 November 2, 2007
• 271070 BUG: Desktop Engine and Personal Edition Fails When You Upgrade MSDE 1.0 & Desktop Edition 7.0 Q271070 KB271070 November 2, 2007
• 243586 Troubleshooting stored procedure recompilation Q243586 KB243586 November 2, 2007
• 148224 BUG: Cross-database table creation/drop in stored procedure Q148224 KB148224 November 2, 2007