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.

• 942713 FIX: Error message when you display a SQL Server 2000 Reporting Services report in an ASP.NET application: "System.Net.WebException: The operation has timed-out" Q942713 KB942713 November 30, 2007
• 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
• 907323 Hotfix rollup package for SQL Server 2000 Analysis Services Service Pack - Build 2174 Q907323 KB907323 November 29, 2007
• 915837 Error message when you use the ADOMD.NET data provider in an application to connect to an instance of SQL Server 2000 Analysis Services: "The session, '<SessionID>', does not exist" Q915837 KB915837 November 28, 2007
• 895242 You receive an error message in SQL Server 2000 Reporting Services after you install security update MS05-004 for the .NET Framework 1.1 Q895242 KB895242 November 28, 2007
• 942861 Error message when an application connects to SQL Server on a server that is running Windows Server 2003: "General Network error," "Communication link failure," or "A transport-level error" Q942861 KB942861 November 27, 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
• 944486 FIX: You cannot open an Excel workbook that is exported from SQL Server 2000 Reporting Services on a Macintosh computer Q944486 KB944486 November 26, 2007
• 884525 Additions to the SQL Server 2000 Service Pack 4 readme files Q884525 KB884525 November 26, 2007
• 828280 How to configure an instance of SQL Server 2000 Analysis Services to use Kerberos authentication Q828280 KB828280 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
• 931975 How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007 Q931975 KB931975 November 20, 2007
• 930878 The remote instance of SQL Server 2000 does not stop when you use SQL Server Management Studio on the server that is running SQL Server 2005 Q930878 KB930878 November 20, 2007
• 929668 Error message when you use XML functionalities against an instance of SQL Server 2000 after you upgrade an instance of SQL Server 2000 to SQL Server 2005: "Failed to load msxmlsql.dll" Q929668 KB929668 November 20, 2007
• 929152 You cannot connect to a local instance of SQL Server on a Windows XP-based computer or on a Windows 2000-based computer when you use "localhost" in the pipe name Q929152 KB929152 November 20, 2007
• 928780 Event ID: 6036 is logged in the System log when you connect to an instance of SQL Server 2005 or to an instance of SQL Server 2000 from a Windows Vista-based computer Q928780 KB928780 November 20, 2007
• 928317 You must perform a full database backup before you back up the transaction log for a database in SQL Server 2005 and in SQL Server 2000 Q928317 KB928317 November 20, 2007
• 924947 SQL Server significantly increases the unused space for some tables Q924947 KB924947 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
• 922579 FIX: The operation may take longer than you expect when you run a warm query to obtain information from the Microsoft Search service in SQL Server 2005 Q922579 KB922579 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
• 921293 FIX: The description for the Dimension field is not set in the local cube file when you use the CREATE LOCAL CUBE statement in SQL Server 2005 Q921293 KB921293 November 20, 2007
• 919609 FIX: The SQL-DMO SpaceAvailableInMB property of the Database object may return an incorrect value in SQL Server 2005 or in SQL Server 2000 Q919609 KB919609 November 20, 2007
• 919394 Error message when you install SQL Server 2005: "Beta components detected" Q919394 KB919394 November 20, 2007
• 916287 A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2187 Q916287 KB916287 November 20, 2007
• 913945 Microsoft does not certify that third-party products will work with Microsoft SQL Server Q913945 KB913945 November 20, 2007
• 910716 Requirements for SQL Server 2005 and SQL Server 2000 to support remote mirroring of user databases Q910716 KB910716 November 20, 2007
• 906892 You may experience slow performance when you run 32-bit SQL Server tools on 64-bit operating systems Q906892 KB906892 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
• 935227 FIX: The document map area of a SQL Server 2000 Reporting Services report may be blank when you view the report in Windows Internet Explorer 7 Q935227 KB935227 November 19, 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
• 889552 Description of Service Pack 2 for SQL Server 2000: November 9, 2001 Q889552 KB889552 November 16, 2007
• 889551 Service Pack 3a for Microsoft SQL Server 2000 April 9, 2003 Q889551 KB889551 November 16, 2007
• 887165 BUG: You may receive an "Access is denied" error message when a query calls an extended stored procedure after you upgrade from SQL Server 2000 to SQL Server 2000 Service Pack 4 Q887165 KB887165 November 16, 2007
• 884012 You may not be able to connect to an instance of SQL Server 2000 Service Pack 2 or earlier that is installed on a Windows Server 2003 computer through the TCP/IP port Q884012 KB884012 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
• 257716 Frequently asked questions - SQL Server 2000 - Setup Q257716 KB257716 November 16, 2007
• 908915 FIX: You receive an error message when you use Microsoft OLE DB Provider for Visual FoxPro in SQL Server Q908915 KB908915 November 15, 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
• 827452 FIX: General network error when you try to back up or restore a SQL Server database on a computer that is running Windows Server 2003 Q827452 KB827452 November 15, 2007
• 887267 Ownership chaining is broken if the Execute command is enclosed in parentheses characters ("( )") in SQL Server 2000 Q887267 KB887267 November 14, 2007
• 872977 Actions in an SQL Server 2000 Analysis Services cube may return incorrect results or the actions are not accessible when you try to access the actions by using a client application Q872977 KB872977 November 14, 2007
• 824462 SqlCeCommand objects are not automatically disposed if you use a SqlCeDataAdapter object Q824462 KB824462 November 14, 2007
• 815430 INF: How to Suppress the Appshelp Message in an Unattended Installation Q815430 KB815430 November 14, 2007
• 814852 INF: How to Enable Encryption Support for SQL Server CE Databases Q814852 KB814852 November 14, 2007
• 814618 INF: How to Determine the Download Files You Need for Upgrading to SQL Server 2000 Service Pack 3 Q814618 KB814618 November 14, 2007
• 813849 INF: Enabling Cross-Database Ownership Chaining for Notification Services Databases Q813849 KB813849 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
• 939318 Error message when you insert data in an article that has automatic identity range handling enabled in a merge replication in SQL Server 2000: "The identity range managed by replication is full and must be updated by a replication agent" Q939318 KB939318 November 12, 2007
• 320499 How to manually synchronize replication subscriptions by using backup or restore Q320499 KB320499 November 12, 2007
• 324321 How to troubleshoot error 15401 Q324321 KB324321 November 9, 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
• 909544 An update is available for SQL Server 2000 Desktop Engine (SHAREPOINT) Q909544 KB909544 November 5, 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
• 935769 FIX: Error message when you upgrade a database from SQL Server 2000 Windows CE Edition 2.0 to SQL Server 2005 Mobile Edition: "The database file is larger than the configured maximum database size" Q935769 KB935769 November 4, 2007
• 905417 FIX: Error message when you try to open SQL Server 2000 Data Transformation Services (DTS) packages in SQL Server Management Studio: "SQL Server 2000 DTS Designer components are required to edit DTS packages" Q905417 KB905417 November 3, 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
• 936232 FIX: An access violation may occur when you try to log in to an instance of SQL Server 2000 Q936232 KB936232 November 2, 2007
• 935950 FIX: The foreign key that you created between two tables does not work after you run the CREATE INDEX statement in SQL Server 2000 Q935950 KB935950 November 2, 2007
• 934740 FIX: A Full-Text query against a Full-Text catalog that contains both the simplified Chinese word breaker and the traditional Chinese word breaker may not return some words in SQL Server 2000 Q934740 KB934740 November 2, 2007
• 934203 FIX: A hotfix for Microsoft SQL Server 2000 Service Pack 4 may not update all the necessary files on an x64-based computer Q934203 KB934203 November 2, 2007
• 933573 FIX: You may receive an assertion or database corruption may occur when you use the bcp utility or the "Bulk Insert" Transact-SQL command to import data in SQL Server 2000 Q933573 KB933573 November 2, 2007
• 932686 FIX: Error message when you use the sp_addarticle stored procedure to add articles to an existing transactional replication publication in SQL Server 2000: “Cannot create a file when that file already exists” Q932686 KB932686 November 2, 2007
• 932674 FIX: The sp_droparticle stored procedure performs very slowly if the @immediate_sync property is set to TRUE in SQL Server 2000 Service Pack 4 Q932674 KB932674 November 2, 2007
• 931932 FIX: The merge agent fails intermittently when you use merge replication that uses a custom resolver after you install SQL Server 2000 Service Pack 4 Q931932 KB931932 November 2, 2007
• 929410 FIX: Error message when you run a full-text query in SQL Server 2000: "Error: 17883, Severity: 1, State: 0" Q929410 KB929410 November 2, 2007
• 928810 Database corruption occurs after you run the "alter table" Transact-SQL command to change a column from not null to null in Microsoft SQL Server 2000 Q928810 KB928810 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
• 928322 SQL Server performance counters may not appear when you use System Monitor to monitor the performance counters on a remote computer that is running SQL Server 2000 Q928322 KB928322 November 2, 2007
• 928079 FIX: The Sqldumper.exe utility cannot generate a filtered SQL Server dump file when you use the Remote Desktop Connection service or Terminal Services to connect to a Windows 2000 Server-based computer in SQL Server 2000 Q928079 KB928079 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
• 926901 Error message when you try to change the SQL Server Agent proxy account in SQL Server 2000: "The system cannot find the path specified" Q926901 KB926901 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
• 925678 FIX: Error message when you schedule a Replication Merge Agent job to run after you install SQL Server 2000 Service Pack 4: "The process could not enumerate changes at the 'Subscriber'" Q925678 KB925678 November 2, 2007
• 925419 FIX: The server stops responding, the performance is slow, and a time-out occurs in SQL Server 2000 Q925419 KB925419 November 2, 2007
• 925297 FIX: The result may be sorted in the wrong order when you run a query that uses the ORDER BY clause to sort a column in a table in SQL Server 2000 Q925297 KB925297 November 2, 2007
• 924664 FIX: You cannot stop the SQL Server service, or many minidump files and many log files are generated in SQL Server 2000 Q924664 KB924664 November 2, 2007
• 923563 FIX: Error message when you configure an immediate updating transactional replication in SQL Server 2000: "Implicit conversion from datatype 'text' to 'nvarchar' is not allowed" Q923563 KB923563 November 2, 2007
• 923344 FIX: A SQL Server 2000 session may be blocked for the whole time that a Snapshot Agent job runs Q923344 KB923344 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
• 922663 BUG: Error message when you replicate a table to a SQL Server destination by using snapshot replication in SQL Server 2000: "Bulk-copy commit failed (bcp_batch) ODBC message: SQLSTATE 37000, native error 4813" Q922663 KB922663 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
• 920930 FIX: Error message when you try to run a query on a linked server in SQL Server 2000 Q920930 KB920930 November 2, 2007
• 920768 The DBCC SHRINKFILE statement has no effect when you run it after you run the DBCC SHRINKFILE statement together with the EMPTYFILE option in SQL Server 2000 Q920768 KB920768 November 2, 2007
• 919638 Query performance may decrease when you try to run a query in a parallel plan in SQL Server 2000 Q919638 KB919638 November 2, 2007
• 919399 FIX: A profiler trace in SQL Server 2000 may stop logging events unexpectedly, and you may receive the following error message: "Failed to read trace data" Q919399 KB919399 November 2, 2007
• 919221 FIX: SQL Server 2000 may take a long time to complete the synchronization phase when you create a merge publication Q919221 KB919221 November 2, 2007
• 919165 FIX: A memory leak occurs when you run a remote query by using a linked server in SQL Server 2000 Q919165 KB919165 November 2, 2007
• 919133 FIX: Each query takes a long time to compile when you execute a single query or when you execute multiple concurrent queries in SQL Server 2000 Q919133 KB919133 November 2, 2007
• 919068 FIX: The query may return incorrect results, and the execution plan for the query may contain a "Table Spool" operator in SQL Server 2000 Q919068 KB919068 November 2, 2007
• 917972 FIX: You receive an access violation error message when you try to perform a read of a large binary large object column in SQL Server 2000 Q917972 KB917972 November 2, 2007
• 917606 FIX: You may notice a decrease in performance when you run a query that uses the UNION ALL operator in SQL Server 2000 Service Pack 4 Q917606 KB917606 November 2, 2007
• 917593 FIX: The "Audit Logout" event does not appear in the trace results file when you run a profiler trace against a linked server instance in SQL Server 2000 Q917593 KB917593 November 2, 2007
• 917544 BUG: You receive an error message when you run the "Log Shipping Alert Job - Restore" job in SQL Server 2000 Q917544 KB917544 November 2, 2007
• 917047 Microsoft SQL Server I/O subsystem requirements for the tempdb database Q917047 KB917047 November 2, 2007
• 917043 Key factors to consider when evaluating third-party file cache systems with SQL Server Q917043 KB917043 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
• 916698 FIX: Error message when you run SQL Server 2000: "Failed assertion = 'lockFound == TRUE'" Q916698 KB916698 November 2, 2007
• 916653 FIX: An access violation may occur intermittently in the CQList::Remove function when you run a query in SQL Server 2000 Q916653 KB916653 November 2, 2007
• 916652 FIX: An access violation may occur when you run a query on a table that has a multicolumn index in SQL Server 2000 Q916652 KB916652 November 2, 2007
• 915436 FIX: Error message when you run a complex insert query or a stored procedure in SQL Server 2000: "Internal SQL Server error" Q915436 KB915436 November 2, 2007
• 915340 FIX: A deadlock occurs when the scheduled SQL Server Agent job that you add or that you update is running in SQL Server 2000 Q915340 KB915340 November 2, 2007
• 915328 FIX: You may intermittently experience an access violation error when a query is executed in a parallel plan and the execution plan contains either a HASH JOIN operation or a Sort operation in SQL Server 2000 Q915328 KB915328 November 2, 2007
• 914534 Error message when you run the sp_databases stored procedure in SQL Server 2000: "Arithmetic overflow error converting expression to data type int" Q914534 KB914534 November 2, 2007
• 914439 FIX: The synchronization process may take a long time when you synchronize merge replication publications in SQL Server 2000 Q914439 KB914439 November 2, 2007
• 914384 FIX: The database status changes to Suspect when you perform a bulk copy in a transaction and then roll back the transaction in SQL Server 2000 Q914384 KB914384 November 2, 2007
• 914298 FIX: You may receive an error message, and the SQL Server process may crash when you copy or transfer SQL Server 2000 data Q914298 KB914298 November 2, 2007
• 914157 Error message when you open SQL Server Enterprise Manager after you uninstall the SQL Server 2005 Backward Compatibility Components: "Snap-in failed to initialize" Q914157 KB914157 November 2, 2007
• 914085 FIX: You may receive an error message when you try to use a Japanese user name or a Korean user name to connect to an Analysis Services server Q914085 KB914085 November 2, 2007
• 913684 FIX: You may receive error messages when you use linked servers in SQL Server 2000 on a 64-bit Itanium processor Q913684 KB913684 November 2, 2007
• 913438 FIX: The SQL Server process may end unexpectedly when you turn on trace flag -T1204 and a profiler trace is capturing the Lock:DeadLock Chain event in SQL Server 2000 SP4 Q913438 KB913438 November 2, 2007
• 913399 Space that a table uses is not completely released after you use a DELETE statement to delete data from the table in SQL Server Q913399 KB913399 November 2, 2007
• 913314 FIX: The latest report in the archive is printed instead of the snapshot of the archived report in SQL Server 2000 Q913314 KB913314 November 2, 2007
• 913100 FIX: The MSDE writer is not included when you try to use the Vssadmin.exe tool to list subscribed volume shadow copy writers Q913100 KB913100 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
• 911848 SQL Server incorrectly returns rows that have a NULL value when you try to filter non-Unicode data columns for records from a table Q911848 KB911848 November 2, 2007
• 911841 You may receive an "Error 22022: SQLServerAgent is not currently running so it cannot be notified of this action" error message when you run a SQL Server Agent job in SQL Server 2000 Q911841 KB911841 November 2, 2007
• 911678 FIX: No rows may be returned, and you may receive an error message when you try to import SQL Profiler trace files into tables by using the fn_trace_gettable function in SQL Server 2000 Q911678 KB911678 November 2, 2007
• 911677 FIX: A query may run more slowly against SQL Server 2000 post-SP3 hotfix build 8.00.0988 than a query that you run against SQL Server 2000 post-SP3 hotfix builds that are earlier than build 8.00.0988 Q911677 KB911677 November 2, 2007
• 911569 FIX: You may receive an access violation error message when you run a linked server query that includes a subquery Q911569 KB911569 November 2, 2007
• 910895 FIX: You may receive an error message when you set the database collation to Thai_CI_AS and you try to run a Transact-SQL update query in SQL Server 2000 Q910895 KB910895 November 2, 2007
• 910741 BUG: Login names that contain leading zero characters are not visible when you use SQL Profiler to audit connections to SQL Server 2000 Q910741 KB910741 November 2, 2007
• 910710 FIX: You receive an error message when a Visual Basic application opens a dynamic cursor on a GROUP BY query in SQL Server 2000 Service Pack 4 Q910710 KB910710 November 2, 2007
• 910707 FIX: When you query a view that was created by using the VIEW_METADATA option, an access violation may occur in SQL Server 2000 Q910707 KB910707 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
• 910392 FIX: You may receive incorrect results when you run a Transact-SQL query in SQL Server 2000 Q910392 KB910392 November 2, 2007
• 909734 FIX: An error message is logged, and new diagnostics do not capture the thread stack when the SQL Server User Mode Scheduler (UMS) experiences a nonyielding thread in SQL Server 2000 Service Pack 4 Q909734 KB909734 November 2, 2007
• 909379 FIX: You receive a 17883 error message when you run a complex query against SQL Server 2000 Q909379 KB909379 November 2, 2007
• 909369 FIX: Automatic checkpoints on some SQL Server 2000 databases do not run as expected Q909369 KB909369 November 2, 2007
• 909100 FIX: The performance of the statement that raises an error differs from the performance of the statement that does not raise an error when you trace exception events in SQL Server 2000 on an IA-64 computer Q909100 KB909100 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
• 908476 You may receive messages that state that the computer is out of memory when you run Virtual Server 2005 and SQL Server 2000 as peer applications on the same computer Q908476 KB908476 November 2, 2007
• 908243 BUG: You receive an "Error 14269" error message when you try to modify the SQL Server Agent job if the combination of the computer name and the instance name is more than 30 characters in SQL Server 2000 Q908243 KB908243 November 2, 2007
• 907813 FIX: An error occurs when you try to access the Analysis Services performance monitor counter object after you apply Windows Server 2003 SP1 Q907813 KB907813 November 2, 2007
• 907250 FIX: You may experience concurrency issues when you run the DBCC INDEXDEFRAG statement in SQL Server 2000 Q907250 KB907250 November 2, 2007
• 907009 FIX: You may receive the "Server Msg 8630, Level 17, State 34, Procedure <TableName>, Line nn" error message when you try to delete records from a table that has FOREIGN KEY constraints on many tables in SQL Server 2000 with Service Pack 4 Q907009 KB907009 November 2, 2007
• 906890 FIX: You receive an access violation error message when a user-defined function is in a high-stress scenario in SQL Server 2000 Q906890 KB906890 November 2, 2007
• 906566 How to use XQuery to query XML data from a SQL Server 2000 database in SQL Server 2005 Q906566 KB906566 November 2, 2007
• 905622 You experience poor performance when you run reports if the "Auto close" option is enabled for the ReportServerTempDB database in SQL Server 2000 Reporting Services Q905622 KB905622 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
• 904804 You experience slow performance when you back up the database in SQL Server 2000 Q904804 KB904804 November 2, 2007
• 904244 FIX: Incorrect data is inserted unexpectedly when you perform a bulk copy operation by using the DB-Library API in SQL Server 2000 Service Pack 4 Q904244 KB904244 November 2, 2007
• 903888 FIX: Error message when you run the SQL Server Upgrade Wizard to upgrade SQL Server 6.5 to SQL Server 2000 SP4: "Couldn't create or register the SQLUpgrade DSN" Q903888 KB903888 November 2, 2007
• 903646 An application that uses the Virtual Device Interface feature of SQL Server 2000 to back up a SQL Server 2000 database may not back up the database Q903646 KB903646 November 2, 2007
• 903643 The Ntbackup.exe operation may break the differential backup chain of a SQL Server database and may invalidate the differential backups when you perform a snapshot backup of the database Q903643 KB903643 November 2, 2007
• 903086 FIX: The batch job stops running, and job output is truncated when you run a Transact-SQL script as a SQL Server Agent job in SQL Server 2000 Q903086 KB903086 November 2, 2007
• 902955 FIX: You receive a "Getting registry information" message when you run the Sqldiag.exe utility after you install SQL Server 2000 SP4 Q902955 KB902955 November 2, 2007
• 902852 FIX: Error message when you run an UPDATE statement that uses two JOIN hints to update a table in SQL Server 2000: "Internal SQL Server error" Q902852 KB902852 November 2, 2007
• 902851 FIX: SQL Server 2000 may intermittently appear to stop responding (hang) during a scheduled maintenance DBCC DBREINDEX operation Q902851 KB902851 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
• 901212 FIX: You receive an error message if you use the sp_addalias or sp_dropalias procedures when the IMPLICIT_TRANSACTIONS option is set to ON in SQL Server 2000 SP4 Q901212 KB901212 November 2, 2007
• 901200 FIX: You may receive a “Server: Msg 7358, Level 16, State 1, Line 1” error message after you run a linked server query in SQL Server 2000 Service Pack 4 Q901200 KB901200 November 2, 2007
• 900961 FIX: A memory leak may occur when a client application uses the Dbmslpcn.dll shared memory network library version 2000.80.828.0 and connects to a local computer that is running SQL Server 2000 Q900961 KB900961 November 2, 2007
• 900625 FIX: The error message that the SELECT statement returns may contain user data in SQL Server 2000 Q900625 KB900625 November 2, 2007
• 900470 FIX: You may receive an error message when you perform transactional replication in SQL Server 2000 Q900470 KB900470 November 2, 2007
• 900416 FIX: A 17883 error may occur you run a query that uses a hash join in SQL Server 2000 Q900416 KB900416 November 2, 2007
• 900404 FIX: The results of the query may be returned much slower than you expect when you run a query that includes a GROUP BY statement in SQL Server 2000 Q900404 KB900404 November 2, 2007
• 900390 FIX: The Mssdmn.exe process may use lots of CPU capacity when you perform a SQL Server 2000 full text search of Office Word documents Q900390 KB900390 November 2, 2007
• 900335 FIX: The SQL Server 2000 automatic database recovery operation may not succeed if an index contains a FLOAT data type or a REAL data type, and this data type contains a NaN value Q900335 KB900335 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
• 899430 FIX: An access violation may occur when you run a SELECT query and the NO_BROWSETABLE option is set to ON in Microsoft SQL Server 2000 Q899430 KB899430 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
• 898709 FIX: Error message when you use SQL Server 2000: "Time out occurred while waiting for buffer latch type 3" Q898709 KB898709 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
• 898541 FIX: Latch time-out errors may be written to the SQL Server error log when you stop a full-text search in SQL Server 2000 Q898541 KB898541 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
• 897578 FIX: Only the master database and the tempdb database are listed when you try to create a new job in SQL Server Enterprise Manager Q897578 KB897578 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
• 896985 FIX: The Subscriber may not be able to upload changes to the Publisher when you incrementally add an article to a publication in SQL Server 2000 SP3 Q896985 KB896985 November 2, 2007
• 896980 FIX: The query plan may take longer than expected to compile, and you may receive error message 701, error message 8623, or error message 8651 in SQL Server 2000 Q896980 KB896980 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
• 896373 You may receive a SqlException error message when your .NET Framework client application calls a stored procedure that has an output parameter of the nvarchar type and the application uses the SqlClient class to work with SQL Server 2000 Q896373 KB896373 November 2, 2007
• 895187 FIX: You receive an error message when you try to delete records by running a Delete Transact-SQL statement in SQL Server 2000 Q895187 KB895187 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
• 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 Q894257 KB894257 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
• 892141 FIX: A stack overflow exception may occur, and SQL Server 2000 may unexpectedly close when you submit a query that uses the UNION ALL operator more than 255 times Q892141 KB892141 November 2, 2007
• 892028 The TextData column may be empty for the SP:StmtStarting, SP:StmtCompleted, SQL:StmtStarting, and SQL:StmtCompleted events when you use SQL Profiler to capture SQL Server traces in SQL Server 2000 Q892028 KB892028 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
• 890043 FIX: The PKM Search Filter Daemon (Mssdmn.exe) may unexpectedly crash when you parse Office Word documents in SQL Server 2000 Q890043 KB890043 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
• 889166 FIX: You receive a "Msg 3628" error message when you run an inner join query in SQL Server 2000 Q889166 KB889166 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
• 887700 FIX: Server Network Utility may display incorrect protocol properties in SQL Server 2000 Q887700 KB887700 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
• 884856 FIX: The non-clustered index is corrupted after you perform a self-update query in SQL Server 2000 Q884856 KB884856 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
• 870972 FIX: The performance of a DML operation that fires a trigger may decrease when the trigger execution plan recompiles repeatedly Q870972 KB870972 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
• 867746 FIX: The UPDATE query blocks the SELECT query when you run an UPDATE query and a SELECT query at the same time in SQL Server 2000 Q867746 KB867746 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
• 841175 FIX: You may receive an exception access violation for the Ssnetlib.dll file in SQL Server 2000 Q841175 KB841175 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
• 835581 FIX: An "Error 17883" error message may be logged, and SQL Server 2000 or SQL Server 7.0 may stop responding when you run an application that creates COM objects by using the sp_OACreate function Q835581 KB835581 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
• 832977 FIX: The DBCC PSS Command may cause access violations and 17805 errors in SQL Server 2000 Q832977 KB832977 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
• 830912 FIX: Key Names Read from an .Ini File for a Dynamic Properties Task May Be Truncated Q830912 KB830912 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
• 830767 FIX: SQL Query Analyzer may stop responding when you close a query window or open a file Q830767 KB830767 November 2, 2007
• 830596 FIX: You Receive an Error Message When the xp_logininfo Extended Stored Procedure Runs Q830596 KB830596 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
• 830382 FIX: Distributed Queries May Incorrectly Use SQL Server Startup Account Permissions When SQL Server is Running in Fiber Mode Q830382 KB830382 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
• 830298 FIX: SQL Server 2000 SP3 may generate slower query plans and bad cardinality estimates Q830298 KB830298 November 2, 2007
• 830262 FIX: Unconditional Update May Not Hold Key Locks on New Key Values Q830262 KB830262 November 2, 2007
• 829444 FIX: A floating point exception occurs during the optimization of a query Q829444 KB829444 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
• 828699 FIX: An Access Violation Occurs When You Run DBCC UPDATEUSAGE on a Database That Has Many Objects Q828699 KB828699 November 2, 2007
• 828637 FIX: Users Can Control the Compensating Change Process in Merge Replication Q828637 KB828637 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
• 828096 FIX: Key Locks Are Held Until the End of the Statement for Rows That Do Not Pass Filter Criteria Q828096 KB828096 November 2, 2007
• 827954 FIX: Slow Execution Times May Occur When You Run DML Statements Against Tables That Have Cascading Referential Integrity Q827954 KB827954 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
• 827175 FIX: Incorrect Parameter Numbering Occurs in Custom Stored Procedures That Are Generated with the Sp_scriptpublicationcustomprocs Stored Procedure Q827175 KB827175 November 2, 2007
• 826906 FIX: A query that uses a view that contains a correlated subquery and an aggregate runs slowly Q826906 KB826906 November 2, 2007
• 826860 FIX: Linked Server Query May Return NULL If It Is Performed Through a Keyset Cursor Q826860 KB826860 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
• 826822 FIX: A Member of the db_accessadmin Fixed Database Role Can Create an Alias for the dbo Special User Q826822 KB826822 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
• 826364 FIX: A Query with a LIKE Comparison Results in a Non-Optimal Query Plan When You Use a Hungarian SQL Server Collation Q826364 KB826364 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
• 825854 FIX: No Exclusive Locks May Be Taken If the DisAllowsPageLocks Value Is Set to True Q825854 KB825854 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
• 825045 FIX: The Merge Agent Takes a Long Time to Download New Data When It Runs on a New Anonymous Subscription Q825045 KB825045 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
• 825025 FIX: You Cannot Synchronize Between a Replication Publisher and a Replication Republisher Q825025 KB825025 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
• 824028 FIX: An Outer or Semi JOIN Query That Results in Hash Role Reversal Followed by a Spill May Return Incorrect Results Q824028 KB824028 November 2, 2007
• 824027 FIX: A Cursor with a Large Object Parameter May Cause an Access Violation on CStmtCond::XretExecute Q824027 KB824027 November 2, 2007
• 824018 FIX: Parallel Query That Uses an Indexed bit Column May Return Results That Are Not Correct Q824018 KB824018 November 2, 2007
• 823877 FIX: An Access Violation May Occur When You Run a Query That Contains 32,000 or More OR Clauses Q823877 KB823877 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
• 822757 FIX: An Insert Select Command with OPENXML and a Sql_variant Type Can Cause Error 2537 to Occur Q822757 KB822757 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
• 822746 FIX: Incorrect Results From a Parallel Query That Uses a UNION and Variables or Parameters Q822746 KB822746 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
• 822400 Description of disaster recovery options for Microsoft SQL Server Q822400 KB822400 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
• 822033 FIX: A Parameterized UNION Query Inside a Stored Procedure Returns Incorrect Results Q822033 KB822033 November 2, 2007
• 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 Q821806 KB821806 November 2, 2007
• 821741 FIX: Lock monitor exception in DeadlockMonitor::ResolveDeadlock Q821741 KB821741 November 2, 2007
• 821740 FIX: MS DTC Transaction Commit Operation Blocks Itself Q821740 KB821740 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
• 821334 FIX: Issues that are resolved in SQL Server 2000 build 8.00.0859 Q821334 KB821334 November 2, 2007
• 820837 FIX: Allocation Caching Mechanisms Enable Faster Allocation of Pages to Objects Q820837 KB820837 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
• 819955 FIX: Using xp_sendmail with a COMPUTE Clause Causes an Access Violation Q819955 KB819955 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
• 819662 FIX: Distribution Cleanup Agent Incorrectly Cleans Up Entries for Anonymous Subscribers Q819662 KB819662 November 2, 2007
• 818899 FIX: Error Message 3628 May Occur When You Run a Complex Query Q818899 KB818899 November 2, 2007
• 818897 FIX: Invalid TDS Sent to SQL Server Results in Access Violation Q818897 KB818897 November 2, 2007
• 818806 FIX: Some Named Pipes features are not disabled after you disable the Named Pipes protocol Q818806 KB818806 November 2, 2007
• 818772 FIX: Cannot Set the Network Affinity for an Instance of SQL Server 2000 Service Pack 3 Q818772 KB818772 November 2, 2007
• 818729 FIX: Internal Query Processor Error 8623 When Microsoft SQL Server Tries to Compile a Plan for a Complex Query Q818729 KB818729 November 2, 2007
• 818540 FIX: SQL Server Enterprise Manager unexpectedly quits when you modify a DTS package Q818540 KB818540 November 2, 2007
• 818388 FIX: A Transact-SQL Statement That Is Embedded in the Database Name Runs with System Administrator Permissions Q818388 KB818388 November 2, 2007
• 818188 FIX: Query on the sysmembers Virtual Table May Fail with a Stack Overflow Q818188 KB818188 November 2, 2007
• 818097 FIX: An Access Violation May Occur When You Run DBCC DBREINDEX on a Table That Has Hypothetical Indexes Q818097 KB818097 November 2, 2007
• 818096 FIX: Many Extent Lock Time-outs May Occur During Extent Allocation Q818096 KB818096 November 2, 2007
• 818095 FIX: Cursor Plans Are Not Removed From the Cache When Virtual Memory Depleted Q818095 KB818095 November 2, 2007
• 818079 FIX: SQL Profiler Displays Incorrect TextData Value When You Run a Nested Stored Procedure by Using a Remote Procedure Call Q818079 KB818079 November 2, 2007
• 817464 FIX: Using Sp_executesql in Merge Agent Operations Q817464 KB817464 November 2, 2007
• 817368 FIX: An INSERT or UPDATE That Results in a Page Split Might Fail with Error 818 Q817368 KB817368 November 2, 2007
• 817359 FIX: An Access Violation May Occur When You Run an INSERT Statement in an nText Column Q817359 KB817359 November 2, 2007
• 817263 FIX: A SELECT Statement Against a View Might Not Return Qualifying Rows Q817263 KB817263 November 2, 2007
• 817262 FIX: Complex Query May Not Create an Execution Plan Q817262 KB817262 November 2, 2007
• 817186 FIX: A query that performs join operations between multiple tables may return incorrect results Q817186 KB817186 November 2, 2007
• 816985 FIX: You cannot install SQL Server 2000 SP3 on the Korean version of SQL Server 2000 Q816985 KB816985 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
• 816883 FIX: SQL Server Optimizer May Underestimate the Cardinality of Range Queries Q816883 KB816883 November 2, 2007
• 816834 FIX: Osql.exe May Not Run Batches As Fast As Other ODBC-Based Applications Q816834 KB816834 November 2, 2007
• 816503 FIX: Floating Point Exception (Error 3628) Might Occur for Queries That Need Merged Histograms Q816503 KB816503 November 2, 2007
• 816440 FIX: Error 8623 is Raised When SQL Server Compiles a Complex Query Q816440 KB816440 November 2, 2007
• 816084 FIX: sysindexes.statblob Column May Be Corrupted After You Run a DBCC DBREINDEX Statement Q816084 KB816084 November 2, 2007
• 816069 FIX: A Query with a Large IN Clause Can Cause Concurrency Issues Q816069 KB816069 November 2, 2007
• 816039 FIX: Code Point Comparison Semantics for SQL_Latin1_General_Cp850_BIN Collation Q816039 KB816039 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
• 815115 FIX: A DTS package that uses global variables ignores an error message raised by RAISERROR Q815115 KB815115 November 2, 2007
• 815057 FIX: SQL Server 2000 Uninstall Option Does Not Remove All Files Q815057 KB815057 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
• 814916 FIX: Merge Agent for a filtered publication might fail Q814916 KB814916 November 2, 2007
• 814894 FIX: The Xp_readmail Stored Procedure Only Saves the Text of an Embedded Attachment Q814894 KB814894 November 2, 2007
• 814889 FIX: A DELETE statement with a JOIN might fail and you receive a 625 error Q814889 KB814889 November 2, 2007
• 814665 FIX: SQL Server Assertion: "nret == FALSE" Occurs When You Insert or Update Table Data in SQL Server 2000 Q814665 KB814665 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
• 814460 FIX: Merge Replication with Alternate Synchronization Partners May Not Succeed After You Change the Retention Period Q814460 KB814460 November 2, 2007
• 814032 FIX: Merge publications cannot synchronize on SQL Server 2000 Service Pack 3 Q814032 KB814032 November 2, 2007
• 813779 FIX: A DML Operation on a Large Table Can Cause Performance Problems Q813779 KB813779 November 2, 2007
• 813769 FIX: You May Experience Slow Performance When You Debug a SQL Server Service Q813769 KB813769 November 2, 2007
• 813759 FIX: A Large Number of NULL Values in Join Columns Result in Slow Query Performance Q813759 KB813759 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
• 813412 FIX: xp_readmail Returns NULL in the attachment Column If the Attachment's Type Is Message Format Q813412 KB813412 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
• 812995 FIX: A Query with an Aggregate Function May Fail with a 3628 Error Q812995 KB812995 November 2, 2007
• 812798 FIX: A UNION ALL View May Not Use Index If Partitions Are Removed at Compile Time Q812798 KB812798 November 2, 2007
• 812393 FIX: Update or Delete Statement Fails with Error 1203 During Row Lock Escalation Q812393 KB812393 November 2, 2007
• 812250 FIX: Indexed View May Cause a Handled Access Violation in CIndex::SetLevel1Names Q812250 KB812250 November 2, 2007
• 811703 FIX: Unexpected results from partial aggregations based on conversions Q811703 KB811703 November 2, 2007
• 811628 FIX: Many Temporary Tables Remain After Analysis Services Drills Down a ROLAP Cube in SQL Server Q811628 KB811628 November 2, 2007
• 811611 FIX: Reinitialized SQL Server CE 2.0 subscribers may experience data loss and non-convergence Q811611 KB811611 November 2, 2007
• 811467 FIX: A Unicode LIKE Predicate with Binary Collation May Return Incorrect Results Q811467 KB811467 November 2, 2007
• 811205 FIX: An error message occurs when you perform a database or a file SHRINK operation Q811205 KB811205 November 2, 2007
• 811052 FIX: Latch Time-Out Message 845 Occurs When You Perform a Database or File SHRINK Operation Q811052 KB811052 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
• 810688 FIX: Merge Agent Can Resend Changes for Filtered Publications Q810688 KB810688 November 2, 2007
• 810526 FIX: Cursors That Have a Long Lifetime May Cause Memory Fragmentation Q810526 KB810526 November 2, 2007
• 810163 FIX: An Access Violation Occurs if an sp_cursoropen Call References a Parameter That Is Not Defined Q810163 KB810163 November 2, 2007
• 810140 FIX: A Cursor DECLARE Statement with a Binary Large Object (Text/Ntext/Image) Parameter May Cause an Access Violation Q810140 KB810140 November 2, 2007
• 810072 FIX: Merge Replication Reconciler Stack Overflow Q810072 KB810072 November 2, 2007
• 810065 FIX: The "Data area passed to a system call is too small" error message is logged when you call the CreateEx method at the same time in a multiple-thread application that uses the Virtual Device Interface feature of SQL Server 2000 Q810065 KB810065 November 2, 2007
• 810052 FIX: A Memory Leak Occurs When Cursors Are Opened During a Connection Q810052 KB810052 November 2, 2007
• 810026 FIX: A DELETE Statement with a Self-Join May Fail and You Receive a 625 Error Q810026 KB810026 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
• 321843 Error message 1785 occurs when you create a FOREIGN KEY constraint that may cause multiple cascade paths Q321843 KB321843 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
• 306397 How to use Excel with SQL Server linked servers and distributed queries Q306397 KB306397 November 2, 2007
• 303411 You receive a "Warning SuperSocket Info" warning information when a SQL Server service account is a domain user Q303411 KB303411 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
• 296098 FIX: xp_sendmail Fails with the @attach_results Parameter on SQL Server 2000 Personal Edition Q296098 KB296098 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
• 265808 How to connect to a named instance of SQL Server 2005 or SQL Server 2000 by using the client tools in the earlier version of SQL Server Q265808 KB265808 November 2, 2007
• 263968 Service pack installation may save the system administrator password in a file Q263968 KB263968 November 2, 2007
• 246133 How to transfer logins and passwords between instances of SQL Server Q246133 KB246133 November 2, 2007
• 243586 Troubleshooting stored procedure recompilation Q243586 KB243586 November 2, 2007
• 234656 Description of using disk drive caches with SQL Server that every database administrator should know Q234656 KB234656 November 2, 2007
• 196909 How to increase the number of SQL Server error logs Q196909 KB196909 November 2, 2007
• 195565 Statistical maintenance functionality (autostats) in SQL Server Q195565 KB195565 November 2, 2007
• 148224 BUG: Cross-database table creation/drop in stored procedure Q148224 KB148224 November 2, 2007
• 70956 How to remove duplicate rows from a SQL Server table by using a script Q70956 KB70956 November 2, 2007