SQL Server 2000 articles, fixes and updates

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

308010 FIX: SQL Server Service Manager Fails with "The system cannot find the file specified" Error Message Q308010 KB308010 September 29, 2020
941105 FIX: Error messages after SQL Server has been running for some time on Windows Server 2003 or on Windows 2000: "Failed to load FileName.dll" and "Attempts to load any type of dll might fail within the SQL Server process" Q941105 KB941105 November 20, 2019
260418 Frequently asked questions - SQL Server 2000 - Server Q260418 KB260418 April 23, 2018
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 April 20, 2018
300183 FIX: SQL Server cluster resource fails to come online until the cluster service is restarted Q300183 KB300183 April 20, 2018
908915 FIX: You receive an error message when you use Microsoft OLE DB Provider for Visual FoxPro in SQL Server Q908915 KB908915 April 18, 2018
260414 Frequently asked questions - SQL Server 2000 - multiple instances Q260414 KB260414 April 18, 2018
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 February 16, 2017
904418 FIX: Event ID 20 "Volume Shadow Copy Service error" is logged when you back up the System State on a Windows Server 2003 x64 Edition-based computer that is running SQL Server 2000 Q904418 KB904418 February 16, 2017
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 December 9, 2015
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 December 9, 2015
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 December 9, 2015
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 January 17, 2015
924662 FIX: The query performance may be slow when you query data from a view in SQL Server 2000 Q924662 KB924662 January 17, 2015
923796 FIX: Data in a subscriber of a merge publication in SQL Server 2000 differs from the data in the publisher Q923796 KB923796 January 17, 2015
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 January 17, 2015
923344 FIX: A SQL Server 2000 session may be blocked for the whole time that a Snapshot Agent job runs Q923344 KB923344 January 17, 2015
923327 FIX: You may receive an access violation error message when you import data by using the "Bulk Insert" command in SQL Server 2000 Q923327 KB923327 January 17, 2015
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 January 17, 2015
922040 FIX: You cannot uninstall SQL Server 2000 build 2187 when SQL Server 2000 build 2187 is configured as a Microsoft Cluster Service (MSCS) node Q922040 KB922040 January 17, 2015
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 January 17, 2015
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 January 17, 2015
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 January 17, 2015
919221 FIX: SQL Server 2000 may take a long time to complete the synchronization phase when you create a merge publication Q919221 KB919221 January 17, 2015
919165 FIX: A memory leak occurs when you run a remote query by using a linked server in SQL Server 2000 Q919165 KB919165 January 17, 2015
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 January 17, 2015
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 January 17, 2015
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 January 17, 2015
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 January 17, 2015
917565 FIX: Error 17883 is logged in the SQL Server error log, and the instance of SQL Server 2000 temporarily stops responding Q917565 KB917565 January 17, 2015
916698 FIX: Error message when you run SQL Server 2000: "Failed assertion = 'lockFound == TRUE'" Q916698 KB916698 January 17, 2015
916653 FIX: An access violation may occur intermittently in the CQList::Remove function when you run a query in SQL Server 2000 Q916653 KB916653 January 17, 2015
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 January 17, 2015
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 January 17, 2015
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 January 17, 2015
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 January 17, 2015
915065 FIX: Error message when you try to apply a hotfix on a SQL Server 2000-based computer that is configured as a MSCS node: "An error in updating your system has occurred" Q915065 KB915065 January 17, 2015
914439 FIX: The synchronization process may take a long time when you synchronize merge replication publications in SQL Server 2000 Q914439 KB914439 January 17, 2015
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 January 17, 2015
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 January 17, 2015
913991 FIX: Hotfix files may not be copied to remote nodes when you install a 32-bit hotfix, and hotfix files may not be removed from remote nodes on a computer that is running SQL Server 2000 in an MSCS environment Q913991 KB913991 January 17, 2015
913789 FIX: The password that you specify in a BACKUP statement appears in the SQL Server Errorlog file or in the Application event log if the BACKUP statement does not run in SQL Server 2000 Q913789 KB913789 January 17, 2015
913684 FIX: You may receive error messages when you use linked servers in SQL Server 2000 on a 64-bit Itanium processor Q913684 KB913684 January 17, 2015
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 January 17, 2015
913314 FIX: The latest report in the archive is printed instead of the snapshot of the archived report in SQL Server 2000 Q913314 KB913314 January 17, 2015
912715 FIX: A text box that has a constant value and the same vertical position as an expression-based text box is not rendered in a report in SQL Server 2000 Reporting Services Q912715 KB912715 January 17, 2015
911678 FIX: User Transaction is Aborted When fn_trace_gettable Reads Corrupt Trace File Q911678 KB911678 January 17, 2015
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 January 17, 2015
911569 FIX: You may receive an access violation error message when you run a linked server query that includes a subquery Q911569 KB911569 January 17, 2015
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 January 17, 2015
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 January 17, 2015
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 January 17, 2015
910392 FIX: You may receive incorrect results when you run a Transact-SQL query in SQL Server 2000 Q910392 KB910392 January 17, 2015
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 January 17, 2015
909393 FIX: An access violation occurs and the Analysis Services service unexpectedly quits during the Startup process in Microsoft SQL Server 2000 Analysis Services Q909393 KB909393 January 17, 2015
909380 FIX: Error message 17883 may be logged in the error log when you try to manually update table statistics in SQL Server 2000 Q909380 KB909380 January 17, 2015
909379 FIX: You receive a 17883 error message when you run a complex query against SQL Server 2000 Q909379 KB909379 January 17, 2015
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 January 17, 2015
908621 FIX: The report does not work as expected when you export a SQL Server 2000 Reporting Services report to PDF format or to Excel Q908621 KB908621 January 17, 2015
908156 FIX: You receive an error message when MS DTC for SQL Server 2000 reuses a server process identifier (SPID) to enlist in a distributed transaction Q908156 KB908156 January 17, 2015
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 January 17, 2015
907250 FIX: You may experience concurrency issues when you run the DBCC INDEXDEFRAG statement in SQL Server 2000 Q907250 KB907250 January 17, 2015
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 January 17, 2015
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 January 17, 2015
906790 FIX: You receive an error message when you try to rebuild the master database after you have installed hotfix builds in SQL Server 2000 SP4 64-bit Q906790 KB906790 January 17, 2015
906532 FIX: Error message when you run the SQLDiag utility or the PSSDiag utility: "Exception creating Perfmon log" Q906532 KB906532 January 17, 2015
905765 FIX: A view is corrupted after you run the DBCC DBREINDEX Transact-SQL statement to rebuild the clustered index on a view in SQL Server 2000 Q905765 KB905765 January 17, 2015
905286 FIX: You receive an error message when you run SQL Server Setup to install SQL Server 2000 Service Pack 4 in binary-only mode on a failover cluster Q905286 KB905286 January 17, 2015
905223 FIX: An access violation may occur, and Event ID 117 may be logged in the Application event log when a dimension that is used as the basis for multiple virtual dimensions is dropped and then re-created in SQL Server 2000 Analysis Services Q905223 KB905223 January 17, 2015
905121 FIX: An error message is logged when you try to export a large report to PDF, and you cannot open a spreadsheet file in Office Excel that was exported from SQL Server 2000 Reporting Services Q905121 KB905121 January 17, 2015
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 January 17, 2015
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 January 17, 2015
903742 FIX: You receive an “Error: 8526, Severity: 16, State: 2” error message in SQL Profiler when you use SQL Query Analyzer to start or to enlist into a distributed transaction after you have installed SQL Server 2000 SP4 Q903742 KB903742 January 17, 2015
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 January 17, 2015
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 January 17, 2015
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 January 17, 2015
902851 FIX: SQL Server 2000 may intermittently appear to stop responding (hang) during a scheduled maintenance DBCC DBREINDEX operation Q902851 KB902851 January 17, 2015
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 January 17, 2015
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 January 17, 2015
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 January 17, 2015
900716 FIX: Physical memory usage increases for multithreaded applications in SQL Server 2000 Analysis Services Q900716 KB900716 January 17, 2015
900629 FIX: You receive a "Failed to open a table" error message when you try to open a trace table by using SQL Profiler after you upgrade to SQL Server 2000 Service Pack 4 Q900629 KB900629 January 17, 2015
900625 FIX: The error message that the SELECT statement returns may contain user data in SQL Server 2000 Q900625 KB900625 January 17, 2015
900470 FIX: You may receive an error message when you perform transactional replication in SQL Server 2000 Q900470 KB900470 January 17, 2015
900416 FIX: A 17883 error may occur you run a query that uses a hash join in SQL Server 2000 Q900416 KB900416 January 17, 2015
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 January 17, 2015
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 January 17, 2015
898109 FIX: SQL Server 2000 Analysis Services may unexpectedly close when you process a cube by using a custom Decision Support Object application and you query the cube in parallel by using one or more threads Q898109 KB898109 January 17, 2015
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 January 17, 2015
897127 Frequently asked questions about the SQL Server 2000 Reporting Services Data Gathering and Diagnosis tool (SRSDiag) Q897127 KB897127 January 17, 2015
897126 FIX: Rendering of a report in Office Excel may unexpectedly contain margins when you export the report from SQL Server 2000 Reporting Services Q897126 KB897126 January 17, 2015
890664 FIX: Event ID 128 may be logged if the lazy aggregation process is suspended multiple times in SQL Server 2000 Analysis Services Q890664 KB890664 January 17, 2015
890043 FIX: The PKM Search Filter Daemon (Mssdmn.exe) may unexpectedly crash when you parse Office Word documents in SQL Server 2000 Q890043 KB890043 January 17, 2015
889524 FIX: You receive an "Unexpected error encountered while updating repository Overflow" error message when you try to restore an OLAP database in SQL Server 2000 Analysis Services Q889524 KB889524 January 17, 2015
889400 FIX: Description of the problems that are fixed in hotfix build 8.0.902 in Microsoft SQL Server 2000 Reporting Services Q889400 KB889400 January 17, 2015
889166 FIX: You receive a "Msg 3628" error message when you run an inner join query in SQL Server 2000 Q889166 KB889166 January 17, 2015
886761 FIX: You may receive an “Analysis Server Error: Connection to the server is lost” error message during an incremental update of a changing dimension in SQL Server 2000 Analysis Services Q886761 KB886761 January 17, 2015
885286 FIX: The Reporting Services trace log file size may increase unexpectedly Q885286 KB885286 January 17, 2015
884856 FIX: The non-clustered index is corrupted after you perform a self-update query in SQL Server 2000 Q884856 KB884856 January 17, 2015
870972 FIX: The performance of a DML operation that fires a trigger may decrease when the trigger execution plan recompiles repeatedly Q870972 KB870972 January 17, 2015
842537 FIX: An image in a report does not appear in the preview of the report if the value property of the image is set to a URL path Q842537 KB842537 January 17, 2015
842518 FIX: An XML version tag is included at the beginning of non-XML files Q842518 KB842518 January 17, 2015
839854 FIX: An MDX query stops responding if the result for an axis contains more than 64,000 members Q839854 KB839854 January 17, 2015
838840 FIX: A memory leak occurs in Analysis Services when a VBA function is used in a calculation Q838840 KB838840 January 17, 2015
836055 Failures may occur during cube processing if you select a member key column that is not correct Q836055 KB836055 January 17, 2015
834495 FIX: Cut-and-paste operations fail with an internal error in Analysis Manager in SQL Server 2000 Analysis Services Q834495 KB834495 January 17, 2015
834491 FIX: The UPDATE CUBE MDX statement writes the remainder value of the writeback formula to a NULL cell Q834491 KB834491 January 17, 2015
831665 FIX: A drillthrough request may cause a SQL Server 2000 Analysis Services server to shut down Q831665 KB831665 January 17, 2015
318632 FIX: SQL Debugging may fail because of a strict local password complexity policy Q318632 KB318632 January 17, 2015
959678 FIX: When you run the SPSBackup.exe utility to back up a SQL Server 2000 database that is configured as a back-end database for a Windows SharePoint Services server, the backup operation fails Q959678 KB959678 January 16, 2015
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 January 16, 2015
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 January 16, 2015
929639 FIX: You cannot install SQL Server 2000 Reporting Services on a computer that has more than 16 processors Q929639 KB929639 January 16, 2015
929440 FIX: Error messages when you try to update table rows or insert table rows into a table in SQL Server 2000: "644" or "2511" Q929440 KB929440 January 16, 2015
929410 FIX: Error message when you run a full-text query in SQL Server 2000: "Error: 17883, Severity: 1, State: 0" Q929410 KB929410 January 16, 2015
928616 FIX: You may receive an exception when you run a multithreaded Java application that uses version 1.1 of the JDBC driver to connect to a SQL Server 2000 SP4 database Q928616 KB928616 January 16, 2015
927006 FIX: The background color of a printed report is white when you use the RSPrintClient ActiveX control in SQL Server 2000 Reporting Services to print a report that has a transparent background Q927006 KB927006 January 16, 2015
912424 FIX: Error message when you try to export a report that contains an image to a PDF file in SQL Server 2000 Reporting Services Service Pack 2: "A drawing error occurred" Q912424 KB912424 January 16, 2015
901383 FIX: A hotfix is available for SQL Server 2000 Reporting Services Service Pack 2 Q901383 KB901383 January 16, 2015
892098 FIX: You may receive the "Could not convert the data value due to reasons other than sign mismatch or overflow" error message when you use the ADSI OLE DB provider to retrieve I8 data type properties in Windows 2000 Server Q892098 KB892098 January 16, 2015
295029 FIX: ROLLBACK of Transaction May Abort Concurrently Active Transactions Q295029 KB295029 January 16, 2015
279490 FIX: Analysis Services 2000 Does Not Support Security Account Delegation Q279490 KB279490 January 16, 2015
921518 FIX: The IIS process that runs the SQL Server 2000 Windows CE Edition 2.0 Server Agent may stop unexpectedly Q921518 KB921518 January 15, 2015
921198 FIX: Error message when you export a matrix report or you use the Render method to render a matrix report to a PDF file or a TIFF file in SQL Server 2000 Reporting Services SP2: "Object reference not set to an instance of an object" Q921198 KB921198 January 15, 2015
914908 FIX: Warning message when you try to deploy a SQL Server CE 2.0 application in Visual Studio 2005: "The program is from an unknown publisher You should install it only if you trust its publisher" Q914908 KB914908 January 15, 2015
914839 FIX: Error message when you try to install SQL Server 2000 Service Pack 4 on a SQL Server 2000 cluster: "Setup failed to perform required operations on the cluster nodes" Q914839 KB914839 January 15, 2015
910369 FIX: Some parameter values that are sent in a non-Unicode format may be incorrectly converted when you use the SQL Server 2000 Driver for JDBC Q910369 KB910369 January 15, 2015
909475 FIX: You may receive an error message after you set the DownloadGenerationsPerBatch Merge Agent parameter to a large value in SQL Server 2000 Windows CE Edition 2.0 Q909475 KB909475 January 15, 2015
909399 FIX: Some java.sql.timestamp values may not be translated to the appropriate SQL Server date and time values in SQL Server 2000 Driver for JDBC Q909399 KB909399 January 15, 2015
909108 FIX: The Excel worksheet may be corrupted, and you may receive an error message when you export a report to an Excel worksheet in SQL Server 2000 Reporting Services Service Pack 2 Q909108 KB909108 January 15, 2015
294875 FIX: SQLTables() Function Returns No Data for SQL Server Database Names That Contain Underscore Q294875 KB294875 January 11, 2015
816840 FIX: Error 17883 May Display Message Text That Is Not Correct Q816840 KB816840 January 7, 2015
308211 FIX: SQLDescribeCol Returns Wrong Column Size in a Union Query with Parameters Q308211 KB308211 January 7, 2015
314515 Frequently asked questions - SQL Server 2000 - Log shipping Q314515 KB314515 June 22, 2014
257716 Frequently asked questions - SQL Server 2000 - Setup Q257716 KB257716 June 22, 2014
915834 FIX: You may receive an error message when you load the SQL Server 2000 Driver for JDBC and the SQL Server 2005 Driver for JDBC in the same application, you try to connect to a SQL Server 2005 database, and then you run a query Q915834 KB915834 June 20, 2014
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 June 20, 2014
826524 FIX: NON EMPTY Keyword Phrase May Not Remove All Empty Members from a Virtual Cube Q826524 KB826524 February 28, 2014
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 February 28, 2014
826161 FIX: You are prompted for password confirmation after you change a standard SQL Server login Q826161 KB826161 February 28, 2014
825854 FIX: No Exclusive Locks May Be Taken If the DisAllowsPageLocks Value Is Set to True Q825854 KB825854 February 28, 2014
825804 FIX: Hotfix information for build 8.0.872 of SQL Server 2000 Analysis Services 64-bit Q825804 KB825804 February 28, 2014
811274 FIX: Connection Failure With VIA/GigaNet Protocol Q811274 KB811274 February 28, 2014
832977 FIX: The DBCC PSS Command may cause access violations and 17805 errors in SQL Server 2000 Q832977 KB832977 February 27, 2014
831046 FIX: Incorrect Results Are Returned If a Slice Occurs on a Virtual Dimension in a Cube That Has Multiple Partitions Q831046 KB831046 February 27, 2014
831045 FIX: A Memory Leak Occurs When You Incrementally Update Dimensions That Contain Member Properties Q831045 KB831045 February 27, 2014
831042 FIX: Analysis Services crashes if you incrementally update a non-changing dimension Q831042 KB831042 February 27, 2014
830912 FIX: Key Names Read from an .Ini File for a Dynamic Properties Task May Be Truncated Q830912 KB830912 February 27, 2014
830767 FIX: SQL Query Analyzer may stop responding when you close a query window or open a file Q830767 KB830767 February 27, 2014
830722 FIX: Cube Processing Performance Is Slower on the 64-Bit Version of Analysis Services Than It Is on the 32-Bit Version Q830722 KB830722 February 27, 2014
830596 FIX: You Receive an Error Message When the xp_logininfo Extended Stored Procedure Runs Q830596 KB830596 February 27, 2014
830393 FIX: Queries Return Empty Result Sets If a Calculated Member Is Defined by Using the NonEmptyCrossjoin Function Q830393 KB830393 February 27, 2014
830382 FIX: Distributed Queries May Incorrectly Use SQL Server Startup Account Permissions When SQL Server is Running in Fiber Mode Q830382 KB830382 February 27, 2014
830298 FIX: SQL Server 2000 SP3 may generate slower query plans and bad cardinality estimates Q830298 KB830298 February 27, 2014
830262 FIX: Unconditional Update May Not Hold Key Locks on New Key Values Q830262 KB830262 February 27, 2014
829899 FIX: Delete of Dimension Member in Write-Enabled Dimension May Cause Service to Restart Q829899 KB829899 February 27, 2014
829582 FIX: Execution Location and Default Isolation Mode Connection String Properties Return Results That Are Not Correct Q829582 KB829582 February 27, 2014
829444 FIX: A floating point exception occurs during the optimization of a query Q829444 KB829444 February 27, 2014
829081 FIX: MDX query results may not be correct if dimension security is defined on a dimension Q829081 KB829081 February 27, 2014
829051 FIX: A Memory Leak May Occur When Many Connections Are Made in Analysis Services Q829051 KB829051 February 27, 2014
829050 FIX: Calculated Member in WHERE Clause May Cause Empty Result Q829050 KB829050 February 27, 2014
828699 FIX: An Access Violation Occurs When You Run DBCC UPDATEUSAGE on a Database That Has Many Objects Q828699 KB828699 February 27, 2014
828637 FIX: Users Can Control the Compensating Change Process in Merge Replication Q828637 KB828637 February 27, 2014
828096 FIX: Key Locks Are Held Until the End of the Statement for Rows That Do Not Pass Filter Criteria Q828096 KB828096 February 27, 2014
827954 FIX: Slow Execution Times May Occur When You Run DML Statements Against Tables That Have Cascading Referential Integrity Q827954 KB827954 February 27, 2014
827916 FIX: Dimension Calculated Member Caption Blank If Dimension Uses Caption Type Member Property Q827916 KB827916 February 27, 2014
827899 FIX: Prevent Analysis Services Processing Requests from Blocking Queries Q827899 KB827899 February 27, 2014
827898 FIX: Specify the Analysis Services Client Locale on the Connection String Q827898 KB827898 February 27, 2014
827175 FIX: Incorrect Parameter Numbering Occurs in Custom Stored Procedures That Are Generated with the Sp_scriptpublicationcustomprocs Stored Procedure Q827175 KB827175 February 27, 2014
826906 FIX: A query that uses a view that contains a correlated subquery and an aggregate runs slowly Q826906 KB826906 February 27, 2014
826860 FIX: Linked Server Query May Return NULL If It Is Performed Through a Keyset Cursor Q826860 KB826860 February 27, 2014
826822 FIX: A Member of the db_accessadmin Fixed Database Role Can Create an Alias for the dbo Special User Q826822 KB826822 February 27, 2014
825045 FIX: The Merge Agent Takes a Long Time to Download New Data When It Runs on a New Anonymous Subscription Q825045 KB825045 February 27, 2014
825025 FIX: You Cannot Synchronize Between a Replication Publisher and a Replication Republisher Q825025 KB825025 February 27, 2014
824219 FIX: You Receive an Incorrect Result in a MOLAP Cube That Uses the Float Datatype Column for a Measure Q824219 KB824219 February 27, 2014
824028 FIX: An Outer or Semi JOIN Query That Results in Hash Role Reversal Followed by a Spill May Return Incorrect Results Q824028 KB824028 February 27, 2014
824027 FIX: A Cursor with a Large Object Parameter May Cause an Access Violation on CStmtCond::XretExecute Q824027 KB824027 February 27, 2014
824018 FIX: Parallel Query That Uses an Indexed bit Column May Return Results That Are Not Correct Q824018 KB824018 February 27, 2014
823877 FIX: An Access Violation May Occur When You Run a Query That Contains 32,000 or More OR Clauses Q823877 KB823877 February 27, 2014
823514 FIX: Build 8.00.0837: A query that contains a correlated subquery runs slowly Q823514 KB823514 February 27, 2014
823474 FIX: An MDX Query May Fail If It References a Dimension That Has Been Loaded by the VLDM Q823474 KB823474 February 27, 2014
823373 FIX: Access violations may occur in Analysis Services if real-time ROLAP cubes are stressed Q823373 KB823373 February 27, 2014
822839 FIX: #ERR Is Returned for Cells That Are Sourced from Remote Partitions Q822839 KB822839 February 27, 2014
822838 FIX: "Unable to Expand Node" Error Message When You Try to Expand a Member Node Q822838 KB822838 February 27, 2014
822757 FIX: An Insert Select Command with OPENXML and a Sql_variant Type Can Cause Error 2537 to Occur Q822757 KB822757 February 27, 2014
822746 FIX: Incorrect Results From a Parallel Query That Uses a UNION and Variables or Parameters Q822746 KB822746 February 27, 2014
822672 FIX: Hotfix Information for Build 8.0.826.0 of SQL Server 2000 Analysis Services 64-bit Q822672 KB822672 February 27, 2014
822652 FIX: HTTP Connections to Analysis Services Server Computers Running Windows Server 2003 Are Slow Q822652 KB822652 February 27, 2014
822651 FIX: Remote Partitions Are Marked as "Unprocessed" After You Perform an Incremental Update of a Virtual Dimension Q822651 KB822651 February 27, 2014
822650 FIX: An UPDATE CUBE Statement Returns an Error When You Try to Update a Measure in a Virtual Cube Q822650 KB822650 February 27, 2014
822033 FIX: A Parameterized UNION Query Inside a Stored Procedure Returns Incorrect Results Q822033 KB822033 February 27, 2014
822017 FIX: Hotfix Information for Build 8.0.810.0 of SQL Server 2000 Analysis Services 64-bit Q822017 KB822017 February 27, 2014
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 February 27, 2014
821752 FIX: Restricted Client Property Is Not Available in the Connection Properties Collection Q821752 KB821752 February 27, 2014
821741 FIX: Lock monitor exception in DeadlockMonitor::ResolveDeadlock Q821741 KB821741 February 27, 2014
821740 FIX: MS DTC Transaction Commit Operation Blocks Itself Q821740 KB821740 February 27, 2014
821548 FIX: A Parallel Query May Generate an Access Violation After You Install SQL Server 2000 SP3 Q821548 KB821548 February 27, 2014
821479 FIX: Analysis Client Sends Calculated Member Definitions When a Query Is Sent to a Server Q821479 KB821479 February 27, 2014
821334 FIX: Issues that are resolved in SQL Server 2000 build 8.00.0859 Q821334 KB821334 February 27, 2014
821180 FIX: Introduction of the Cache Ratio2 Parameter Q821180 KB821180 February 27, 2014
821104 FIX: Query Results Are Not Correct After You Perform an Incremental Update of a Changing Dimension and a Virtual Dimension Q821104 KB821104 February 27, 2014
821103 FIX: The Processing of a Cube That Contains a Virtual Dimension Fails with Error Message: "Object does not exist" Q821103 KB821103 February 27, 2014
820837 FIX: Allocation Caching Mechanisms Enable Faster Allocation of Pages to Objects Q820837 KB820837 February 27, 2014
820358 FIX: A Lazy Aggregation Might Fail After an Incremental Update of a Changing Dimension Q820358 KB820358 February 27, 2014
819955 FIX: Using xp_sendmail with a COMPUTE Clause Causes an Access Violation Q819955 KB819955 February 27, 2014
819757 FIX: MDX Calculated Members That Return String Values May Cause an Empty Result Set Q819757 KB819757 February 27, 2014
819662 FIX: Distribution Cleanup Agent Incorrectly Cleans Up Entries for Anonymous Subscribers Q819662 KB819662 February 27, 2014
819020 FIX: Incremental Update Process May Fail On Cubes or Partitions That Use the HOLAP Storage Mode Q819020 KB819020 February 27, 2014
818969 FIX: EstimatedRows Property of Aggregation is Not Updateable Q818969 KB818969 February 27, 2014
818899 FIX: Error Message 3628 May Occur When You Run a Complex Query Q818899 KB818899 February 27, 2014
818897 FIX: Invalid TDS Sent to SQL Server Results in Access Violation Q818897 KB818897 February 27, 2014
818806 FIX: Some Named Pipes features are not disabled after you disable the Named Pipes protocol Q818806 KB818806 February 27, 2014
818772 FIX: Cannot Set the Network Affinity for an Instance of SQL Server 2000 Service Pack 3 Q818772 KB818772 February 27, 2014
818769 FIX: Trace Flag -T8002 Treats an Affinity Mask Like a Process Affinity Q818769 KB818769 February 27, 2014
818768 FIX: Cannot Set SQL Server Instance Specific Network Affinity Q818768 KB818768 February 27, 2014
818767 FIX: Improved CPU Usage for Database Logging When Transaction Log Stalls Occur Q818767 KB818767 February 27, 2014
818766 FIX: Intense SQL Server activity results in spinloop wait Q818766 KB818766 February 27, 2014
818729 FIX: Internal Query Processor Error 8623 When Microsoft SQL Server Tries to Compile a Plan for a Complex Query Q818729 KB818729 February 27, 2014
818414 FIX: The Sqldumper.exe File Does Not Generate a Userdump File When It Runs Against a Windows Service Q818414 KB818414 February 27, 2014
818388 FIX: A Transact-SQL Statement That Is Embedded in the Database Name Runs with System Administrator Permissions Q818388 KB818388 February 27, 2014
818188 FIX: Query on the sysmembers Virtual Table May Fail with a Stack Overflow Q818188 KB818188 February 27, 2014
818097 FIX: An Access Violation May Occur When You Run DBCC DBREINDEX on a Table That Has Hypothetical Indexes Q818097 KB818097 February 27, 2014
818096 FIX: Many Extent Lock Time-outs May Occur During Extent Allocation Q818096 KB818096 February 27, 2014
818095 FIX: Cursor Plans Are Not Removed From the Cache When Virtual Memory Depleted Q818095 KB818095 February 27, 2014
818079 FIX: SQL Profiler Displays Incorrect TextData Value When You Run a Nested Stored Procedure by Using a Remote Procedure Call Q818079 KB818079 February 27, 2014
817909 FIX: Cannot Create an Offline Cube That Contains a Parent-Child Dimension Q817909 KB817909 February 27, 2014
817848 FIX: "Run-Time Error" Occurs with ExportData Method of BulkCopy Object When DataBase Name Contains Space Q817848 KB817848 February 27, 2014
817847 FIX: Incorrect Version of Sqlunirl.dll Is Installed with SQL Server 2000 Service Pack 3 Q817847 KB817847 February 27, 2014
817464 FIX: Using Sp_executesql in Merge Agent Operations Q817464 KB817464 February 27, 2014
817368 FIX: An INSERT or UPDATE That Results in a Page Split Might Fail with Error 818 Q817368 KB817368 February 27, 2014
817359 FIX: An Access Violation May Occur When You Run an INSERT Statement in an nText Column Q817359 KB817359 February 27, 2014
817297 FIX: EstimatedRows Property of Aggregation is Set to Zero for Aggregations That Have Several Dimension Members Cubes with Many Leaf Dimension Members Q817297 KB817297 February 27, 2014
817285 FIX: You may receive an error message after you run an MDX query that contains a user-defined function Q817285 KB817285 February 27, 2014
817263 FIX: A SELECT Statement Against a View Might Not Return Qualifying Rows Q817263 KB817263 February 27, 2014
817262 FIX: Complex Query May Not Create an Execution Plan Q817262 KB817262 February 27, 2014
816985 FIX: You cannot install SQL Server 2000 SP3 on the Korean version of SQL Server 2000 Q816985 KB816985 February 27, 2014
816883 FIX: SQL Server Optimizer May Underestimate the Cardinality of Range Queries Q816883 KB816883 February 27, 2014
816834 FIX: Osql.exe May Not Run Batches As Fast As Other ODBC-Based Applications Q816834 KB816834 February 27, 2014
816780 FIX: Merge Agent failures with articles that have indexed views defined Q816780 KB816780 February 27, 2014
816651 FIX: Use of the NON EMPTY Keyword on Sets with More Than 2 Billion Members Might Cause Analysis Server to Restart Q816651 KB816651 February 27, 2014
816503 FIX: Floating Point Exception (Error 3628) Might Occur for Queries That Need Merged Histograms Q816503 KB816503 February 27, 2014
816480 FIX: Cannot Use User-Defined Functions in Dimension Security Definitions Q816480 KB816480 February 27, 2014
816440 FIX: Error 8623 is Raised When SQL Server Compiles a Complex Query Q816440 KB816440 February 27, 2014
816084 FIX: sysindexes.statblob Column May Be Corrupted After You Run a DBCC DBREINDEX Statement Q816084 KB816084 February 27, 2014
816069 FIX: A Query with a Large IN Clause Can Cause Concurrency Issues Q816069 KB816069 February 27, 2014
816039 FIX: Code Point Comparison Semantics for SQL_Latin1_General_Cp850_BIN Collation Q816039 KB816039 February 27, 2014
815593 FIX: Incorrect Cardinality Estimates for NOT EXISTS Predicates After You Upgrade to SQL Server 2000 Service Pack 3 Q815593 KB815593 February 27, 2014
815592 FIX: Incorrect Remoting of a Predicate As a Sub-SELECT Function After SQL Server 2000 Service Pack 3 Upgrade Q815592 KB815592 February 27, 2014
815292 FIX: Writeback to Cell Fails If the Cube Contains a Virtual Dimension Q815292 KB815292 February 27, 2014
815291 FIX: A Delay Occurs During a Writeback Operation If You Do Not Have the Correct Permissions Q815291 KB815291 February 27, 2014
815217 FIX: Inserting Unicode data into SSCE causes SQL Server CE to stop responding or causes an exception error Q815217 KB815217 February 27, 2014
815199 FIX: Profiler Does Not Report CPU Column Value for RPC:Completed Events Correctly Q815199 KB815199 February 27, 2014
815115 FIX: A DTS package that uses global variables ignores an error message raised by RAISERROR Q815115 KB815115 February 27, 2014
815114 FIX: Excessive Optimizer Memory Consumption May Occur for Queries That Have Multiple OUTER JOINS Q815114 KB815114 February 27, 2014
815057 FIX: SQL Server 2000 Uninstall Option Does Not Remove All Files Q815057 KB815057 February 27, 2014
814956 FIX: The CREATE CUBE Command Fails If You Use the TYPE TIME Dimension Q814956 KB814956 February 27, 2014
814919 FIX: No Message Appears When a Blank Password is Set for a System Administrator Login in SQL Server Enterprise Manager Q814919 KB814919 February 27, 2014
814916 FIX: Merge Agent for a filtered publication might fail Q814916 KB814916 February 27, 2014
814894 FIX: The Xp_readmail Stored Procedure Only Saves the Text of an Embedded Attachment Q814894 KB814894 February 27, 2014
814893 FIX: Error Message: "Insufficient key column information for updating" Occurs in SQL Server 2000 SP3 Q814893 KB814893 February 27, 2014
814889 FIX: A DELETE statement with a JOIN might fail and you receive a 625 error Q814889 KB814889 February 27, 2014
814665 FIX: SQL Server Assertion: "nret == FALSE" Occurs When You Insert or Update Table Data in SQL Server 2000 Q814665 KB814665 February 27, 2014
814460 FIX: Merge Replication with Alternate Synchronization Partners May Not Succeed After You Change the Retention Period Q814460 KB814460 February 27, 2014
814414 FIX: Error message when parallel processing activity or a high degree of concurrent administrative activity occurs on SQL Server 2000 Analysis Services SP3: "Error: Attempting to connect to server" Q814414 KB814414 February 27, 2014
814406 FIX: Analysis Server Does Not Release Memory After an Incremental Update Q814406 KB814406 February 27, 2014
814252 FIX: "Error Reporting" Dialog Box Remains Open During Analysis Services 2000 Service Pack 3 Silent Installation Q814252 KB814252 February 27, 2014
814113 FIX: DTS Designer may generate an access violation after you install SQL Server 2000 Service Pack 3 Q814113 KB814113 February 27, 2014
814064 FIX: SQLBrowseConnect May Cause an Access Violation in the Client Application Q814064 KB814064 February 27, 2014
814035 FIX: A Full-Text Population Fails After You Apply SQL Server 2000 Service Pack 3 Q814035 KB814035 February 27, 2014
814032 FIX: Merge publications cannot synchronize on SQL Server 2000 Service Pack 3 Q814032 KB814032 February 27, 2014
813769 FIX: You May Experience Slow Performance When You Debug a SQL Server Service Q813769 KB813769 February 27, 2014
813759 FIX: A Large Number of NULL Values in Join Columns Result in Slow Query Performance Q813759 KB813759 February 27, 2014
813487 FIX: RealTime Cube Performance May Decrease When Update Activity Occurs on the Non-Source SQL Server Database Q813487 KB813487 February 27, 2014
813412 FIX: xp_readmail Returns NULL in the attachment Column If the Attachment's Type Is Message Format Q813412 KB813412 February 27, 2014
812995 FIX: A Query with an Aggregate Function May Fail with a 3628 Error Q812995 KB812995 February 27, 2014
812798 FIX: A UNION ALL View May Not Use Index If Partitions Are Removed at Compile Time Q812798 KB812798 February 27, 2014
812393 FIX: Update or Delete Statement Fails with Error 1203 During Row Lock Escalation Q812393 KB812393 February 27, 2014
812250 FIX: Indexed View May Cause a Handled Access Violation in CIndex::SetLevel1Names Q812250 KB812250 February 27, 2014
811703 FIX: Unexpected results from partial aggregations based on conversions Q811703 KB811703 February 27, 2014
811628 FIX: Many Temporary Tables Remain After Analysis Services Drills Down a ROLAP Cube in SQL Server Q811628 KB811628 February 27, 2014
811611 FIX: Reinitialized SQL Server CE 2.0 subscribers may experience data loss and non-convergence Q811611 KB811611 February 27, 2014
811467 FIX: A Unicode LIKE Predicate with Binary Collation May Return Incorrect Results Q811467 KB811467 February 27, 2014
811205 FIX: An error message occurs when you perform a database or a file SHRINK operation Q811205 KB811205 February 27, 2014
811052 FIX: Latch Time-Out Message 845 Occurs When You Perform a Database or File SHRINK Operation Q811052 KB811052 February 27, 2014
810688 FIX: Merge Agent Can Resend Changes for Filtered Publications Q810688 KB810688 February 27, 2014
810526 FIX: Cursors That Have a Long Lifetime May Cause Memory Fragmentation Q810526 KB810526 February 27, 2014
810435 FIX: Writeback on a Virtual Cube Does Not Always Work Q810435 KB810435 February 27, 2014
810430 FIX: WriteBack to an OLAP Cube Is Slow with Two or More Simultaneous Users Q810430 KB810430 February 27, 2014
810163 FIX: An Access Violation Occurs if an sp_cursoropen Call References a Parameter That Is Not Defined Q810163 KB810163 February 27, 2014
810140 FIX: A Cursor DECLARE Statement with a Binary Large Object (Text/Ntext/Image) Parameter May Cause an Access Violation Q810140 KB810140 February 27, 2014
810072 FIX: Merge Replication Reconciler Stack Overflow Q810072 KB810072 February 27, 2014
810052 FIX: A Memory Leak Occurs When Cursors Are Opened During a Connection Q810052 KB810052 February 27, 2014
810026 FIX: A DELETE Statement with a Self-Join May Fail and You Receive a 625 Error Q810026 KB810026 February 27, 2014
302892 FIX: Specifying More Than One Operator E-mail Address May Terminate SQL Server Agent with Dr. Watson Q302892 KB302892 November 3, 2013
932697 FIX: A calculated member that uses the DistinctCount function always returns 0 when you query a virtual cube that contains the calculated member after you install SQL Server 2000 Analysis Services Service Pack 4 Q932697 KB932697 November 2, 2013
926940 FIX: SQL Server 2000 Service Pack 4 stops responding after you close a SQL Server connection on a computer that is running Windows Server 2003 Service Pack 1 Q926940 KB926940 November 2, 2013
925745 FIX: The members of a role that uses dynamic security cannot access the SQL Server 2000 Analysis Services database when you run a query against a cube Q925745 KB925745 November 2, 2013
925000 FIX: An access violation may occur in SQL Server 2000 Analysis Services when you try to use a 2007 Office system program to open an offline local cube Q925000 KB925000 November 2, 2013
920121 FIX: Error message when you add a calculated member to a cube in SQL Server 2000 Analysis Services Service Pack 4: "Unable to update the calculated member" Q920121 KB920121 November 2, 2013
916097 FIX: You may not be able to use Analysis Manager to change server properties for an instance of SQL Server 2000 Analysis Services that is running on an IA-64 server computer after you install Windows Server 2003 SP1 on a client computer Q916097 KB916097 November 2, 2013
913049 FIX: The result set contains data for the whole relational source when you execute a query to retrieve a drillthrough result set in SQL Server 2000 Analysis Services Q913049 KB913049 November 2, 2013
912468 FIX: The connection that processes the cube stops responding, and the cube is locked in SQL Server 2000 Analysis Services Q912468 KB912468 November 2, 2013
911023 FIX: In SQL Server 2000 Analysis Services, a memory leak may occur in the handle thread when you run an MDX query that uses formulas or recursions Q911023 KB911023 November 2, 2013
910480 FIX: Real-time updates that are made on Relational Online Analytical Process partitions may not be reflected in the query results when you use SQL Server 2000 Analysis Services Q910480 KB910480 November 2, 2013
910020 FIX: Error message when you create an instance of SQL Server 2000 Notification Services together with a large event field: "Invalid operator for data type" Q910020 KB910020 November 2, 2013
903030 FIX: A Decision Support Objects (DSO) connection attempt fails after you install SQL Server 2000 Analysis Services Service Pack 4 Q903030 KB903030 November 2, 2013
899806 FIX: The MSSQLServerOLAPService service restarts unexpectedly when you use the ALTER CUBE statement in SQL Server 2000 Analysis Services Q899806 KB899806 November 2, 2013
899025 FIX: The SQL Server 2000 Analysis Services process may stop accepting connections and may appear to stop responding when you stop a SQL Server transaction after that transaction requests a lock Q899025 KB899025 November 2, 2013
899024 FIX: You may not be able to capture user dump files in SQL Server 2000 Analysis Services Q899024 KB899024 November 2, 2013
897350 FIX: The naming convention that the Partition Aggregation utility and the Partition Manager utility use could allow duplicate aggregations for partitions Q897350 KB897350 November 2, 2013
897123 FIX: A hidden report table may unexpectedly appear in an Office Excel worksheet when the table was exported from SQL Server 2000 Reporting Services Q897123 KB897123 November 2, 2013
894687 FIX: The Spanish versions of SQL Server 2000 Analysis Services hotfix packages do not install correctly Q894687 KB894687 November 2, 2013
891575 FIX: The MDX query is unsuccessful and you receive an error message if you query a ROLAP-based dimension in SQL Server 2000 Analysis Services Q891575 KB891575 November 2, 2013
887596 FIX: Memory usage increases when you process cubes in Analysis Services Q887596 KB887596 November 2, 2013
885444 FIX: PDF files that are exported by SQL Server 2000 Reporting Services can only be opened by using Adobe Acrobat Reader Q885444 KB885444 November 2, 2013
884844 FIX: You may receive an error message when you use the GetSchemaDataSet function to obtain cube metadata in Analysis Services Q884844 KB884844 November 2, 2013
883675 FIX: Invalid values appear in a chart if you change the default color for the value series in SQL Server 2000 Reporting Services Service Pack 1 Q883675 KB883675 November 2, 2013
883501 FIX: You receive a "Width of Excel cell in the Excel sheet exceeded the maximum limit of 1726.5 points" error message when you export a Reporting Services report to Excel Q883501 KB883501 November 2, 2013
883485 FIX: Incorrect Multidimensional Expressions (MDX) expressions are generated in the Custom Security Dimension dialog box if you choose the ragged dimension members that has hidden parent members Q883485 KB883485 November 2, 2013
875518 FIX: The width of a list that contains an embedded matrix grows unexpectedly when you export a report to PDF format Q875518 KB875518 November 2, 2013
873440 FIX: You may receive an error message when an invalid user tries to browse an Analysis Services cube that implements dynamic dimension security by defining a custom cube role Q873440 KB873440 November 2, 2013
843262 FIX: You may notice that the query performance on an Analysis Services cube degrades temporarily after an incremental update processes the virtual dimensions Q843262 KB843262 November 2, 2013
842859 FIX: Drillthrough operations on a cube fail if the dimension table has been assigned an alias Q842859 KB842859 November 2, 2013
841856 FIX: A memory leak occurs when you run queries in the same connection in Analysis Services Q841856 KB841856 November 2, 2013
837390 FIX: An exception occurs when you run a SQL Server CE RDA application that tries to connect to the SQL Server CE Server Agent by using an HTTPS connection Q837390 KB837390 November 2, 2013
834777 FIX: Some cubes are not processed by the process database operation Q834777 KB834777 November 2, 2013
831044 FIX: The OpenSchema Method Returns Null for the Custom Member Property of a Parent-Child Dimension Level Q831044 KB831044 November 2, 2013
822277 FIX: Analysis Services Service Quits During Processing and Does Not Restart Q822277 KB822277 November 2, 2013
821463 FIX: Pending Writeback May Cause Results That Are Not Accurate Q821463 KB821463 November 2, 2013
819609 FIX: The XML for Analysis Services provider result set does not contain the hierarchy name Q819609 KB819609 November 2, 2013
818765 FIX: Trace Flag -T8002 Treats Affinity Masks Like Process Affinities Q818765 KB818765 November 2, 2013
818764 FIX: Cannot Set SQL Server Instance Specific Network Affinity Q818764 KB818764 November 2, 2013
816652 FIX: XMLA Returns Malformed Response if Query Result Contains #ERR in Cells Q816652 KB816652 November 2, 2013
814851 FIX: SQL Server CE Application Fails on Pocket PC 2002 Emulator on Pentium IV Processor Q814851 KB814851 November 2, 2013
813645 FIX: Improved CPU Usage for Database Logging When Transaction Log Stalls Occur Q813645 KB813645 November 2, 2013
811478 FIX: Restoring a SQL Server 7.0 database backup in SQL Server 2000 Service Pack 2 (SP2) may cause an assertion error in the Xdes.cpp file Q811478 KB811478 November 2, 2013
810440 FIX: MDX Queries Return "#Err" as the Result Set When You Enable "Visual Totals" on Private Parent-Child Dimension Q810440 KB810440 November 2, 2013
810010 FIX: The fn_get_sql System Table Function May Cause Various Handled Access Violations Q810010 KB810010 November 2, 2013
329479 FIX: Cannot Set Description for Dimensions and Measures by Using the CREATE GLOBAL CUBE Statement Q329479 KB329479 November 2, 2013
326559 FIX: SSCE Replication Client Agent Stops Responding with Merge of Large Text or Image Q326559 KB326559 November 2, 2013
325289 FIX: New functionality for incremental update of changing dimensions Q325289 KB325289 November 2, 2013
324859 FIX: An Analysis Services Virtual Cube That Is Based on a Real-Time ROLAP Cube Does Not Receive Updates from the Source Q324859 KB324859 November 2, 2013
320730 FIX: You may receive an "Error Connecting OLAP Catalog: Database '<databaseName>' does not exist." error message when you try to connect to a cube by using a role that was created with DSO through an ASP page in SQL Server 2000 Analysis... Q320730 KB320730 November 2, 2013
320719 FIX: Analysis Services Client Application Memory Usage Grows Each Time You Run a Query Q320719 KB320719 November 2, 2013
319641 FILE: New Syntax Available to Create Local Cubes Q319641 KB319641 November 2, 2013
318596 FIX: Analysis Services HTTP Connections Return "Access Denied" Error Messages Q318596 KB318596 November 2, 2013
317710 FIX: CREATE INDEX Statement with Parallel Plan May Stop Responding If Disk Space Is Almost Full Q317710 KB317710 November 2, 2013
317562 FIX: The calculated member that uses the ValidMeasure function may return an incorrect value in a virtual cube Q317562 KB317562 November 2, 2013
317265 FIX: Real-Time Cube Unable to Re-Establish SQL Server Connection After Network Errors Occur Q317265 KB317265 November 2, 2013
317223 FIX: Performance Slows If You Process More Than Two Partitions In Parallel Q317223 KB317223 November 2, 2013
316335 FIX: Analysis Service Uses Large Amounts of Client Memory for Queries Q316335 KB316335 November 2, 2013
316285 FIX: Unexpected Internal Error Occurs When You Query a Virtual Cube with Calculated Measures Q316285 KB316285 November 2, 2013
315970 FIX: #ERR Occurs When You Browse a Cube That Is Write-Enabled and has a Virtual Dimension and an Oracle Data Source Q315970 KB315970 November 2, 2013
315889 FIX: Insertion of NULL Values into NTEXT Columns May Cause Application Instability Q315889 KB315889 November 2, 2013
315109 FIX: Join of Multiple Tables May Fail with E_OUTOFMEMORY Error Message Q315109 KB315109 November 2, 2013
313269 FIX: When you run an MDX query on a write-enabled cube, the query returns #Err, or the query fails and you receive an "Unable to open cellset..." error message in SQL Server 2000 Analysis Services Q313269 KB313269 November 2, 2013
310468 FIX: Error 3314 May Occur with Simultaneous DDL and DML Statements on SQL Server 2000 Service Pack 1 Q310468 KB310468 November 2, 2013
309400 FIX: Merge Replication Non-Convergence Fixes in SQL Server 2000 SP2 Q309400 KB309400 November 2, 2013
308878 FIX: sp_mergemetadataretentioncleanup Does Not Clean Generations with ArtNick=0 Q308878 KB308878 November 2, 2013
307932 FIX: SQL Mail Operations Are Not Thread Safe When You Use Them in Conjunction with the xp_stopmail Stored Procedure Q307932 KB307932 November 2, 2013
307530 FIX: SQL Server CE OLE DB Provider Specific Properties Give Compilation Error Q307530 KB307530 November 2, 2013
305349 FIX: SSCE:Temp File Directory Property Allows You to Change the Temp Database Location for SQL Server CE Q305349 KB305349 November 2, 2013
283844 FIX: DATEADD does not accept scientific notation for the NUMBER argument Q283844 KB283844 November 2, 2013
280082 FIX: SQL Server CE Queries with WHERE and ORDER BY Clauses May Run Slow Q280082 KB280082 November 2, 2013
275305 FIX: Directory Name \MSDE2000\RESOURCES Is More Than Eight Characters, Resulting in Non-ISO CD Q275305 KB275305 November 2, 2013
892589 FIX: System performance is decreased for user-mode applications on a 64-bit server that is running SQL Server 2000 Analysis Services Q892589 KB892589 October 26, 2013
891580 FIX: Analysis Manager or another third-party DSO application crashes when you try to use a cell action in SQL Server 2000 Analysis Services Q891580 KB891580 October 26, 2013
818763 FIX: Intense SQL Server Activity Results in Spinloop Wait in SQL Server 2000 Service Pack 2 Q818763 KB818763 October 26, 2013
818406 FIX: A Transact-SQL query that uses views may fail unexpectedly in SQL Server 2000 SP2 Q818406 KB818406 October 26, 2013
815197 FIX: An RDA PUSH of a DELETE Fails if the Primary Key Has a Datetime Column Q815197 KB815197 October 26, 2013
331925 FIX: Pre-Analysis Services Service Pack 3 Client Cannot Administer Analysis Services Service Pack 3 Q331925 KB331925 October 26, 2013
330058 FIX: Access Violation May Occur When You Use Impersonation and XMLA Connection Pooling Q330058 KB330058 October 26, 2013
329480 FIX: Property_Content_Type Is Set to 0 in Local Cube When You Use the CREATE GLOBAL CUBE Statement Q329480 KB329480 October 26, 2013
328878 FIX: Infinite Recursion Detected During Execution of Calculated Member Q328878 KB328878 October 26, 2013
328873 FIX: Query Performance Deteriorates After an Incremental Update to a Non-Changing Dimension Q328873 KB328873 October 26, 2013
327170 FIX: Archive of Analysis Services Database Fails with Overflow and CabArc.exe Failed Errors Q327170 KB327170 October 26, 2013
326827 FIX: Calculated Member Causes Formatting of All Measures to Match First Measure Q326827 KB326827 October 26, 2013
325199 FIX: Local Cube Creation Fails If Dimension Member Key and Member Names Are from Different Tables Q325199 KB325199 October 26, 2013
324978 FIX: A Drillthrough on a Virtual Cube Returns an Empty Set Q324978 KB324978 October 26, 2013
324905 FIX: OLAP Calculated Member That References Distinct Count Calculated Member Returns 0 Q324905 KB324905 October 26, 2013
320736 FIX: Writeback Fails with "Relational data provider reported error: []." Error Message Q320736 KB320736 October 26, 2013
314128 FIX: Access violation occurs when an RPC call is made that includes a bit parameter value that is not valid Q314128 KB314128 October 26, 2013
308856 FIX: SQL Server 2000 Desktop Engine SP1 Setup Fails with Error Message 1706 Q308856 KB308856 October 26, 2013
308836 FIX: Installation of Microsoft Desktop Engine (MSDE) Service Pack 1 over Later MSDE Service Pack Appears to Succeed Q308836 KB308836 October 26, 2013
308813 FIX: SQL Server 2000 SP1 Setup Resets Enable Shared Memory Protocol Option to the Default "On" Q308813 KB308813 October 26, 2013
308759 FIX: Invalid Use of the Getdate Function May Cause Access Violation Q308759 KB308759 October 26, 2013
308753 FIX: SQL Server 2000 SP1 Setup Fails on Execution of sp1_serv_uni.sql Script Q308753 KB308753 October 26, 2013
308733 FIX: Queue Reader Agent Fails with "Invalid Cursor State" Error Message Q308733 KB308733 October 26, 2013
306034 FIX: SQL Server 2000 SP1 installation on a cluster with the Sqlservr.exe file fails with an "Entry point not found" error message Q306034 KB306034 October 26, 2013
304072 FIX: Synchronization May Fail After You Use Large Text or Image Data Q304072 KB304072 October 26, 2013
303004 FIX: SQL Server CE Delete Query with a Subquery Over a Large Table Might Stop Responding (Hang) Q303004 KB303004 October 26, 2013
301627 FIX: Error Message: "ICE03 Invalid template string" Reported by MSIVal2 Q301627 KB301627 October 26, 2013
298822 FIX: MSDE Connection May Fail on a Multihomed Computer Q298822 KB298822 October 26, 2013
297232 FIX: Cannot Browse Cubes or Process Mining Model After You Install Analysis Services 2000 RTM Q297232 KB297232 October 26, 2013
296147 FIX: Errors in Application Center Event Viewer About Analysis Services Performance Counter Q296147 KB296147 October 26, 2013
295022 FIX: Sqlmaint.exe Is Not Available with MSDE 2000 Q295022 KB295022 October 26, 2013
294276 FIX: "Subscript Out of Range" Error Message in Usage Analysis Report Q294276 KB294276 October 26, 2013
293318 FIX: Analysis Services DTS Task Gets Timeout Error During Incremental Update Q293318 KB293318 October 26, 2013
275309 FIX: Uninstall, Repair, or Modify Fails on Program with Embedded SQL Server 2000 MSDE Merge Modules Q275309 KB275309 October 26, 2013
323039 FIX: Full-Text Search Population of a Word Document Stored in SQL Server Causes CPU Spin with SQL Server 2000 Service Pack 2 Q323039 KB323039 October 24, 2013
322911 FIX: Out of Memory or Significant Delay Occurs When You Expand a Cube or Edit a Dimension in Analysis Manager Q322911 KB322911 October 24, 2013
321271 FIX: Unicode Pattern Matching Returns Incorrect Results Q321271 KB321271 October 24, 2013
320723 FIX: Calculated Members, Actions, and Named Sets That Are Created from a Decision Support Objects Application Are Not Displayed Q320723 KB320723 October 24, 2013
320710 FIX: Error Message "Unable to open cellset. Cannot connect to server" Occurs When a Query is Sent to Analysis Services Q320710 KB320710 October 24, 2013
320407 FIX: SQLMail Extended Stored Procedures May Fail with an Access Violation on SQL Server 2000 SP2 when SQL Server is Run As a Windows NT Service Q320407 KB320407 October 24, 2013
318582 FIX: Data Mining Messages Are Displayed in English After You Apply Fix Q318582 KB318582 October 24, 2013
317486 FIX: A Query That Uses a Large Search String in the CONTAINS Clause May Fail with Error Message 7607 Q317486 KB317486 October 24, 2013
316295 FIX: MDX Queries from Query Analyzer to a Linked Analysis Server Result in Fatal Exception Q316295 KB316295 October 24, 2013
313313 FIX: SP1 Regression: A SELECT COUNT(*) From a View That Contains a UNION ALL May Be Significantly Slower or Fail Q313313 KB313313 October 24, 2013
313043 FIX: Creation of Local Cube Fails Q313043 KB313043 October 24, 2013
312410 FIX: Full Text RANK Results May Vary After Catalog Repopulation Q312410 KB312410 October 24, 2013
311880 FIX: MDSCHEMA_DIMENSIONS Returns Incorrect Value for DIMENSION_MASTER_UNIQUE_NAME Q311880 KB311880 October 24, 2013
311873 FIX: Analysis Manager Disappears When You Save a Role or Validate Security During Restore Q311873 KB311873 October 24, 2013
311313 FIX: ADO Returns No Resultset for Prepared Parameterized Query Involving CHAR Data with SQLOLEDB Q311313 KB311313 October 24, 2013
310935 FIX: Use of a Dynamic API Server Cursor with a NOLOCK Hint Causes Error 1047 Q310935 KB310935 October 24, 2013
310465 FIX: Table Without Index Does Not Appear in Taskpad View of Enterprise Manager Q310465 KB310465 October 24, 2013
309385 FIX: Incorrect Result Occurs with Unary Operator When You Execute Query on the Server Q309385 KB309385 October 24, 2013
309181 FIX: Incorrect Results Return When You Query a Virtual Cube Q309181 KB309181 October 24, 2013
308973 FIX: MDX Lag() Function Returns Incorrect Results Intermittently Q308973 KB308973 October 24, 2013
308972 FIX: Drill Down on a Dimension Causes Analysis Manager to Stop Responding (hang) Q308972 KB308972 October 24, 2013
308969 FIX: Writeback from OLAP 7.0 Client to Analysis Services Cube Results in Error Message Q308969 KB308969 October 24, 2013
308968 FIX: Incorrect Results Occur When You Use Currency Data Type with Very Large Value Q308968 KB308968 October 24, 2013
308966 FIX: Use of MDX Hierarchize Function Over a CrossJoin Set Fails with Internal Error Q308966 KB308966 October 24, 2013
308965 FIX: No Children Members Display in a Ragged Dimension with MDX Compatibility = 1 Q308965 KB308965 October 24, 2013
308963 FIX: Data Types for Some Columns in MINING_SERVICES Schema Rowset are not Compliant with the OLE DB Data Mining Specifications Q308963 KB308963 October 24, 2013
308962 FIX: ROLAP Storage on Oracle Does Not Create Indexes for Aggregation Tables Q308962 KB308962 October 24, 2013
308961 FIX: DTS Data Mining Task May Return Syntax Error for Correct Prediction Query Q308961 KB308961 October 24, 2013
308960 FIX: Copy and Paste of ROLAP Partition May Overwrite Aggregation Tables Q308960 KB308960 October 24, 2013
308959 FIX: UPDATE CUBE Statement Allocates Data Incorrectly Q308959 KB308959 October 24, 2013
308956 FIX: A Full Process Fails When a Very Large Dimension Slices a Partition Q308956 KB308956 October 24, 2013
308955 FIX: Incorrect Results Occur with Write Back of Different Data Types Q308955 KB308955 October 24, 2013
308931 FIX: Unicode Server Message Changes to "????" on Message Text When the Text is Saved by SEM Q308931 KB308931 October 24, 2013
308830 FIX: SQL Server Agent Reports "Succeeded" when Scheduled DTS Package Task Fails Q308830 KB308830 October 24, 2013
308824 FIX: ODBC Dialog Boxes Appear in English on Localized Versions of Microsoft Windows NT 4.0 After You Apply MSDE 2.0 Service Pack 1 Q308824 KB308824 October 24, 2013
308820 FIX: Misconfiguration of Affinity Values May Cause SQL Server to Not Start Q308820 KB308820 October 24, 2013
308818 FIX: SP1 Regression: SELECT Query on a Table with a Computed Column Generates Access Violation Q308818 KB308818 October 24, 2013
308816 FIX: Service Control Manager Shows Incorrect Status on SQL Server 2000 Desktop Engine Q308816 KB308816 October 24, 2013
308807 FIX: SP1 Regression: Bulk Load of a Table with a Text Column Causes AV on the Server Q308807 KB308807 October 24, 2013
308782 FIX: Use of PRINT on Invalid User Defined Function Causes Access Violation Q308782 KB308782 October 24, 2013
308458 FIX: Combination of GROUP BY with HAVING Clause and LEFT OUTER JOIN with Derived Table Produces Incorrect Result Q308458 KB308458 October 24, 2013
308452 FIX: SP1 Regression: Table Does Not Display in Taskpad View If the Table Name Contains a Special Character Q308452 KB308452 October 24, 2013
308212 FIX: Connection Failure Errors Occur After Upgrade to MSDE 2.0 Q308212 KB308212 October 24, 2013
307837 FIX: French Installation of Desktop Engine Fails with Microsoft Installer Q307837 KB307837 October 24, 2013
307655 FIX: Querying Syslockinfo with Large Numbers of Locks May Cause Server to Stop Responding Q307655 KB307655 October 24, 2013
306491 FIX: "Unable To Run The Script Files" Error Message Occurs with Desktop Engine Modification Q306491 KB306491 October 24, 2013
306488 FIX: Reinstall with Long Command May Cause Setup to Fail Q306488 KB306488 October 24, 2013
306467 FIX: Changes to Filtered Indexed View Can Cause Unexpected Results Q306467 KB306467 October 24, 2013
306374 FIX: SP1 Regression: Table Scan Chosen Over Index Seek for INSERT/SELECT Statement Against the Same Table Q306374 KB306374 October 24, 2013
306341 FIX: MDX: TopCount Function Returns "Unable to open cellset Connection to the server is lost" Error Message Q306341 KB306341 October 24, 2013
306167 FIX: MSDE SP1 Upgrade Does Not Update Merge Replication Components Q306167 KB306167 October 24, 2013
305576 FIX: Regression: AV When xp_findnextmsg Is Invoked Against an Empty Inbox Q305576 KB305576 October 24, 2013
305354 FIX: Paging an Operator May Not Work After You Apply Service Pack 1 Q305354 KB305354 October 24, 2013
303897 FIX: Cubes Unavailable During Incremental Update Q303897 KB303897 October 24, 2013
303664 FIX: SP_PROCESSMAIL May Fail with Error 18023 Q303664 KB303664 October 24, 2013
303115 FIX: ITypeInfo Interface Leak Occurs When You Use SQL Server OLE Automation Stored Procedures Q303115 KB303115 October 24, 2013
303005 FIX: SQL Server Performance Condition Alerts do not Fire After You Install SQL Server 2000 Service Pack 1 Q303005 KB303005 October 24, 2013
301472 FIX: Assertion Occurs When You Use VT_UI4 Integer for SERVICE_TYPE_ID with the OpenSchema Method Q301472 KB301472 October 24, 2013
300919 FIX: SQL Server 2000 Service Pack 1 Setup May Fail when Applied to a Server with Non-writable Databases Q300919 KB300919 October 24, 2013
299616 FIX: Error Training Mining Model That Has Many Input Attributes and Many Rows of Data Q299616 KB299616 October 23, 2013
299383 FIX: Incorrect Results Returned from MDX Query When Default Member Is Defined by User Q299383 KB299383 October 23, 2013
299005 FIX: Analysis Server shuts down when updating virtual dimension after structure changes Q299005 KB299005 October 23, 2013
298711 FIX: Unable to Browse Data Mining Model that has the Same Name as a Cube Q298711 KB298711 October 23, 2013
298701 FIX: Error When Regional Setting Is Different Than Operating System Language Q298701 KB298701 October 23, 2013
298700 FIX: Syntax Error Occurs When You Use EQUAL_AREAS or THRESHOLDS Keyword for DISCRETIZED Method Q298700 KB298700 October 23, 2013
298688 FIX: "Members With Data" Property Produces Wrong Result with Unary Operators in Parent-Child Dimension Q298688 KB298688 October 23, 2013
298681 FIX: Drillthrough Query on a Virtual Cube Shows Incorrect Results or Error Q298681 KB298681 October 23, 2013
298679 FIX: NonEmptyCrossJoin Queries Cannot Run Remotely on the Server Q298679 KB298679 October 23, 2013
298600 FIX: Partition Stops Inheriting FromClause Property from Parent Cube Q298600 KB298600 October 23, 2013
298595 FIX: Order and Format of Dimension Members Not Maintained After Processing Q298595 KB298595 October 23, 2013
298594 FIX: Cubes with a Remote Partition and Parent-Child Dimension Display #ERR Q298594 KB298594 October 23, 2013
298485 FIX: Incremental Update of Cube with Distinct Measure Causes Analysis Server to Shut Down Q298485 KB298485 October 23, 2013
298443 FIX: Analysis Services Always Uses Visual Totals for Restricted Dimensions Q298443 KB298443 October 23, 2013
297933 FIX: Full Process of a Remote Partition Unprocesses Other Remote Partitions in Same Server Q297933 KB297933 October 23, 2013
297823 FIX: Incorrect Data Displays in PivotTable When it is Filtered and AutoCalc is Set to Max or Min Q297823 KB297823 October 23, 2013
297338 FIX: Division by Zero Produces Zero as a Result for a Calculated Member Q297338 KB297338 October 23, 2013
297248 FIX: Server Shutdown When Processing a Cube with Private, Virtual, and Shared Dimensions Q297248 KB297248 October 23, 2013
297205 FIX: A remote Cut and Paste of a SQL Server 7.0 cube or dimension in Analysis Manager causes an error Q297205 KB297205 October 23, 2013
297179 FIX: OLAP Service Fails to Start After Changing Sort Order to Binary on Japanese Windows Q297179 KB297179 October 23, 2013
296929 FIX: Creation of Ad Hoc Data Mining Models Fails with Mining Execution Location=3 Q296929 KB296929 October 23, 2013
296915 FIX: Access Violation When Processing a Database That Was Restored Over Existing Database Q296915 KB296915 October 23, 2013
296905 FIX: Data Mining Provider Stops Responding When Using Row Navigation through OLE DB API Q296905 KB296905 October 23, 2013
296901 FIX: Cube Editor Stops Responding on Save After Adding Private Dimension Q296901 KB296901 October 23, 2013
296774 FIX: DTS Logs Processing Messages Even When Package Logging Is Turned Off Q296774 KB296774 October 23, 2013
296762 FIX: DSO Allows Cube Role or Data Mining Role to Be Added Without a Corresponding Database Role Q296762 KB296762 October 23, 2013
296652 FIX: Dimension Editor Displays Error Message While Setting Default Member Q296652 KB296652 October 23, 2013
296639 FIX: Analysis Services Fails When All Shared Dimensions Are Processed Q296639 KB296639 October 23, 2013
296496 FIX: Replace of Fact Table Does Not Display Correct Fact Table Name in Cube Editor Q296496 KB296496 October 23, 2013
296420 FIX: Incremental Update of Cube Results in Empty Cube if Partition Was Previously Empty Q296420 KB296420 October 23, 2013
296419 FIX: Cannot Set Parent for Calculated Member to Member of Parent-Child Dimension Q296419 KB296419 October 23, 2013
296381 FIX: Creating a Local Cube with a Large Number of Measures May Cause Error on the Client Q296381 KB296381 October 23, 2013
296380 FIX: IS_DRILLTHROUGH_ENABLED in MDSCHEMA_CUBES Resultset Invalid for Copied Objects Q296380 KB296380 October 23, 2013
296378 FIX: Query Using NON EMPTY Clause Fails for Measures with a Large Cellset Q296378 KB296378 October 23, 2013
296267 FIX: Analysis Services Cubes Using Unisys DMS II Database Report ODBC Error Q296267 KB296267 October 23, 2013
296098 FIX: xp_sendmail Fails with the @attach_results Parameter on SQL Server 2000 Personal Edition Q296098 KB296098 October 23, 2013
296064 FIX: Analysis Services Cubes Restored From Archive May Show #ERR When Browsed Q296064 KB296064 October 23, 2013
295985 FIX: Creating a Local Cube from a Linked Cube May Return Error Q295985 KB295985 October 23, 2013
295737 FIX: Analysis Manager Reports Error: Cannot Create Temp Directory Due to Disk Space Problems Q295737 KB295737 October 23, 2013
295706 FIX: Virtual Cube Returns Empty Cells if Custom Rule Is Applied Q295706 KB295706 October 23, 2013
295683 FIX: Virtual Cube Returns #ERR if You Use Dimension Security and Visual Total Together Q295683 KB295683 October 23, 2013
295634 FIX: Server Fails with Query to Cube with Multiple Partitions and Distinct Count Measure Q295634 KB295634 October 23, 2013
295537 FIX: Unable to Save Changes to Analysis Services Named Sets Q295537 KB295537 October 23, 2013
295463 FIX: Cube Editor Reports Named Set Name Not Valid but Named Set Displays Correctly Q295463 KB295463 October 23, 2013
295446 FIX: MSOLAP 8.0 Provider Returns Invalid Property Values for Non-Leaf Members Q295446 KB295446 October 23, 2013
295442 FIX: Processing OLAP 7.0 Objects from Analysis Services DTS Task Fails Q295442 KB295442 October 23, 2013
294993 FIX: Combination of Order and CrossJoin Functions in MDX Causes Error Q294993 KB294993 October 23, 2013
294968 FIX: Error Processing Partitions in Parallel Through DTS May Cause Processing to Fail Q294968 KB294968 October 23, 2013
294929 FIX: MSDE Installation Contains the Wrong Icon for the Service Manager Q294929 KB294929 October 23, 2013
294746 FIX: Error Occurs When Changes are Made to Dimension Security for Very Large Dimensions Q294746 KB294746 October 23, 2013
294734 FIX: Invalid Data Displays after Refreshing the Definition of a Cube That Contains Virtual Dimensions Q294734 KB294734 October 23, 2013
294703 FIX: Incorrect Data in Local Cube Using Custom Rollup with Parent Child Dimension and UNARY Operator Q294703 KB294703 October 23, 2013
294664 FIX: Timeout Error While Browsing Data from Analysis Manager Q294664 KB294664 October 23, 2013
294535 FIX: Real-Time Cubes Fail to Process with a Measure Defined as Distinct Count Q294535 KB294535 October 23, 2013
294371 FIX: Cubes and Dimensions Not Visible After Upgrading From OLAP Services 7.0 to Analysis Services 8.0 Q294371 KB294371 October 23, 2013
294285 FIX: Processing All Dimensions May Fail with Very Large Dimensions Q294285 KB294285 October 23, 2013
293776 FIX: Cube Remains in Repository Database After Restore of Archived Database Without Cube Q293776 KB293776 October 23, 2013
293616 FIX: How to Migrate Repository from Meta Data Format to SQL Server Database Format Q293616 KB293616 October 23, 2013
293612 FIX: Remote Partitions Require Remote Servers to Run Under OLAP Administrators Account Q293612 KB293612 October 23, 2013
293609 FIX: Drill-Through Returns Incorrect Data When Dimension Tables Are Aliased in Dimension Editor Q293609 KB293609 October 23, 2013
293528 FIX: Drill-Through Fails if Dimension Table Has an Alias in the Cube Q293528 KB293528 October 23, 2013
293516 FIX: Processing of Remote Partition Fails When Dimension and Fact Table Are in Different Data Sources Q293516 KB293516 October 23, 2013
293463 FIX: ASP Error 0115 Occurs When Connecting Through HTTP to Analysis Server on Windows NT 4.0 Q293463 KB293463 October 23, 2013
293195 FIX: Use of the Colon Operator to Define a Range of Members May Cause Incorrect Results in MDX Query Q293195 KB293195 October 23, 2013
292616 FIX: ISQLWCE for PocketPC SH3 Has Incorrect MFC and OLE DLLs Q292616 KB292616 October 23, 2013
291563 FIX: Analysis Server HTTPS Connections Slower Than HTTP and TCP/IP Connections Q291563 KB291563 October 23, 2013
291374 FIX: Creation of Local Cube with More Than 202 Measures May Fail Q291374 KB291374 October 23, 2013
291364 FIX: Query Performance Slower When Client Locale Differs from Server Locale Q291364 KB291364 October 23, 2013
290562 FIX: HTTP Connection Resets Session ID of an ASP Session Object Q290562 KB290562 October 23, 2013
289804 FIX: Dimension Wizard Generates Unusable Custom Rollup Formula with Private Parent-Child Dimension Q289804 KB289804 October 23, 2013
286357 FIX: SQL Server CE Refresh Fixes GUID Generation Problems Q286357 KB286357 October 23, 2013
278239 FIX: Extreme Memory Usage When Adding Many Security Roles Q278239 KB278239 October 21, 2013
260817 Frequently Asked Questions - SQL Server 2000 - Programming Q260817 KB260817 October 20, 2013
311231 Frequently asked questions - SQL Server - SQL Mail Q311231 KB311231 September 12, 2013
260512 Frequently asked questions - SQL Server 2000 - Tools Q260512 KB260512 November 29, 2012
260758 Frequently asked questions - SQL Server 2000 - failover clustering Q260758 KB260758 October 18, 2012
920930 FIX: Error message when you try to run a query on a linked server in SQL Server 2000 Q920930 KB920930 October 9, 2011
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 October 9, 2011
913265 FIX: Error message when you open the Excel workbook after you export a report in SQL Server 2000 Reporting Services: "Name cannot be the same as built in name" Q913265 KB913265 October 9, 2011
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 October 9, 2011
909369 FIX: Automatic checkpoints on some SQL Server 2000 databases do not run as expected Q909369 KB909369 October 9, 2011
899431 FIX: An access violation occurs in the Mssdi98.dll file, and SQL Server crashes when you use SQL Query Analyzer to debug a stored procedure in SQL Server 2000 Service Pack 4 Q899431 KB899431 October 9, 2011
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 October 9, 2011
898709 FIX: Error message when you use SQL Server 2000: "Time out occurred while waiting for buffer latch type 3" Q898709 KB898709 October 9, 2011
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 October 9, 2011
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 October 9, 2011
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 October 9, 2011
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 October 9, 2011
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 October 9, 2011
887700 FIX: Server Network Utility may display incorrect protocol properties in SQL Server 2000 Q887700 KB887700 October 9, 2011
885922 FIX: Hebrew characters appear in reverse order when you use parameter lists to create a report that contains text with Hebrew characters in SQL Server 2000 Reporting Services Q885922 KB885922 October 9, 2011
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 October 9, 2011
841175 FIX: You may receive an exception access violation for the Ssnetlib.dll file in SQL Server 2000 Q841175 KB841175 October 9, 2011
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 October 9, 2011
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 October 9, 2011
960862 FIX: The Internet Explorer process crashes when you print or preview a report by using the RSClientPrint control that is included in SQL Server 2000 Reporting Services in two separate browsers Q960862 KB960862 October 8, 2011
945274 FIX: You receive incorrect data from SQL Server 2000 Analysis Services after you use the Page Heap tool (Pageheap.exe) to troubleshoot heap corruption issues Q945274 KB945274 October 8, 2011
944985 FIX: The data on the publisher does not match the data on the subscriber when you synchronize a SQL Server 2005 Mobile Edition subscriber with a SQL Server 2000 "merge replication" publisher Q944985 KB944985 October 8, 2011
944486 FIX: You cannot open an Excel workbook that is exported from SQL Server 2000 Reporting Services on a Macintosh computer Q944486 KB944486 October 8, 2011
943001 FIX: A handle leak issue occurs when you connect to an instance of Analysis Services that uses dynamic security Q943001 KB943001 October 8, 2011
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 October 8, 2011
936232 FIX: An access violation may occur when you try to log in to an instance of SQL Server 2000 Q936232 KB936232 October 8, 2011
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 October 8, 2011
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 October 8, 2011
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 October 8, 2011
934396 FIX: Error messages and an event may be logged when you use the Virtual Device Interface in SQL Server 2005 or in SQL Server 2000 Q934396 KB934396 October 8, 2011
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 October 8, 2011
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 October 8, 2011
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 October 8, 2011
930484 FIX: CPU utilization may approach 100 percent on a computer that is running SQL Server 2000 every 49.7 days Q930484 KB930484 October 8, 2011
928568 FIX: SQL Server 2000 stops responding when you cancel a query or when a query time-out occurs, and error messages are logged in the SQL Server error log file Q928568 KB928568 October 8, 2011
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 October 8, 2011
927186 FIX: Error message when you create a merge replication for tables that have computed columns or columns of the timestamp data type in SQL Server 2000 Service Pack 4: "The process could not log conflict information" Q927186 KB927186 October 8, 2011
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 October 8, 2011
925419 FIX: The server stops responding, the performance is slow, and a time-out occurs in SQL Server 2000 Q925419 KB925419 October 8, 2011
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 October 8, 2011
978546 FIX: Error message when you perform interactive operations on an SSRS 2000 report after you have installed security update 970899 Q978546 KB978546 October 7, 2011
982899 Forms Based Authentication in Reporting Service Q982899 KB982899 October 5, 2011
971524 FIX: An access violation occurs when you run a DELETE statement or an UPDATE statement in the Itanium-based versions of SQL Server 2000 after you install security update MS09-004 Q971524 KB971524 December 27, 2010
956138 FIX: You cannot upgrade a non-English instance of SQL Server 2000 Reporting Services to SQL Server 2008 Reporting Services Q956138 KB956138 March 19, 2009
304850 FIX: SQL Server Text Formatting Functions Contain Unchecked Buffers Q304850 KB304850 December 23, 2008
951728 FIX: Internet Explorer crashes when you try to print or preview a report that you view by using SQL Server Reporting Services Q951728 KB951728 May 15, 2008
319173 FIX: Cardinality estimates are too low when value is outside histogram Q319173 KB319173 May 5, 2008
833406 FIX: Cardinality estimates for literals that are outside the histogram range are very low Q833406 KB833406 May 2, 2008
811188 FIX: The merge replication agent stops responding when you perform merge replication between a SQL Server database and a SQL Server CE database, a SQL Server 2005 Compact Edition database, or a SQL Server 2005 Mobile Edition database Q811188 KB811188 March 27, 2008
946584 FIX: The SPACE function always returns one space in SQL Server 2000 if the SPACE function uses a collation that differs from the collation of the current database Q946584 KB946584 March 12, 2008
318530 FIX: Reorder outer joins with filter criteria before non-selective joins and outer joins Q318530 KB318530 February 4, 2008
884854 FIX: You receive the “Could not find stored procedure” error message when you perform transactional replication with queued updating in SQL Server 2000 Q884854 KB884854 January 15, 2008
309450 FIX: Inconsistent Results Reported by TOP N Using Full-Text CONTAINSTABLE Q309450 KB309450 November 30, 2007
279113 FILE: Use Xpvmlog to Dump the Layout of Virtual Memory in SQL Server Q279113 KB279113 November 30, 2007
820788 FIX: Delayed domain authentication may cause SQL Server to stop responding Q820788 KB820788 November 27, 2007
329526 File allocation extension in SQL Server 2000 (64-bit) and SQL Server 2005 Q329526 KB329526 November 20, 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
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
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
831801 FIX: SQLStatistics function returns incorrect sort order sequence Q831801 KB831801 November 5, 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
280294 FIX: SQL Server ODBC Driver reuses incorrect parameter length Q280294 KB280294 November 2, 2007
277626 FIX: Distributed partitioned view by using UNION may not use optimal plan Q277626 KB277626 November 2, 2007
323875 FIX: MS02-039: Buffer Overruns in SQL Server 2000 Resolution Service Might Enable Code Execution Q323875 KB323875 October 29, 2007
319507 FIX: SQL Extended Procedure Functions Contain Unchecked Buffers Q319507 KB319507 October 29, 2007
300676 FIX: The Setup program may fail when you try to upgrade to SQL Server 2000 and Setup runs the Messages.sql script Q300676 KB300676 October 26, 2007
297105 FIX: Potential English Query Security Issue Q297105 KB297105 October 26, 2007
939317 FIX: The CPU utilization may suddenly increase to 100 percent when there are many connections to an instance of SQL Server 2000 on a computer that has multiple processors Q939317 KB939317 October 9, 2007
872934 FIX: An Analysis Services server appears to stop responding when a complex query that takes a long time to complete is run against a SQL Server 2000 Analysis Services server Q872934 KB872934 September 7, 2007
330307 FIX: Cross Database Query Fails with Error 3624 and an Assertion Occurs in the Dbtable.cpp File Q330307 KB330307 September 5, 2007
303822 FIX: Properties Dialog Box of a Transform Data Task Takes a Long Time to Open Q303822 KB303822 September 5, 2007
280380 FIX: Buffer Overflow Exploit Possible with Extended Stored Procedures Q280380 KB280380 September 5, 2007
285100 FIX: A SQL Server installation fails when Windows computer name is mixed or lowercase Q285100 KB285100 August 13, 2007
272074 FIX: T-SQL Debugger Parses SQL Server 2000 Return Value Incorrectly Q272074 KB272074 August 7, 2007
929131 FIX: In SQL Server 2000, the synchronization process is slow, and the CPU usage is high on the computer that is configured as the Distributor Q929131 KB929131 June 19, 2007
902150 FIX: Some 32-bit applications that use SQL-DMO and SQL-VDI APIs may stop working after you install SQL Server 2000 Service Pack 4 on an Itanium-based computer Q902150 KB902150 June 19, 2007
315758 FIX: Merge Non-Convergence for SQL Server CE Subscriber Q315758 KB315758 June 18, 2007
312990 FIX: Rebuildm and Setup Do Not Expose All the SQL Collations Q312990 KB312990 June 12, 2007
290414 FIX: Index Tuning Wizard Fails to Remove Hypothetical Clustered Indexes Q290414 KB290414 April 23, 2007
827837 FIX: SQL Server CE connection causes an out-of-memory condition when you create many SqlCeDataReader objects Q827837 KB827837 April 19, 2007
842512 FIX: The Page break at start check box and the Page break at end check box may not appear in Report Designer Q842512 KB842512 April 3, 2007
883576 FIX: You receive incorrect results when you use strings that have more than two characters to define a range, and then you access data in a SQL Server CE OLE DB application Q883576 KB883576 March 23, 2007
823896 FIX: An error may occur when you try to use the JDBC driver to insert binary large object data into a SQL Server 2000 table Q823896 KB823896 March 19, 2007
311836 FIX: SQL Server Driver Fails to Connect over TCP/IP Using Three Parameters in Address Keyword Q311836 KB311836 February 23, 2007
306266 FIX: Updates to Distributed Partitioned Views May Return Incorrect @@ROWCOUNT Value Q306266 KB306266 February 23, 2007
291566 FIX: Parallel Plan for Index Creation of Non-Clustered Index May Result in Use of Pages That are not Allocated Q291566 KB291566 February 23, 2007
276426 FIX: Msxml2.dll Fails to Register on 32-Processor Computer During MDAC 2.6 Installation Q276426 KB276426 February 23, 2007
818504 FIX: JDBC Driver Overwrites Timestamp Parameter Values with the Last Value Set Q818504 KB818504 February 22, 2007
817326 FIX: JDBC Driver May Cause Application to Stop Responding During Multiple Transactions Q817326 KB817326 February 22, 2007
328876 FIX: Analysis Services Cannot Start and You Receive This Error Message: "MSSQLServerOLAPService service terminated unexpectedly" Q328876 KB328876 February 22, 2007
325338 FIX: OLE DB Provider for SQL Server Does Not Cancel a Batch Statement When You Call the Cancel() Method Q325338 KB325338 February 22, 2007
324900 FIX: Recordset.Update Causes Error Message: "Cursor operation conflict" to Occur When You Use Server Side Cursors and an INSTEAD OF Trigger Q324900 KB324900 February 22, 2007
321255 FIX: ODBC Driver for SQL Server 2000 Incorrectly Returns SQL_SUCCESS on SQLDescribeParam() Q321255 KB321255 February 22, 2007
313352 FIX: "Numeric Value Out Of Range" Error Message When You Execute Batch SQL Statements Q313352 KB313352 February 22, 2007
303228 FIX: Queue Reader Agent Fails if the Distributor is a Clustered SQL Server Q303228 KB303228 February 22, 2007
300497 FIX: Log Shipping: Cannot Change Role From Secondary to Primary When Database Names Are Different Q300497 KB300497 February 22, 2007
300217 FIX: "Update Index in Background" Option in Change Tracking May Not Work if Very Low Disk Space Detected Q300217 KB300217 February 22, 2007
299937 FIX: Changes to Indexed View Article of a Transactional Publication Are Not Saved Q299937 KB299937 February 22, 2007
299903 FIX: sp_scriptpublicationcustomprocs Generates Replication Stored Procedures Q299903 KB299903 February 22, 2007
299889 FIX: Full Population May Not Complete if Microsoft Search Service Is Stopped and Restarted Q299889 KB299889 February 22, 2007
299362 FIX: Failover of a SQL Virtual Server Causes Problems with Active Directory Integration Q299362 KB299362 February 22, 2007
299287 FIX: The Number of Parameters Does Not Match Error Message From Distribution Task Q299287 KB299287 February 22, 2007
296685 FIX: Cannot Execute SELECT COUNT(*) Against DB2 on Mainframe Using Four-Part Name Q296685 KB296685 February 22, 2007
295936 FIX: Error Removing Log Shipping on Secondary Database When Database Name Has a Quote Q295936 KB295936 February 22, 2007
294999 FIX: SQL Server Fails to Start with \f Option on Computers with Many CPUs Q294999 KB294999 February 22, 2007
291160 FIX: Books Online Incorrect About Default Value of @terminate for SP_CHANGE_PRIMARY_ROLE Q291160 KB291160 February 22, 2007
290644 FIX: DTSRun.exe Causes Access Violation on SMP Computers Q290644 KB290644 February 22, 2007
290351 FIX: SQL Server Assertion During Distributed Transaction Q290351 KB290351 February 22, 2007
288189 FIX: DTS FTP Task May Fail to Download Files After a Network Problem Q288189 KB288189 February 22, 2007
286775 FIX: Creating a Publication From Within DTSWIZ Fails with "Error 496: General Error" Error Message Q286775 KB286775 February 22, 2007
279295 FIX: Parallel Index Creation on Large SMP Hardware Can Cause Handled Access Violation Q279295 KB279295 February 22, 2007
279123 FIX: SQL Server 2000 Uninstallation May Break SQL Server CE Replication Q279123 KB279123 February 22, 2007
823429 FIX: You receive error message 7410 when you use a distributed query as a query parameter for the xp_sendmail stored procedure or the sp_makewebtask stored procedure in SQL Server 2000 Q823429 KB823429 February 21, 2007
819248 FIX: An access violation exception may occur when you insert a row in a table that is referenced by indexed views in SQL Server 2000 Q819248 KB819248 February 21, 2007
817419 FIX: String Output Parameters Truncated to 4000 Characters with JDBC Q817419 KB817419 February 21, 2007
815056 FIX: You receive an "Error: 17883" error message when the checkpoint process delays the SQL Server database activity and does not yield the scheduler correctly Q815056 KB815056 February 21, 2007
327935 FIX: Error Message: "The specified index already exists" May Occur When Re-initializing Subscription with SQL Server CE Edition Q327935 KB327935 February 21, 2007
326362 Fix: UDL Dialog for SQL Server OLE DB Provider Generates Empty Server List Q326362 KB326362 February 21, 2007
318375 FIX: SQL Server ODBC Driver Calls iswctype Excessively Causing Slower Performance Q318375 KB318375 February 21, 2007
312876 FILE: Ptssetup.exe Sample Automatically Downloads and Installs OLAP Client Q312876 KB312876 February 21, 2007
297728 FIX: Unhandled Exception Error Querying with the Data Mining Provider from ADO+ and C# Q297728 KB297728 February 21, 2007
281117 FIX: Timeout Error Occurs with Large Dimensions in Dimension Editor or Wizard Q281117 KB281117 February 21, 2007
317161 FIX: .NET MDX Queries Fail When You Use the OleDbDataAdapter or OleDbDataReader Classes Q317161 KB317161 February 20, 2007
309093 FIX: Buffer Latch Timeouts or Server Sluggishness Occurs When You Remove Procedures From Cache Q309093 KB309093 February 20, 2007
305137 FIX: Error "Unable to retrieve children: Member with the UniqueName not found" Q305137 KB305137 February 20, 2007
296186 FIX: Incorrect Results In Cube Editor When You Edit a Dependent Calculated Member or Calculated Cell Q296186 KB296186 February 20, 2007
321719 FIX: Zeros Returned Incorrectly from OLAP Data Source with Calculated Measures Q321719 KB321719 February 19, 2007
892517 FIX: A drillthrough operation fails, and you may receive an "Unable to drill through" error message after you configure drillthrough permissions on a virtual cube in SQL Server 2000 Analysis Services Q892517 KB892517 February 14, 2007
889521 FIX: Synchronization of a merge publication that uses the "Subscriber Always Wins Conflict Resolver" conflict resolver is unsuccessful in SQL Server 2000 Windows CE Edition 2.0 Q889521 KB889521 February 14, 2007
885435 FIX: The DSO Process(ProcessSuspendLazyProcessing) method does not suspend the lazy processing of aggregations on a remote partition in SQL Server 2000 Analysis Services Q885435 KB885435 February 14, 2007
872935 FIX: A lazy aggregation operation on one or more partitions may fail and you may notice an "Error during lazy aggregation of partition <Partition name> in cube <Cube name>" error message in the application event log Q872935 KB872935 February 13, 2007
836136 FIX: The compile time for a query that uses at least one outer join may be greater for SQL Server post-SP3 builds Q836136 KB836136 February 12, 2007
306452 FIX: SQL Server CE eMbedded Visual Basic CompactDatabase Unable to Fix Corrupted Database Q306452 KB306452 February 12, 2007
305385 Frequently asked questions about the Microsoft Network Security Hotfix Checker (HFNetChk) functionality that is integrated into the Microsoft Baseline Security Analyzer (MBSA) Q305385 KB305385 January 31, 2007
891085 FIX: You receive an error message when you try to install SQL Server 2000 Service Pack 4 Q891085 KB891085 January 16, 2007
883647 FIX: When you render a report to a PDF file, the page breaks are incorrect in SQL Server 2000 Reporting Services Q883647 KB883647 December 28, 2006
298923 FIX: sp_MsHelpmergeconflictcounts Returns No Row Against the Chinese Name Table on English Windows 2000 Q298923 KB298923 December 12, 2006
896174 FIX: Error message when you modify the security of a custom dimension in SQL Server 2000 Analysis Services: "Dimension Security Syntax Error: Set name 48818.79 is not valid" Q896174 KB896174 November 21, 2006
893091 FIX: You receive a "Connection timed out or lost" error message or a "COMException" error message when you use ADOMD.NET to connect to a remote OLAP server in SQL Server 2000 Analysis Services Q893091 KB893091 November 21, 2006
892139 FIX: An out-of-memory condition occurs when you run a query against a cube that contains calculated cells in SQL Server 2000 Analysis Services Q892139 KB892139 November 21, 2006
890665 FIX: The Analysis Services service may unexpectedly stop and then restart on a server that is hosting a remote partition of a cube and that is running SQL Server 2000 Q890665 KB890665 November 21, 2006
888504 FIX: A process operation on a cube may stop responding if the cube contains a ROLAP partition that is enabled for real-time updates in Analysis Services Q888504 KB888504 November 21, 2006
888096 FIX: You receive a "Cannot open Clipboard" error message in SQL Server 2000 Analysis Services when you run the InitializeDesign method in a DSO object from an ASP page in IIS 6.0 Q888096 KB888096 November 21, 2006
885928 FIX: You may receive an "Error 132 – Error during Commit, Server will restart to preserve data consistency" error message when you try to perform an incremental update on a virtual dimension for a cube in SQL Server 2000 Analysis Services Q885928 KB885928 November 21, 2006
885426 FIX: You receive an "Analysis Server Error: Connection to the server is lost" error message when you suspend and then resume operations on a cube in SQL Server 2000 Analysis Services Q885426 KB885426 November 21, 2006
885421 FIX: You may experience slow performance when you use the VBA CDate function in a calculated member in SQL Server 2000 Analysis Services Q885421 KB885421 November 21, 2006
884040 FIX: An MDX query returns unchanged data when you try to perform an incremental update on a virtual dimension that is used in a remote partition for a cube in SQL Server 2000 Analysis Services Q884040 KB884040 November 21, 2006
873386 FIX: The Analysis Services service may restart unexpectedly when you try to process a cube partition that has one or more virtual dimensions Q873386 KB873386 November 21, 2006
872783 FIX: Query performance decreases when you run a query against an Analysis Services server that has dynamic security implemented for many users Q872783 KB872783 November 21, 2006
843519 FIX: The Analysis Services service may stop unexpectedly when you run a complex MDX query after you set the Cache Policy connection property to 7 Q843519 KB843519 November 21, 2006
842708 FIX: No warning dialog box appears when changes are made to the member properties in a dimension Q842708 KB842708 November 21, 2006
842707 FIX: Changes to the member properties structure in SQL Server 2000 Analysis Services can cause incorrect results or service failures Q842707 KB842707 November 21, 2006
841178 FIX: The Analysis Services service may shut down if the Cache Policy connection property's value is set to 7 Q841178 KB841178 November 21, 2006
840223 FIX: The Analysis server computer stops responding when you process dimensions and virtual dimensions Q840223 KB840223 November 21, 2006
838004 FIX: MDX queries to cubes where real-time updates are enabled may not reflect updates to the relational table Q838004 KB838004 November 21, 2006
837982 FIX: Internet Explorer may stop responding or you may receive an error message when you try to connect to Analysis Services by using HTTP or HTTPS Q837982 KB837982 November 21, 2006
837724 FIX: An MDX query runs slower when it uses a user-defined function in dynamic security in Analysis Services Q837724 KB837724 November 21, 2006
835975 FIX: Aggregations return Zero values for members of Roles with restricted Measures access Q835975 KB835975 November 21, 2006
834844 FIX: The UserName function returns NULL or an empty string in an MDX query or in an MDX expression Q834844 KB834844 November 21, 2006
834837 FIX: When using the Microsoft Decision Support Objects (DSO) library to perform a processReaggregate operation on a cube the SQL Server 2000 Analysis Services service may shutdown and then restart Q834837 KB834837 November 21, 2006
834494 FIX: Calculated members may return incorrect results for dynamic formulas Q834494 KB834494 November 21, 2006
834490 FIX: MDX queries on a cube that contains a virtual dimension may not reflect changes after the incremental update on the virtual dimension Q834490 KB834490 November 21, 2006
834419 FIX: You cannot exclude members of the computer Administrators group from the OLAP Administrators group Q834419 KB834419 November 21, 2006
833980 FIX: The initialization phase of Analysis Services database processing takes several hours to complete Q833980 KB833980 November 21, 2006
833342 FIX: The Analysis Services service may shut down and then restart when you run MDX queries on a remote computer Q833342 KB833342 November 21, 2006
833162 FIX: An incorrect set of dimension members may be returned in Analysis Services Q833162 KB833162 November 21, 2006
831667 FIX: The writeback operation is not successful when you try to update a cube in SQL Server 2000 Analysis Services Q831667 KB831667 November 21, 2006
831655 FIX: An MDX Query on a Real-Time Update Enabled Cube Returns Results from the Client-Side Cache Q831655 KB831655 November 21, 2006
831652 FIX: A query on a real-time cube may block real-time updates for other cubes Q831652 KB831652 November 21, 2006
830894 FIX: An embedded quotation mark in the MDX ALTER CUBE command removes the character that comes before the quotation mark Q830894 KB830894 November 21, 2006
829897 FIX: Dimension Security on a Cube with Distinct Count May Return #ERR Q829897 KB829897 November 21, 2006
313279 FIX: Unable to drill through cell in an Analysis Services cube and connection to server terminates Q313279 KB313279 November 21, 2006
884405 Filtered items in an OWC that is connected to an SQL Server 2000 Analysis Services database are not filtered when you export the data to Excel Q884405 KB884405 September 27, 2006
907010 FIX: Error message when you print a report in SQL Server 2000 Reporting Services: "An error occurred during printing (0x80004005)" Q907010 KB907010 September 22, 2006
820727 FIX: A long-running cursor fetch may lead to an assertion failure when you try to access a SQL Server 2000 database from an application Q820727 KB820727 August 7, 2006
317619 FIX: Cannot Remove Microsoft SQL Server 2000 Desktop Engine After You Upgrade to MSDE 2000 SP2 Q317619 KB317619 August 7, 2006
915437 FIX: The Campaign Data Import DTS task fails in Commerce Server 2000 Service Pack 3 Q915437 KB915437 July 26, 2006
839986 FIX: The Mail Profile combo box is disabled when you use Enterprise Manager to view SQL Server agent properties, and you receive an error message when you try to use the xp_sendmail stored procedure from a DTS package in SQL Server 2000 Q839986 KB839986 July 25, 2006
892059 FIX: Hotfix packages that have build number 977 may not be installed correctly on SQL Server 2000 64-bit Q892059 KB892059 June 5, 2006
843266 FIX: Shared page locks can be held until end of the transaction and can cause blocking or performance problems in SQL Server 2000 Service Pack 3 (SP3) Q843266 KB843266 June 2, 2006
840856 FIX: The MSSQLServer service exits unexpectedly in SQL Server 2000 Service Pack 3 Q840856 KB840856 June 2, 2006
840208 FIX: You receive a "Msg 8649" error message when you execute the DBCC CHECKDB statement in SQL Server 2000 Service Pack 3 (SP3) Q840208 KB840208 June 2, 2006
899410 FIX: You may experience slow server performance when you start a trace in an instance of SQL Server 2000 that runs on a computer that has more than four processors Q899410 KB899410 June 1, 2006
896425 FIX: The BULK INSERT statement silently skips insert attempts when the data value is NULL and the column is defined as NOT NULL for INT, SMALLINT, and BIGINT data types in SQL Server 2000 Q896425 KB896425 June 1, 2006
892935 FIX: You experience slow performance when you join local partitioned views with a table in SQL Server 2000 Q892935 KB892935 June 1, 2006
892923 FIX: Differential database backups may not contain database changes in the Page Free Space (PFS) pages in SQL Server 2000 Q892923 KB892923 June 1, 2006
892551 FIX: You receive a SqlException error message when you call the sp_addmergepublication stored procedure when the Active Directory directory service is not available in SQL Server 2000 Q892551 KB892551 June 1, 2006
891719 FIX: You receive a 17803 error message when you run a SORT or CREATE INDEX operation on a computer that has several GB of physical RAM from SQL Server 2000 Q891719 KB891719 June 1, 2006
891585 FIX: Database recovery does not occur, or a user database is marked as suspect in SQL Server 2000 Q891585 KB891585 June 1, 2006
890020 FIX: Real-time updates to a cube that contains ROLAP partitions may not reflect updates that are made to the relational data in the underlying source tables for the ROLAP partitions in Analysis Services 64 bit Q890020 KB890020 June 1, 2006
885899 Full Text Search catalog creation fails when Japanese character strings are used Q885899 KB885899 June 1, 2006
885460 FIX: You receive a "The process could not bulk copy into table '<TableName>' " error message when you run the Distribution Agent or the Merge Agent after you run the Snapshot Agent in SQL Server 2000 Q885460 KB885460 June 1, 2006
885424 FIX: You receive an error message and Analysis Manager stops responding when you use the Datamember function on a parent-child dimension in SQL Server 2000 Q885424 KB885424 June 1, 2006
884864 FIX: You may receive incorrect results when you run a query in SQL Server 2000 Q884864 KB884864 June 1, 2006
884850 FIX: When you run ad-hoc queries in Microsoft SQL Server 2000, ad-hoc query processing performance degradation may occur Q884850 KB884850 June 1, 2006
872774 FIX: You may receive a zero-byte attachment in e-mail when e-mail subscriptions are sent to Lotus Domino e-mail servers by SQL Server 2000 Reporting Services Q872774 KB872774 June 1, 2006
823649 FIX: Subscriptions are incorrectly marked inactive although the subscriptions are synchronized in the retention period Q823649 KB823649 May 26, 2006
308841 FIX: Full-text query does not return the expected result set Q308841 KB308841 April 12, 2006
870810 FIX: A SQL Server CE connectivity application stops responding when a network connection that connects a Windows CE-based device to a network is disconnected Q870810 KB870810 April 7, 2006
831710 FIX: A memory leak occurs when you process a cube in Analysis Services Q831710 KB831710 April 7, 2006
312935 FIX: SQL Server fails to bind TCP/IP port at startup Q312935 KB312935 April 7, 2006
286774 FIX: SQL Server 2000 cluster setup fails with a "The procedure entry point ?CloseFile@ConvertRemote@@QAEKPAXPAH@Z could not be located in the dynamic link library Cnvrem.dll" error message Q286774 KB286774 April 6, 2006
312584 FIX: Error message when you try to set up a virtual server on more than one node in SQL Server 2000: "Setup is in resume mode in some of the cluster nodes" Q312584 KB312584 March 18, 2006
308829 FIX: A cluster upgrade to Service Pack 1 does not succeed if SQL Server services are running under a non-administrator account Q308829 KB308829 March 18, 2006
303119 FIX: Physical disk resources are not added when you upgrade from a SQL Server 7.0 cluster to a SQL Server 2000 clustered instance Q303119 KB303119 March 15, 2006
290128 FIX: Error messages from the SQL Server resource DLL may not be logged in the Application log in the Event Viewer Q290128 KB290128 March 14, 2006
284440 FIX: UPDATE with CASE Statement That Uses NEWID() Function Causes Errors 8951, 8952, 8955 and 8956 Q284440 KB284440 March 14, 2006
281617 FIX: SQLMAINT Backup to Tape with Verify Only Checks the First File Q281617 KB281617 March 14, 2006
281185 FIX: Linked Index Server Query Through OLE DB Provider with OR Clause Reports Error 7349 Q281185 KB281185 March 14, 2006
278509 FIX: Distribution Agent Ignores Quoted Identifier Option on Initial Sync to Oracle Subscribers Q278509 KB278509 March 14, 2006
277640 FIX: Denial of Service Attack with NULL Bytes in RPC Request Q277640 KB277640 March 14, 2006
275690 FIX: SQL Server Agent Startup May be Delayed by Four Seconds Q275690 KB275690 March 14, 2006
275145 FIX: Only One SQL Server Performance Condition Alert Is Treated As Active Q275145 KB275145 March 14, 2006
274483 FIX: Unable to choose article resolver when you use SQL Server 2000 distributor and SQL Server 7.0 publisher Q274483 KB274483 March 14, 2006
261216 FIX: Snapshot Agent for a Merge Publication Might Fail with Error Message 4408 or 50007 Q261216 KB261216 March 14, 2006
253230 FIX: SEM: Appended Backup Database with Verify Always Checks Only FILE Number = 1 Q253230 KB253230 March 14, 2006
235693 FIX: Select Query with GROUP BY and Outer Join Causes Handled Access Violation Q235693 KB235693 March 14, 2006
286750 FIX: Data transfer using ODBC Driver for SQL Server fails Q286750 KB286750 March 7, 2006
309016 FIX: SQL Server subscribers may encounter unnecessary network traffic on synchronization Q309016 KB309016 February 14, 2006
308744 FIX: Merge dynamic Snapshot Agent may fail while it generates an initial snapshot for a publication with a large number of tables Q308744 KB308744 January 26, 2006
315059 FIX: You receive a "digital signature error" error message during the MDAC portion of Visual Studio .NET Setup Q315059 KB315059 January 19, 2006
823490 FIX: MSXML 2.6 is not redistributed with SQL Server MSDE SP3 or SP3a Q823490 KB823490 January 16, 2006
894555 FIX: Error message when you execute multiple statements in a batch command that does not return a result set in the SQL Server 2000 Driver for JDBC: "Statements that produce result sets are not allowed in batch commands" Q894555 KB894555 January 6, 2006
302409 FIX: Unable to Connect to SQL Server 2000 When Certificate Authority Name Is the Same As the Host Name of the Windows 2000 Computer Q302409 KB302409 December 13, 2005
311111 FIX: The remote procedure call (RPC) client cannot connect to a server that is running SQL Server and is configured to use "Windows only" authentication Q311111 KB311111 December 1, 2005
894562 FIX: The SQLWarning class does not return an error code or a valid SQL state for a 3604 error when you use the SQL Server 2000 Driver for JDBC Q894562 KB894562 November 28, 2005
814509 FIX: A parallel query may return unexpected results Q814509 KB814509 November 2, 2005
837816 FIX: You receive an error when you try to update the fields in the dataset of a report in Report Designer Q837816 KB837816 October 25, 2005
829734 FIX: A SQL Server CE CASE function that returns NULL leads to incorrect results or exception errors Q829734 KB829734 October 25, 2005
829642 FIX: Synchronization fails for SQL Server CE merge replication Q829642 KB829642 October 25, 2005
827914 FIX: The synchronization process fails for a merge replication that uses dynamic partitions Q827914 KB827914 October 25, 2005
825225 FIX: You receive an error message when you run a parallel query that uses an aggregation function or the GROUP BY clause Q825225 KB825225 October 25, 2005
823689 FIX: "Value can not be converted to requested type" error when you try to read a Real data type column from a JDBC ResultSet object Q823689 KB823689 October 25, 2005
823455 FIX: Visual Basic raises a syntax error when you try to compile a file that was created when you saved a DTS package Q823455 KB823455 October 25, 2005
821688 FIX: A query filter condition that has a LEFT OUTER JOIN clause may cause an incorrect row count estimate in the query execution plan Q821688 KB821688 October 25, 2005
821386 FIX: A query with a DISTINCT operator may cause an access violation or an assertion error or may cause the program to stop responding in SQL Server 2000 Windows CE version 2.0 Q821386 KB821386 October 25, 2005
821192 FIX: JDBC Driver Does Not Duplicate the Transaction Isolation Level in Cloned Connection Q821192 KB821192 October 25, 2005
820773 FIX: SQL Server 2000 Driver for JDBC leaks server cursors Q820773 KB820773 October 25, 2005
304716 FIX: Access violation in RepODBC.dll when you try to connect to repository Q304716 KB304716 October 19, 2005
300181 FIX: DTS Error Message Repeated Multiple Times When You Import from a Text File Q300181 KB300181 October 19, 2005
814410 FIX: Performance degradation and memory leak in the ODBC Driver for SQL Server Q814410 KB814410 October 18, 2005
319851 FIX: Assertion and Error Message 3314 Occurs If You Try to Roll Back a Text Operation with READ UNCOMMITTED Q319851 KB319851 October 18, 2005
324469 FIX: Error message 9004 may occur when you restore a log that does not contain any transactions Q324469 KB324469 October 12, 2005
314125 FIX: AV When You Call MSXML 2.6 Parser from a Stored Procedure Q314125 KB314125 October 12, 2005
312294 FIX : Use of a Fast Forward Cursor with a UNION Operator and a Remote Table May Cause Access Violation Q312294 KB312294 October 12, 2005
311104 FIX: The SELECT Statement with Parallelism Enabled May Cause an Assertion Q311104 KB311104 October 12, 2005
292648 FIX: Bcp.exe ignores -R regional settings switch when using format file (-f) Q292648 KB292648 October 12, 2005
899402 FIX: You may experience a decrease in performance if you repeatedly call the setQueryTimeout method on a connection object by using the SQL Server 2000 Driver for JDBC Q899402 KB899402 October 11, 2005
818335 FIX: A query may run slowly if the query contains a multi-table join and one of the joins is a view Q818335 KB818335 October 11, 2005
817780 FIX: A complex query is not successful on a server that has more than 2 GB of memory Q817780 KB817780 October 11, 2005
814419 FIX: An infinite recompile occurs on a query or an index on a heap that has more than 2,147,483,647 modified rows Q814419 KB814419 October 11, 2005
331610 FIX: Calculated Members That Use Time Based User Defined Functions May Not Update as Expected Q331610 KB331610 October 11, 2005
331158 FIX: A Query That Causes a Hash Bailout May Return Incorrect Results Q331158 KB331158 October 11, 2005
329499 FIX: Replication Removed from Database After Restore WITH RECOVERY Q329499 KB329499 October 11, 2005
329487 FIX: Transaction Log Restore Fails with Message 3456 Q329487 KB329487 October 11, 2005
329069 FIX: DBREINDEX on Large Tables May Cause High Number of Extent Lock Timeouts Q329069 KB329069 October 11, 2005
328908 FIX: Transaction Rolls Back Automatically with Error 8144 on a Prepared Command Q328908 KB328908 October 11, 2005
327651 FIX: Merge Replication Non-Convergence Occurs When You Use the "Subscriber Always Wins Conflict Resolver" Option Q327651 KB327651 October 11, 2005
326483 FIX: The Merge Agent incorrectly deletes rows after a primary key violation occurs Q326483 KB326483 October 11, 2005
325720 FIX: An access violation occurs when a cursor is defined on a query that has nested subqueries Q325720 KB325720 October 11, 2005
321541 FIX: SQL Server Might Return Incorrect Results When You Use an Outer Join and a View Q321541 KB321541 October 11, 2005
319246 FIX: Error Dialog Box During SQL Server Database Backup Q319246 KB319246 October 11, 2005
318075 FIX: Compressed Snapshot CAB Does Not Contain All Necessary Files Q318075 KB318075 October 11, 2005
315559 FIX: ESQL/C Precompiler May Cause Access Violation When It Processes a Complex ESQL Project Q315559 KB315559 October 11, 2005
894563 FIX: You receive a java.lang.StackOverFlowError exception when you execute lots of PRINT statements through the SQL Server 2000 Driver for JDBC Q894563 KB894563 October 7, 2005
894560 FIX: An invalid time value is inserted when you use the java.util.Calendar class and the java.sql.Date class through the SQL Server 2000 Driver for JDBC Q894560 KB894560 October 7, 2005
894559 FIX: You receive an "Underlying input stream returned zero bytes" error message when you use the SQL Server 2000 Driver for JDBC to retrieve the value from an empty text column Q894559 KB894559 October 7, 2005
894557 FIX: The client connection may end when you insert an out-of-range datetime value in a server by using the SQL Server 2000 Driver for JDBC Q894557 KB894557 October 7, 2005
894552 FIX: The SQL Server 2000 Driver for JDBC may spawn a new thread when you call the setQueryTimeout function on a connection object, and performance may decrease when you repeatedly call the setQueryTimeout function Q894552 KB894552 October 7, 2005
883832 FIX: You may receive an error message when multiple threads in your Java application try to obtain a pooled connection Q883832 KB883832 October 7, 2005
306890 FIX: Merge Join with Rank Operator May Produce Incorrect Results Q306890 KB306890 October 7, 2005
306487 FIX: SQL Server CE Subscribers May Receive Duplicate Changes on Synchronization Q306487 KB306487 October 7, 2005
304363 FIX: Merge Snapshot Does Not Recognize FTP for Jet Subscribers Q304363 KB304363 October 7, 2005
303950 FIX: Exception Access Violation Encountered in PrintWarnings Function Q303950 KB303950 October 7, 2005
297209 FIX: Deletes, Updates and Rank Based Selects May Cause Deadlock of MSSEARCH Q297209 KB297209 October 7, 2005
294970 FIX: Distribution Agent Fails with Syntax Error with Compensating Commands for Queued Updating Subscribers Q294970 KB294970 October 7, 2005
293219 FIX: Query with Complex Correlated Subquery May Cause Unexpected Results Q293219 KB293219 October 7, 2005
292587 FIX: Stored Procedure xp_sqlagent_proxy_account Returns "The handle is invalid" Error Message Q292587 KB292587 October 7, 2005
292432 FIX: OR of Multiple Expressions with Common Subexpressions May Choose Poor Plan Q292432 KB292432 October 7, 2005
291540 FIX: Instead of Triggers that Use Work Tables Cause a Memory Leak Q291540 KB291540 October 7, 2005
290817 FIX: Error 8624 may occur with subquery that contains aggregate or computed columns Q290817 KB290817 October 7, 2005
289739 FIX: Distributed Query with Optika Provider May Return Incorrect Results Q289739 KB289739 October 7, 2005
286286 FIX: LOCK_TIMEOUT causes transaction to roll back and @@error does not capture error 1222 Q286286 KB286286 October 7, 2005
281769 FIX: Exception Access Violation Encountered During Query Normalization Q281769 KB281769 October 7, 2005
280846 FIX: Merge Snapshot Agent May Fail With Syntax Error Message When Published Table Contains Computed Columns Q280846 KB280846 October 7, 2005
274330 FIX: Sending Open Files as Attachment in SQL Mail Fails with Error 18025 Q274330 KB274330 October 7, 2005
273769 FIX: SQL Server Setup may fail if you select Per Processor licensing mode Q273769 KB273769 October 7, 2005
838610 FIX: "Column index <index> out of range" error when you try to read a field from a JDBC ResultSet object Q838610 KB838610 October 5, 2005
827221 FIX: Unsupported Data Conversion Error Occurs When You Use a Null Timestamp in JDBC Q827221 KB827221 October 5, 2005
817081 FIX: You receive an error message when you use the SQL-DMO BulkCopy object to import data into a SQL Server table Q817081 KB817081 September 27, 2005
815249 FIX: Performance of a query that is run from a client program on a SQL Server SP3 database is slow after you restart the instance of SQL Server Q815249 KB815249 September 27, 2005
812915 FIX: "Performance monitor shared memory setup failed: -1" error message when you start SQL Server Q812915 KB812915 September 27, 2005
812558 FIX: SQL Server ODBC Driver Does Not Report Canceled Query Q812558 KB812558 September 27, 2005
810195 FIX: Parallel Index Operations Might Cause Latch Warning Messages Q810195 KB810195 September 27, 2005
330458 FIX: A Query That Causes Hash Role Reversal May Return Incorrect Results Q330458 KB330458 September 27, 2005
330212 FIX: Parallel logical operation returns results that are not consistent Q330212 KB330212 September 27, 2005
329375 FIX: Access Violations May Occur with SQL Mail When You Use XP_SENDMAIL Q329375 KB329375 September 27, 2005
328920 FIX: Querying Sysmembers Might Result in a Leak of Buffer Pool Memory Q328920 KB328920 September 27, 2005
328736 FIX: Updates That Run at a Read Uncommitted Isolation Level Fail with a 644 Error Message Q328736 KB328736 September 27, 2005
328569 FIX: Ad Hoc Access Incorrectly Permitted If DisallowAdhocAccess Registry Key Is Missing Q328569 KB328569 September 27, 2005
328550 FIX: Resource Contention Occurs When You Update Multiple Tables That Have a Timestamp Column Q328550 KB328550 September 27, 2005
328354 FIX: A RESTORE DATABASE WITH RECOVERY Statement Can Fail with Error 9003 or Error 9004 Q328354 KB328354 September 27, 2005
328187 FIX: A Query That Uses a Hash Match with a Residual Predicate Might Return Incorrect Results Q328187 KB328187 September 27, 2005
327637 FIX: Dynamic Snapshot Generation May Experience Slow Performance Q327637 KB327637 September 27, 2005
327562 FIX: Joins with a UNION ALL View May Take a Long Time to Compile and May Use Large Amounts of Memory Q327562 KB327562 September 27, 2005
327289 FIX: The Distribution Agent Might Shut Down with a Syntax Error or Queued Updating Subscribers Might Become Unsynchronized Q327289 KB327289 September 27, 2005
326999 FIX: Lock escalation on a scan while an update query is running causes a 1203 error message to occur Q326999 KB326999 September 27, 2005
326934 FIX: Query Compilation Fails with Error 701 After It Uses Up Buffer Pool Memory Q326934 KB326934 September 27, 2005
326810 FIX: A query that references a view that uses UNION operator may return incorrect results Q326810 KB326810 September 27, 2005
326314 FIX: Cardinality Estimation of ISNULL Function Does Not Account for Null Values Q326314 KB326314 September 27, 2005
325902 FIX: The Distribution Agent May Fail After You Add an Article to an Existing Transactional Publication Q325902 KB325902 September 27, 2005
325658 FIX: Parameterized Query with Several IN Clauses Fails with Error: 8623 Q325658 KB325658 September 27, 2005
325607 FIX: The fn_get_sql function returns SQL text for handle in the Sysprocesses system table Q325607 KB325607 September 27, 2005
325492 FIX: Input Parameters to the OLE Automation (sp_OA) Stored Procedures Truncate at 4000 Characters Q325492 KB325492 September 27, 2005
325197 FIX: Reading a Profiler Trace with the ::fn_trace_gettable Function and SPID 1000 Might Cause Errors Q325197 KB325197 September 27, 2005
324630 FIX: DBCC INDEXDEFRAG May Cause an Assertion Failure If the Index Includes Variable-Length Columns Q324630 KB324630 September 27, 2005
324563 FIX: If You Use the sp_reinitmergesubscription Stored Procedure with @UPLOAD_FIRST Set to TRUE Data Loss May Occur for SQL Server CE Subscribers Q324563 KB324563 September 27, 2005
324515 FIX: Update Conflict for Unique Key Columns for Queued Updating Subscriber Results in Non-Convergence Q324515 KB324515 September 27, 2005
324186 FIX: Slow Compile Time and Execution Time with Query That Contains Aggregates and Subqueries Q324186 KB324186 September 27, 2005
323721 FIX: Filter Not Pushed Below Aggregate If Subquery Uses the DISTINCT Keyword Q323721 KB323721 September 27, 2005
323609 FIX: Distribution Agent May Fail with Syntax Error Q323609 KB323609 September 27, 2005
323550 FIX: The Replication Queue Reader Agent Utility Shuts Down After Error 2601 Occurs Q323550 KB323550 September 27, 2005
323545 FIX: The Distribution Agent Shuts Down and Error 2627 or Error 2601 Are Generated When You Apply a Command to a Queued Updating Subscriber Q323545 KB323545 September 27, 2005
323248 FIX: Lock Timeout on Scrollable Cursor May Occur if Page Locking is Disabled Q323248 KB323248 September 27, 2005
323213 FIX: Subquery That Returns One Row May Cause CPU Spin and Excessive Optimizer Memory Usage Q323213 KB323213 September 27, 2005
323212 FIX: Optimizer May Consume Too Much Memory if Address Windowing Extensions (AWE) is Enabled Q323212 KB323212 September 27, 2005
323038 FIX: Infinite Loop During Full-Text Catalog Population Q323038 KB323038 September 27, 2005
322871 FIX: Incorrect Results May Occur with Index Spool and Parallel Plan Q322871 KB322871 September 27, 2005
322868 FIX: Deadlock May Occur During Update Statistics on System Tables Q322868 KB322868 September 27, 2005
322865 FIX: 8623 Error Message Occurs When Opening a Fast Forward Only Cursor on a View Q322865 KB322865 September 27, 2005
322854 FIX: Reordering Joins May Cause MISSING JOIN PREDICATE Warning Q322854 KB322854 September 27, 2005
322668 FIX: Inconsistent Results on Parallel Update That Causes Page Splits Q322668 KB322668 September 27, 2005
322384 FIX: Replication Queued Updating Supports Unique Constraints Q322384 KB322384 September 27, 2005
322379 FIX: Bulk Insert Operation May Cause Blocking Q322379 KB322379 September 27, 2005
321879 FIX: IDENTITY Columns May Be Incorrectly Reseeded If SQL Server Shuts Down Unexpectedly Q321879 KB321879 September 27, 2005
321873 FIX: SQL Enterprise Manager May Experience an Access Violation When It Monitors Remote Servers Over Slow Connections Q321873 KB321873 September 27, 2005
321870 FIX: SQL Enterprise Manager May Experience an Access Violation in the COleUtilEnumConnections::Release Function Q321870 KB321870 September 27, 2005
321858 FIX: MDAC: Patch Available for Script Injection with XML Tag and Unchecked Buffer in SQLXML ISAPI Extension Vulnerabilities Q321858 KB321858 September 27, 2005
321820 FIX: Non-OCR/Non-Display TIFF Data Indexed by SQL Server Full-Text Q321820 KB321820 September 27, 2005
321460 FIX: Patch Available for Script Injection with XML Tag and Unchecked Buffer in SQLXML ISAPI Extension Vulnerabilities Q321460 KB321460 September 27, 2005
320434 FIX: Bulk Insert with TABLOCK Hint May Result in Errors 8929 and 8965 When You Run CHECKDB Q320434 KB320434 September 27, 2005
319962 FIX: Access Violation May Occur If You Log Off After You Cancel A Linked Server Query Q319962 KB319962 September 27, 2005
319961 FIX: Merge Agent Fails with Error Message: "The publisher has been restored from a backup whose schema change version is different..." Q319961 KB319961 September 27, 2005
319869 FIX: Improved SQL Manager Robustness for Odd Length Buffer Q319869 KB319869 September 27, 2005
319610 FIX: You may receive unexpected results when you use a text column and an OR operator to combine criteria from multiple subqueries Q319610 KB319610 September 27, 2005
319455 FIX: Xp_msver Returns Null for Most of the Properties of a Non-English SQL Server Installation Q319455 KB319455 September 27, 2005
319258 FIX: Anonymous or Local Merge Subscriber Fails with Error 8152 Q319258 KB319258 September 27, 2005
319184 FIX: Parallel Query May Fail with Error Message 1203 and an Assertion Q319184 KB319184 September 27, 2005
318878 FIX: ALTER DATABASE SET READ_ONLY Statement May Lead to an Assertion If the Transaction Log is Full Q318878 KB318878 September 27, 2005
318874 FIX: Parallel Query May Cause an Access Violation in CBitSet::Incl Q318874 KB318874 September 27, 2005
318870 FIX: Incorrect Values with Queued Updating Replication When Money Values Are Between 0 and 1 Q318870 KB318870 September 27, 2005
318606 FIX: SQL Server ODBC Driver Resets Connection Attributes When Used in Connection Pooling Q318606 KB318606 September 27, 2005
318592 FIX: Snapshots Created on SQL Server Service Pack 2 Cannot Be Delivered Through FTP to Pre-SQL Server 2000 Service Pack 2 Subscribers Q318592 KB318592 September 27, 2005
318045 FIX: SELECT with Timestamp Column That Uses FOR XML AUTO May Fail with Stack Overflow or AV Q318045 KB318045 September 27, 2005
317979 FIX: Unchecked Buffer May Occur When You Connect to Remote Data Source Q317979 KB317979 September 27, 2005
317973 FIX: Abort by DTC Transaction Timeout Not Recognized on a Client Application Q317973 KB317973 September 27, 2005
317847 FIX: Incorrect Results Are Returned When You Use ROWCOUNT and an INSERT INTO Statement Q317847 KB317847 September 27, 2005
317748 FIX: Handle Leak Occurs in SQL Server When Service or Application Repeatedly Connects and Disconnects with Shared Memory Network Library Q317748 KB317748 September 27, 2005
317015 FIX: Complex Linked Server Query May Cause Handled AV in COleDbParams::ClearParamBuf Q317015 KB317015 September 27, 2005
316541 FIX: Error 913 May Occur on a SELECT from a Linked Server That Uses a Check Constraint That References a User-Defined Function Q316541 KB316541 September 27, 2005
316331 FIX: DTSTransferObjects with Events Generates an Error Message and an Access Violation in Visual Basic Q316331 KB316331 September 27, 2005
315662 FIX: Parallel Query May Encounter Undetected Deadlock with Itself Q315662 KB315662 September 27, 2005
315649 FIX: LIKE Operator with Japanese Repeating Character That Follows a Wildcard Does Not Return Expected Results Q315649 KB315649 September 27, 2005
315447 FIX: SQL Server 2000 may be more aggressive with Lazy Writes than SQL Server 7.0 Q315447 KB315447 September 27, 2005
315395 FIX: COM May Not Be Uninitialized for Worker Thread When You Use sp_OA Q315395 KB315395 September 27, 2005
314406 FIX: Updates Do Not Replicate to Subscriber After Drop or Add of Columns Q314406 KB314406 September 26, 2005
314304 FIX: Query Results in Message Body of xp_sendmail are Empty If You Use ansi_attachments Option Q314304 KB314304 September 26, 2005
314003 FIX: Query That Uses DESC Index May Result in Access Violation Q314003 KB314003 September 26, 2005
313302 FIX: Shared Table Lock Is Not Released After Lock Escalation Q313302 KB313302 September 26, 2005
313005 FIX: SELECT from Computed Column That References UDF Causes SQL Server to Terminate Q313005 KB313005 September 26, 2005
312578 FIX: Index Scans on Frequently Modified Table May Return Incorrect Results Q312578 KB312578 September 26, 2005
312091 FIX: Optimized Lock Manager Lookup on SMP Systems Q312091 KB312091 September 26, 2005
311155 FIX: "ODBC SQL Server Driver" Error Message When You Use the MDAC 2.6 ODBC Driver from SP1 or SP2 Q311155 KB311155 September 26, 2005
311120 FIX: Abort of Bulk Insert May Result in Error Message 8979 from CHECKDB Q311120 KB311120 September 26, 2005
311096 FIX: Retrieves Inconsistent Results Returned by Indexed Access OLEDB Provider Q311096 KB311096 September 26, 2005
309678 FIX: Thesaurus Support is Not Available for Full-Text Search Q309678 KB309678 September 26, 2005
309568 FIX: Error Message 8624 "Internal SQL Server" Occurs with Cold Index Retrieval OLE DB Provider Q309568 KB309568 September 26, 2005
309251 FIX: Execution of Sp_addsynctriggers Results in Syntax Error After ALTER TABLE Q309251 KB309251 September 26, 2005
308547 FIX: SELECT DISTINCT from Table with LEFT JOIN of View Causes Error Messages or Client Application May Stop Responding Q308547 KB308547 September 26, 2005
307948 FIX: SQL Mail Attachments Contain Leading Space Before First Column of Each Result Row Q307948 KB307948 September 26, 2005
307540 FIX: SQLPutData May Result in Leak of Buffer Pool Memory Q307540 KB307540 September 26, 2005
307538 FIX: SQLTrace Start and Stop is Now Reported in Windows NT Event Log for SQL Server 2000 Q307538 KB307538 September 26, 2005
306998 FIX: Complex CASE Clause on Query May Cause Error 8621 and Terminate Batch Q306998 KB306998 September 26, 2005
306199 FIX: Dynamic IP Addresses Cannot Connect to SQL Server 2000 Q306199 KB306199 September 26, 2005
306096 FIX: Infinite Loop Occurs in ESQL Application That Uses Keyset Cursor Q306096 KB306096 September 26, 2005
304847 FIX: Abort of DTC Transaction in tempdb May Cause 7105 Errors, Assertions, and Possible Shutdown of SQL Server Q304847 KB304847 September 26, 2005
303446 FIX: SQLOLEDB Returns No Data When Using AutoFetch Option with Fast Forward Cursors Q303446 KB303446 September 26, 2005
303120 FIX: ConnectionWrite Error When You Use Lightweight Pooling Q303120 KB303120 September 26, 2005
302248 FIX: SQLOLEDB Does Not Work with DBACCESSOR_OPTIMIZED Flag and SSPROP_ENABLEFASTLOAD Q302248 KB302248 September 26, 2005
300447 FIX: Snapshot Delivery Failure During BCP IN Not Recognized by Merge Agent Q300447 KB300447 September 26, 2005
300420 FIX: Connection to SQL Server Database Using IP Address Is Unusually Slow Q300420 KB300420 September 26, 2005
299765 FIX: SQL Server 2000 ODBC Driver fails to return SQL Server 7.0 server names on client computers that have MDAC 2.6 installed Q299765 KB299765 September 26, 2005
299423 FIX: XML for SQL Server 2000 Web Release 1 Hotfix Rollup Q299423 KB299423 September 26, 2005
297266 FIX: SQLOLEDB: Incorrect Transaction Enlistment Causes Hang and Drain Abort Entry Q297266 KB297266 September 26, 2005
295757 FIX: Second SQLExecute on Prepared Statement with SQL_NOSCAN_ON Causes Client-Side AV Q295757 KB295757 September 26, 2005
295054 FIX: Insert with OPENXML Statement Generates Duplicate Key Error Q295054 KB295054 September 26, 2005
291838 FIX: Crash in SQLXMLX Hangs Web Service Threads Q291838 KB291838 September 26, 2005
286359 FIX: SQL Server ODBC Driver Generates Error When Executing a Stored Procedure on SQL Server 2000 Q286359 KB286359 September 26, 2005
285006 FIX: You receive error message 6603 or text data may be truncated when you select a text data type through the OPENXML provider in SQL Server 2000 Q285006 KB285006 September 26, 2005
282455 FIX: SQL Server Fails to Start When Computer Binds 48 or More Socket Addresses Q282455 KB282455 September 26, 2005
281633 FIX: SQLOLEDB Provider incorrectly leaves transaction open Q281633 KB281633 September 26, 2005
279526 FIX: SQL Server ODBC Driver Ignores Authentication Setting Q279526 KB279526 September 26, 2005
273813 FIX: "Incorrect Syntax near the Keyword 'by' " Error Message with Column Names of "C", "CA" or "CAS" Q273813 KB273813 September 26, 2005
328314 FIX: Cannot upload null values in Sql_variant data type by using SQL Server CE merge replication Q328314 KB328314 September 9, 2005
323143 FIX: SQL Server CE is missing the Oledb.lib file for eMbedded Visual C++ 4.0 Q323143 KB323143 September 9, 2005
313533 FIX: SQL Server CE subscriptions may not be correctly marked as expired Q313533 KB313533 September 9, 2005
894558 FIX: You receive an error message in SQL Server 2000 Driver for JDBC when you submit a converted SQL statement that is generated by the Connection.nativeSQL() method to the SQL database. Q894558 KB894558 September 1, 2005
826436 FIX: A scan of data that uses the unordered page supplier reports error 605, error 625, error 644, and error 823 in SQL Server 2000 Service Pack 3 Q826436 KB826436 August 4, 2005
279867 FIX: Sending Maintenance Report by E-mail to Operator Fails in Maintenance Plan Q279867 KB279867 June 23, 2005
247527 FIX: DTS May Truncate Characters When You Export a Table Column of Character Data Type to a Text File Q247527 KB247527 June 23, 2005
894556 FIX: A JDBC connection becomes invalid when you try to cancel a query from a second thread through the SQL Server 2000 Driver for JDBC Q894556 KB894556 April 12, 2005
833547 FIX: Restoring a SQL Server 7.0 database backup in SQL Server 2000 Service Pack 3 (SP3) may cause an assertion error in the Xdes.cpp file Q833547 KB833547 April 2, 2005
894561 FIX: You do not receive a "Timeout expired" error message after subsequent tries to execute a stored procedure even though you use the setQueryTimeout method to set a time-out through the SQL Server 2000 Driver for JDBC Q894561 KB894561 March 23, 2005
821337 FIX: Localized versions of SQL Mail and the Web Assistant Wizard may not work as expected in SQL Server 2000 64 bit Q821337 KB821337 March 16, 2005
828269 FIX: A Transact-SQL query that uses views may fail unexpectedly in SQL Server 2000 SP3 Q828269 KB828269 March 10, 2005
327145 FIX: You cannot create diagrams in SQL Enterprise Manager if you are not a database owner Q327145 KB327145 March 4, 2005
817709 FIX: SQL Server 2000 might produce an incorrect cardinality estimate for outer joins Q817709 KB817709 February 11, 2005
332004 FIX: SQL Server Scalability May Be Limited if AWE Is Enabled Q332004 KB332004 February 11, 2005
288411 FIX: "Incorrect syntax near COLLATE" during DTS transfer on SQL Server 7.0 database that is restored to SQL Server 2000 Q288411 KB288411 December 21, 2004
294420 FIX: Logreader fails to select text data that is inserted by SQL Server 6.5 Bcp utility Q294420 KB294420 December 17, 2004
308822 FIX: Cardinality estimates may be incorrect for a table created and populated in the same transaction Q308822 KB308822 November 29, 2004
305377 FIX: SQL Server 2000 May Be More Aggressive with Read-Ahead Than SQL Server 7.0 Q305377 KB305377 November 17, 2004
295114 FIX: SELECT * FROM SYSINDEXES on a database that is upgraded to SQL Server 2000 may cause an access violation Q295114 KB295114 November 17, 2004
249730 FIX: A SQL Server 7.0 Transact-SQL scheduled task may run slower in SQL Server 7.0 and SQL Server 2000 Q249730 KB249730 November 17, 2004
292237 FIX: xp_startmail Does Not Start Default Profile on Nondefault Instance Q292237 KB292237 August 30, 2004
555180 xp_sendmail Fails with Mail Error 0x80004005 if active mail session with Exchange server was broken Q555180 KB555180 August 19, 2004
842534 FIX: Bookmark links in a report that is rendered to the Web archive file format (.mhtml) may not work correctly Q842534 KB842534 August 13, 2004
299717 FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally Have Q299717 KB299717 August 9, 2004
308267 FIX: DTS Copy Objects Task (DMO) breaks transaction log backup chain by switching recovery mode to Simple during transfer Q308267 KB308267 July 27, 2004
274266 FIX: Data Modification Query with a Distinct Subquery on a View May Cause Error 3624 Q274266 KB274266 July 15, 2004
842514 FIX: The report parameters may not appear correctly when you preview a report in a non-English version of Report Designer Q842514 KB842514 July 7, 2004
842435 FIX: You may receive an error message when you run a report that connects to an Access database data source in SQL Server 2000 Reporting Services Q842435 KB842435 July 7, 2004
308016 FIX: sp_configure 'network packet size' Not Functional in SQL Server 7.0 SP3 and SQL Server 2000 Q308016 KB308016 June 29, 2004
302664 FIX: Query with SET NO_BROWSETABLE Option Set ON May Generate Access Violation Q302664 KB302664 June 28, 2004
842538 FIX: Subscriptions that use the e-mail delivery method for distribution may not deliver the report successfully in SQL Server 2000 Reporting Services Q842538 KB842538 June 22, 2004
842536 FIX: Hebrew characters in a report appear in reverse order when you export the report to the "Acrobat (PDF) file" format in SQL Server 2000 Reporting Services Q842536 KB842536 June 22, 2004
842517 FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer Q842517 KB842517 June 22, 2004
296612 FIX: A large array of IN clause parameters parses or compiles slower on SQL Server 2000 Q296612 KB296612 April 12, 2004
817845 FIX: "Login Failed for User 'SYSTEM'" Error When You Use OPENROWSET Function Without UserName Q817845 KB817845 April 6, 2004
314635 FIX: "Catastrophic Failure" Error Message When You Use adPromptAlways to Connect to SQL Server 2000 Q314635 KB314635 April 6, 2004
299439 FIX: Merge Snapshot Generation Fails with Error Message: " Line 326: Incorrect Syntax near '-' if the Table Schema Contains a ROWGUID Column Q299439 KB299439 April 6, 2004
323280 FIX: Registered remote servers disappear from SQL Enterprise Manager in Windows XP when user password is changed Q323280 KB323280 March 17, 2004
308724 FIX: Replication Agent Startup Step Name Shows "Log Reader Agent startup message" Q308724 KB308724 February 19, 2004
300172 FIX: sp_addmergearticle May Fail with Error 20009 if Article Added Is Vertically Filtered Q300172 KB300172 January 28, 2004
323040 FIX: SQL Server Full-Text Population by Using a Single-Threaded Filter DLL or a PDF Filter DLL May Not Succeed Q323040 KB323040 January 20, 2004
827223 FIX: NullPointerException when you set the Timestamp parameter to Null with JDBC Q827223 KB827223 December 11, 2003
314636 FIX: Cannot Use Non-Administrator Account to Start SQL Server and Force Encryption Q314636 KB314636 December 3, 2003
308932 FIX: Enterprise Manager May Show Incorrect Number of Configured CPUs Q308932 KB308932 November 17, 2003
295002 FIX: SQL Server 2000 Setup Does Not Install Jet Drivers Help File Q295002 KB295002 November 14, 2003
290415 FIX: Use of the Jet Provider to Query a Linked Server Text File from SQL Server May Be Very Slow Q290415 KB290415 November 13, 2003
295373 FIX: Creating Indexes in Parallel May Fail with Deadlock on Sysindexes Q295373 KB295373 November 6, 2003
295113 FIX: Corrupted TDS Packets Cause Access Violation in SQL Server Q295113 KB295113 November 6, 2003
295055 FIX: sp_OAMethod Does Not Convert Numeric Datatype Correctly Q295055 KB295055 November 6, 2003
295051 FIX: Changing SQL Server Account to Non-Admin for Full-Text Search Makes Existing Catalogs Unusable Q295051 KB295051 November 6, 2003
295039 FIX: Assertion Raised When DELETE Is Performed on a Table Joined with a View Q295039 KB295039 November 6, 2003
295037 FIX: MERGE UNION Is Not Used with Large Number of UNION Clauses Q295037 KB295037 November 6, 2003
294944 FIX: DTSWIZ.exe Closes When Exporting to a Text File if the File Name Contains 255 Characters Q294944 KB294944 November 6, 2003
294902 FIX : Rollback to Savepoint Causes Assertion and Errors Q294902 KB294902 November 6, 2003
294874 FIX: Combination of Multiple EXIST, OR, and Subquery Clauses May Give a Sub-Optimal Plan Q294874 KB294874 November 6, 2003
294860 FIX: Modification Queries May Take Too Long to Compile if Halloween Protection is Required for Multiple Tables Q294860 KB294860 November 6, 2003
294839 FIX: No Error Message Generated by Query Analyzer When You Try to Open a Database with a Name Greater Than 128 Characters Q294839 KB294839 November 6, 2003
294787 FIX: Update Plan with User Defined Function May Fail to Find a Plan Q294787 KB294787 November 6, 2003
294459 FIX: Can't Use Four-Part Name to Query Oracle Table If Name Contains Lowercase Characters Q294459 KB294459 November 6, 2003
294415 FIX: Resource Does Not Failover Immediately if an Error is Encountered by the Resource DLL Q294415 KB294415 November 6, 2003
294338 FIX: xp_enumgroups Generates an Access Violation when Passed a Large Parameter Q294338 KB294338 November 6, 2003
294311 FIX: Trigger Does Not Return Expected Duplicate Key Insert Error to Client Q294311 KB294311 November 6, 2003
293849 FIX: Statistics Maintenance Creates Significant Bottleneck on SQL Servers that Use 16 or More CPUs Q293849 KB293849 November 6, 2003
293784 FIX: Unable to Drop a Catalog When Disk is Full Q293784 KB293784 November 6, 2003
293632 FIX: EventSubClass Column Incorrect for Deadlock Chain Events Q293632 KB293632 November 6, 2003
293489 FIX: Merge Replication with Dynamic Filters May Cause MMC to Fail Q293489 KB293489 November 6, 2003
293464 FIX: Merge Replication Does Not Log Conflicts after Successively Adding and Dropping Columns Q293464 KB293464 November 6, 2003
293345 FIX: ANSI Script from Profiler Cannot be Opened in Query Analyzer Q293345 KB293345 November 6, 2003
293329 FIX: Attaching Database Files Saved In Different Disk Folders Through SQL Enterprise Manager Q293329 KB293329 November 6, 2003
293292 FIX: DBCC CHECKDB May Produce an Access Violation When Database Is in Use Q293292 KB293292 November 6, 2003
293223 FIX: Problems Saving DTS Packages to Visual Basic Files Using the DTS User Interface Q293223 KB293223 November 6, 2003
293166 FIX: Parallel Modification Operation May Spin Trying to Release Locks Q293166 KB293166 November 6, 2003
292755 FIX: Full-Text Queries May Return "Unspecified Error" Error Message Q292755 KB292755 November 6, 2003
292753 FIX: Some Object Browser Folders Cannot Be Scripted Q292753 KB292753 November 6, 2003
292737 FIX: Drag and Drop Object Type Node to the Editor in Query Analyzer Returns Error Message Q292737 KB292737 November 6, 2003
292456 FIX: GetColumnInfo Returns Incorrect Column Information Q292456 KB292456 November 6, 2003
292455 FIX: OSQL Does Not Display Column Names for Query Q292455 KB292455 November 6, 2003
292454 FIX: Update Queries with OpenXML Table Aliases Cause Access Violation Q292454 KB292454 November 6, 2003
291851 FIX: Merge Replication Stored Procedures May Be Scripted Incorrectly When an Article is in Two Publications Q291851 KB291851 November 6, 2003
291780 FIX: DTS Transfer Objects May Fail if Dependent Objects Are Not in Alphabetical Order Q291780 KB291780 November 6, 2003
291277 FIX: ServerNet II Library Does Not Display if Giganet Driver is Not Available Q291277 KB291277 November 6, 2003
291275 FIX: sp_replsetoriginator May Generate Access Violation in Bidirectional Transactional Replication Q291275 KB291275 November 6, 2003
291273 FIX: SQLMail Incorrectly Uses Default Mail Profile Q291273 KB291273 November 6, 2003
291223 FIX: sql_variant Data Replicates Incorrectly After Conflict Is Resolved in a Queued Updating Subscriber Scenario Q291223 KB291223 November 6, 2003
290921 FIX: UPPER and LOWER Functions Return Metadata Length as if DBCS Were Used Q290921 KB290921 November 6, 2003
290918 FIX: Incorrect Behavior of LIKE [-] When Using an Index Q290918 KB290918 November 6, 2003
290917 FIX: Incorrect Identity Values After Failed Unique Index Creation Q290917 KB290917 November 6, 2003
290814 FIX: xp_readmail Leaks Memory if Message Contains Attachment Q290814 KB290814 November 6, 2003
290642 FIX: Exists with Full Outer Join May Generate Access Violation Q290642 KB290642 November 6, 2003
290592 FIX: Full-Text Rows Missing After Crawl Due to Full Disk Q290592 KB290592 November 6, 2003
290413 FIX: DB-Library sp_cursor Fails with Error Message 16933 if Bracketed Identifiers are Passed with the Tablename Parameter Q290413 KB290413 November 6, 2003
290353 FIX: Updating View Based on Partitioned View May Result in Assertion Q290353 KB290353 November 6, 2003
290085 FIX: Extended Stored Procedure "xp_logevent" Generates an Access Violation When Given Too Large a Parameter Q290085 KB290085 November 6, 2003
290083 FIX: FOR XML EXPLICIT: Conflict Attribute in xmltext Is Not Overwritten if xmltext Contains DBCS Q290083 KB290083 November 6, 2003
290082 FIX: Failed Server-Side Retail Assertion in Merge Replication with SQL Server CE Clients Q290082 KB290082 November 6, 2003
290080 FIX: Assert Occurs When You Try to Alter a Database and Trace Flag 902 is Enabled Q290080 KB290080 November 6, 2003
290058 FIX: SQL Mail Procedures May Intermittently Fail with Error 0x8004010f Q290058 KB290058 November 6, 2003
289880 FIX: SQL Server Assertion Failure Occurs if Recovery Model of TempDB is not SIMPLE Q289880 KB289880 November 6, 2003
289878 FIX: Locking on File Header Pages Is Reported Incorrectly Q289878 KB289878 November 6, 2003
289851 FIX: Creating a New Unique Named Pipe Alias Displays the Default Pipe Value Instead of the Entered Value Q289851 KB289851 November 6, 2003
289691 FIX: Sysprocesses Is Incorrectly Showing Rollback Status Even Though the Transaction Is Not Rolling Back Q289691 KB289691 November 6, 2003
289667 FIX: Executing Isqlw.exe with -i -o Parameters May Insert Text Into the Input SQL Script Q289667 KB289667 November 6, 2003
289551 FIX: Generate SQL Script in Enterprise Manager Generates Scripts in Wrong Sequence if the Table has User-Defined Function as Computed Column Q289551 KB289551 November 6, 2003
289472 FIX: SQLAgent Exception Occurs when the System Maintains 613, 2661 or 4709 Jobs Q289472 KB289472 November 6, 2003
289149 FIX: A Query That Uses Hash Match Teams May Fail with 8630 Error Message Q289149 KB289149 November 6, 2003
288996 FIX: System View Sysopentapes Can Be Dropped Q288996 KB288996 November 6, 2003
288957 FIX: Multiple Calls To a User Defined Function Within an Aggregate Function May Return Incorrect Results Q288957 KB288957 November 6, 2003
288340 FIX: Errors in Transform Failure Function Are Logged When They Should Be Ignored Q288340 KB288340 November 6, 2003
288188 FIX: DTS Package Reports Success When FTP Task Doesn't Transfer All Files Q288188 KB288188 November 6, 2003
288174 FIX: Modifying a Table with DRI Cascade That Is Involved in an Indexed View May Cause Msg 8624 Q288174 KB288174 November 6, 2003
287713 FIX: Problems with DTS UI Help Topics Q287713 KB287713 November 6, 2003
287606 FIX: Enterprise Manager Reports Table Sizes That Are Inconsistent as Compared to sp_spaceused Q287606 KB287606 November 6, 2003
279296 FIX: Using ALTER TABLE to Change Column Type Can Result in Unexpected NULL Values on INSERT Q279296 KB279296 November 6, 2003
274773 FIX: If You Change Windows Security to Windows/SQL Security the SA Password is Blank Q274773 KB274773 November 6, 2003
274224 FIX: Using SQL Server 2000 Merge Modules May Result in Confusing Message Q274224 KB274224 November 6, 2003
328694 FIX: Disconnect and Disconnect All Actions in Query Analyzer Do Not Close All Connections to SQL Server Q328694 KB328694 November 5, 2003
322853 FIX: SQL Server Grants Unnecessary Permissions or an Encryption Function Contains Unchecked Buffers Q322853 KB322853 November 5, 2003
321332 FIX: Full-Text Searches for Data That is Enclosed in Parenthesis() Inside HTML Tags is Not Being Returned Q321332 KB321332 November 5, 2003
321093 FIX: SEEK Uses Only First Column of Compound Index Which Results in a Sub-Optimal Plan Q321093 KB321093 November 5, 2003
320506 FIX: Parameters Not Pushed to Subqueries May Cause Suboptimal Plan Q320506 KB320506 November 5, 2003
308865 FIX: Logreader Fails with "...Could Not Execute Sp_replcmds.." Error Message Q308865 KB308865 November 5, 2003
301579 FIX: "Unspecified error" Raised When Working with DTS Packages on Localized SQL Server 2000 Q301579 KB301579 November 5, 2003
300272 FIX: Transfer of a View that Contains a UDF by Using DTS Export Data Fails with Error 208 Q300272 KB300272 November 5, 2003
300145 FIX: Merge Replication Conflict Viewer Resolves Data Conflicts Incorrectly Q300145 KB300145 November 5, 2003
300056 FIX: Merge Metadata Cleanup May Cause Subscriber Transaction Log to Grow Quickly Q300056 KB300056 November 5, 2003
300037 FIX: Error 229 "EXECUTE permission denied on object xp_mapdown_bitmap" on Merge Published Table Q300037 KB300037 November 5, 2003
299914 FIX: Executing MAX or MIN Aggregate Functions on Column with Hypothetical Clustered Index May Result in CPU SPIN Q299914 KB299914 November 5, 2003
299865 FIX: DMO BulkCopy Fails to Copy Data When Column Names Contain the Space Character Q299865 KB299865 November 5, 2003
299857 FIX: Trigger May Not Fire if Query Plan Uses CONSTANT SCAN Operator Q299857 KB299857 November 5, 2003
299787 FIX: Skewed Replication Statistics in Output File When Running Agent Continuously Q299787 KB299787 November 5, 2003
299649 FIX: Merge Replication Agent Fails with Error Message: "Unable to replicate a view or function" Q299649 KB299649 November 5, 2003
299620 FIX: Cannot Use a Profile Name Longer Than 32 Characters with SQL Mail Q299620 KB299620 November 5, 2003
299602 FIX: Extended Stored Procedure xp_sendmail Does Not Handle DBCS Correctly Q299602 KB299602 November 5, 2003
299544 FIX: Correlated Subquery Containing UNION ALL May Cause Access Violation Q299544 KB299544 November 5, 2003
299543 FIX: ActiveX Transformation Function Not Triggered If LastRow Option in DTS Transform Data Task Is Less Than or Equal to Actual Number of Source Table Rows Q299543 KB299543 November 5, 2003
299470 FIX: SELECT with Distinct and Self Loop Join May Cause 1203 Error Message Q299470 KB299470 November 5, 2003
299466 FIX: Running Stack Dumper Causes Memory Leak of Virtual Bytes Q299466 KB299466 November 5, 2003
299462 FIX: Dump of Internal Structures while Users Connect or Disconnect May Cause Access Violation Q299462 KB299462 November 5, 2003
299448 FIX: Subquery That References Table with No Statistics and Returns Empty Result Set May Cause AV Q299448 KB299448 November 5, 2003
299366 FIX: Calling Remote Stored Procedure Inside Local Stored Procedure While Passing Text Parameter Causes AV Q299366 KB299366 November 5, 2003
299361 FIX: Timestamp Column Truncated When Replicating with Sybase Using Merant OLEDB Provider Q299361 KB299361 November 5, 2003
299323 FIX : DBCC CHECKTABLE May Fail if Corruption Exists in Indexes Q299323 KB299323 November 5, 2003
299285 FIX: Query with Complex Correlated Subquery May Cause Unexpected Results in Aggregate Functions Q299285 KB299285 November 5, 2003
298951 FIX: Snapshot Agent for Merge Publication May Fail with 107 Error Q298951 KB298951 November 5, 2003
298835 FIX: Delete From Partition View that Contains Text or Image Data May Cause Error Q298835 KB298835 November 5, 2003
298830 FIX: Error Message: "Cannot Start 'Config XML support in IIS for SQL Server'" Q298830 KB298830 November 5, 2003
298803 FIX: Coalesce with Subquery May Generate an Access Violation Q298803 KB298803 November 5, 2003
298689 FIX: Analysis Manager Cube Browser May Fail While You Browse Cube Data Q298689 KB298689 November 5, 2003
295668 FIX: Transaction Replication to DB2 Subscribers Incorrectly Map Tinyint Data Type if You Use DTS to Transform Published Data Q295668 KB295668 November 5, 2003
295644 FIX: Transaction Log Restores May Fail with 3456 Error Q295644 KB295644 November 5, 2003
295627 FIX: Xp_readmail May Cause System to Stop Responding in Windows 95 or Windows 98 Q295627 KB295627 November 5, 2003
295551 FIX: Text Pasted in Query Analyzer Result Window Is Not Visible Q295551 KB295551 November 5, 2003
295466 FIX: Affinity Mask Option in sp_configure Does Not Support 32 Processors Q295466 KB295466 November 5, 2003
295461 FIX: Profiler Fails To Start New Trace When User Environment Variable Has Been Changed Q295461 KB295461 November 5, 2003
295459 FIX: sp_helptext Fails with Invalid Length Parameter Error Q295459 KB295459 November 5, 2003
295325 FIX: Replication in Turkish Collation Fails with Error Message: "Error 21112: '-PollingInterval' is not a valid parameter for the Log Reader Agent" Q295325 KB295325 November 5, 2003
295193 FIX: Merge Module Sqlsvr.msm Fails Validation with ICE03 Q295193 KB295193 November 5, 2003
295120 FIX: OK Button for Changing the Recovery Model or the Compatibility Level in SQL Enterprise Manager is Disabled Q295120 KB295120 November 5, 2003
295048 FIX: Cannot Script Full-Text Indexes for Tables with No Primary Keys Even if Another Unique Index Exists Q295048 KB295048 November 5, 2003
295047 FIX: Full-Text Indexes Are Scripted Before Table Indexes Causing DB Creation Script Failure Q295047 KB295047 November 5, 2003
295046 FIX: OLE Automation Fails When Calling ADODB.Connection Methods Q295046 KB295046 November 5, 2003
295045 FIX: SELECT DISTINCT Returns Incorrect Results in SQL_Latin1_General_Pref_Cp1_CI_AS Collation Q295045 KB295045 November 5, 2003
295023 FIX : "SET ROWCOUNT" May Cause Data to be Unreadable Q295023 KB295023 November 5, 2003
295006 FIX : OSQL Utility Returns Incorrect Error Message Q295006 KB295006 November 5, 2003
294985 FIX: SQL Server Agent Proxy Account Not Cleaned Up When Instance Is Uninstalled Q294985 KB294985 November 5, 2003
294956 FIX: Enterprise Manager May Cause Access Violation When You Edit a DTS Package with Long User Name Q294956 KB294956 November 5, 2003
294872 FIX: Update on a Table with INT and BIT Columns May Zero Out INT Columns Q294872 KB294872 November 5, 2003
294828 FIX: Passing a Large Command Line String to Query Analyzer Results in Assertion Failed Q294828 KB294828 November 5, 2003
294783 FIX: Addition of a Column to an Incrementally Added Article Prior to Snapshot Generation Fails Q294783 KB294783 November 5, 2003
293761 FIX: Dynamic Filtered Tables Do Not Replicate Data From Joined Tables to SQL Server CE Subscribers Q293761 KB293761 November 5, 2003
293484 FIX: Incorrect Record is Deleted or Updated When a Clustered Index is in Descending Order Q293484 KB293484 November 5, 2003
293430 FIX: SEM New SQL Server Registration Using Long Server Name Fails with Access Violation Q293430 KB293430 November 5, 2003
293328 FIX: Update Query Does Not Execute Correctly Q293328 KB293328 November 5, 2003
293155 FIX: BCP with Format File and -R Parameter Ignores Regional Settings Q293155 KB293155 November 5, 2003
292761 FIX: xp_startmail Error Message Does Not Indicate Problem Q292761 KB292761 November 5, 2003
291276 FIX: Startup Stored Procedures Don't Execute with AWE Support Enabled Q291276 KB291276 November 5, 2003
291274 FIX: Correlated Subquery on Partitioned Views with Text Operations May Cause Access Violation Q291274 KB291274 November 5, 2003
290916 FIX: fn_virtualfilestats Skips the Last File Q290916 KB290916 November 5, 2003
290739 FIX: Iterating Through SQL Mail Messages Using Extended Procedures Takes Longer in SQL Server 2000 Q290739 KB290739 November 5, 2003
290210 FIX: Removal of Full-Text Index May Incorrectly Remove Rows From sysdepends System Table Q290210 KB290210 November 5, 2003
290077 FIX: DTS Scheduled Job Does Not Complete After First Run Q290077 KB290077 November 5, 2003
289893 FIX: Current Row's Time if Empty Is Replaced by Previous Row's Time in Bulk Copy Q289893 KB289893 November 5, 2003
288330 FIX: FTP Task in DTS Deletes File from the Destination Folder After the Package Completes Execution Q288330 KB288330 November 5, 2003
281293 FIX: SQL Mail 2000 Needs Microsoft Outlook 2000 Client Q281293 KB281293 November 5, 2003
276329 FIX: Complex Distinct or Group By Query Can Return Unexpected Results with Parallel Execution Plan Q276329 KB276329 November 5, 2003
318000 FIX: Various Problems When You Call Transactional COM+ Components from ASP.NET Q318000 KB318000 November 4, 2003
308835 FIX: Cannot Install Service Pack 1 to a Tools-Only Installation If MSDE Is Installed Q308835 KB308835 October 31, 2003
308801 FIX: DTSRUN Fails with Errors If the Arguments Have Multiple Space Characters Between Them Q308801 KB308801 October 31, 2003
308718 FIX: SP1 Regression: Running FREETEXT Queries May Cause a MS Search Resource Leak Q308718 KB308718 October 31, 2003
307533 FIX: Distribution Agent May Encounter Error 8115 in the Sp_MSadd_distribution_history Stored Procedure Q307533 KB307533 October 31, 2003
306853 FIX: SQL Server Enterprise Manager Restore Database Wizard Restores Database to Different Location or Name Q306853 KB306853 October 31, 2003
301060 FIX: Import of Text File Results in Error "Column Delimiter not found" Q301060 KB301060 October 31, 2003
298832 FIX: Uppercase Characters are not Sorted Before Their Corresponding Lowercase Characters When You Use the Nocasepref Sort Order Q298832 KB298832 October 31, 2003
297271 FIX: Point in Time Recovery May Recover Database if the Transaction Log That is Applied Does Not Contain Any Transactions Q297271 KB297271 October 31, 2003
296456 FIX: Full Text Query May Return 0 Rows When Valid Results are Present Q296456 KB296456 October 31, 2003
296045 FIX: Merge Snapshot Agent Fails with Error 50007: "Too many table names in the query. The maximum allowable is 256." Q296045 KB296045 October 31, 2003
295034 FIX: Microsoft Search Service May Cause 100% CPU Usage if BUILTIN\Administrators Login Is Removed Q295034 KB295034 October 31, 2003
293758 FIX: Nullability Changes Not Handled by SQL Server with Linked Server Queries to DB2 Q293758 KB293758 October 31, 2003
290915 FIX: CREATE for Existing Object with IDENTITY Column Causes Duplicate IDENTITY Values Q290915 KB290915 October 31, 2003
290646 FIX: SQLColAttribute Returns Incorrect Table Attributes When Table Name Contains a Period Q290646 KB290646 October 31, 2003
286788 FIX: Server Side Cursor May Return Incorrect Results Q286788 KB286788 October 31, 2003
286737 FIX: FetchBufferSize Greater than Certain Number Fails to Transfer all Rows and Does Not Return an Error Q286737 KB286737 October 31, 2003
281287 FIX: Msg 8964 on Index with IGNORE_DUP_KEY and Row Has a Text Column Q281287 KB281287 October 31, 2003
280744 FIX: Update Query Returns Error 1903 if Temporary Composite Index Over 900 Bytes Q280744 KB280744 October 31, 2003
278978 FIX: SELECT May Not Return All Rows if It Contains a Large Number of Values in an IN Clause on a NUMERIC Column Q278978 KB278978 October 31, 2003
275901 FIX: SQL RPC That Raises Error Will Mask @@ERROR with Msg 7221 Q275901 KB275901 October 31, 2003
275618 FIX: Cannot Set SQLServerAgent Password to More Than 16 Characters in Enterprise Manager Q275618 KB275618 October 31, 2003
271945 FIX: SQL Agent Appends Garbled Characters to Output File Q271945 KB271945 October 31, 2003
267953 FIX: Interleaving Prepare And Adhoc Execute of Query May Cause Recompile Loop Q267953 KB267953 October 31, 2003
260182 FIX: Unable to Restore to a Point in Time in First Transaction Log Backup Q260182 KB260182 October 31, 2003
259304 FIX: DTS Fails to Import Last Row If There is No Last Row Terminator Q259304 KB259304 October 31, 2003
319701 FIX: SQL Enterprise Manager RESTORE Msdb Leaves Database in Loading State and Does Not Apply Differential or Log Backups Q319701 KB319701 October 30, 2003
319698 FIX: Transform Data Task Might Stop Responding (hang) While Importing Data From Text File Q319698 KB319698 October 30, 2003
319697 FIX: SQL Enterprise Manager Restore to Point in Time Does Not Stop at Requested Time and the Database is Left in a Loading State Q319697 KB319697 October 30, 2003
308758 FIX: SQL Agent Mail May Cause E-mail to Be Written to Root Directory of Source Mailbox Q308758 KB308758 October 30, 2003
308745 FIX: SET NOEXEC OFF May Not Execute If Included in Same Batch as SET NOEXEC ON Q308745 KB308745 October 30, 2003
295378 FIX: SQLAgent Job with Recurring Schedule is Disabled Upon Completion of the Schedule for the Day Q295378 KB295378 October 30, 2003
294388 FIX: Reading Perflib Registry Values Terminates SQL Server Startup with Fatal Exception Q294388 KB294388 October 30, 2003
287401 FIX: Unable to Use GOTO in an Execute SQL Task of a DTS Package Q287401 KB287401 October 30, 2003
281843 FIX: SQLDMO GetProcessInputBuffer Returns Incorrect Result Q281843 KB281843 October 30, 2003
302828 FIX: DTS Fails to Transfer Rows When a Non-Sysadmin User Opens Packages from T-SQL with Xp_cmdshell Q302828 KB302828 October 29, 2003
301642 FIX: SQL Server Error Message 6002 Is Returned with an Incorrect Severity Q301642 KB301642 October 29, 2003
295053 FIX: OPENXML May Leak Worktables in Memory Q295053 KB295053 October 29, 2003
293636 FIX: Invoking SQL-DMO Methods By Using "By Reference" Parameters May Cause a Memory Leak Q293636 KB293636 October 29, 2003
288426 FIX: Alerts Triggered Incorrectly When Security Auditing is Enabled Q288426 KB288426 October 29, 2003
282243 FIX: Incorrect Results with Join of Column Converted to Binary Q282243 KB282243 October 29, 2003
308834 FIX: Incorrect Display of Error Log in Enterprise Manager Q308834 KB308834 October 28, 2003
295032 FIX: Job Step Fails if First INSERT of Batch Job Encounters a Msg 3604 Error Q295032 KB295032 October 28, 2003
285870 FIX: Update With Self Join May Update Incorrect Number Of Rows Q285870 KB285870 October 28, 2003
280747 FIX: UPDATE Statement on a Clustered Index Key Fails with Error 547 Q280747 KB280747 October 28, 2003
279015 FIX: SQL Server Does Not Run RESTOREVERIFYONLY When Scheduling a Back Up in SQL Enterprise Manager Q279015 KB279015 October 28, 2003
328318 FIX: Open Generations May Not Close Under Some Stress Conditions with SQL Server CE Subscribers Q328318 KB328318 October 17, 2003
310617 FIX: Sp_reset_connection Does Not Reset the Rowcount Settings for the DELETE and UPDATE Statements Q310617 KB310617 October 17, 2003
310472 FIX: Incorrect Results with Uncorrelated Subquery If You Use an Aggregate Function and NULL Values in the WHERE Clause Q310472 KB310472 October 17, 2003
308866 FIX: SQL Server 2000 Setup Terminates Unexpectedly if You Install Chinese (Hong Kong) Locale Q308866 KB308866 October 17, 2003
308817 FIX: Stored Procedure That Creates Temp Table [#a.b.c.d.e] Causes Access Violation Q308817 KB308817 October 17, 2003
308797 FIX: Mssdmn.exe Process Uses All Available Memory When You Populate Full-Text Index Q308797 KB308797 October 17, 2003
308795 FIX: CheckDB May Not Fix Error 8909 or Error 8905 Q308795 KB308795 October 17, 2003
308788 FIX: Rebuildm Truncates Virtual Server Name of 15 Characters Q308788 KB308788 October 17, 2003
308787 FIX: Full-Text Failures Occur Because of SQL Server Account Change Q308787 KB308787 October 17, 2003
308784 FIX: DATABASEPROPERTYEX Function Reports Incorrect Status After You Restore Database and Set the Database to OFFLINE Q308784 KB308784 October 17, 2003
308778 FIX: CHECKDB Causes an Access Violation to Occur When TEXTPTR Is Concurrently Set to Null Q308778 KB308778 October 17, 2003
308777 FIX: SQL Mail Profile Name in SQL Enterprise Manager Does Not Handle Information Over 132 Characters Q308777 KB308777 October 17, 2003
308775 FIX: Indexed Computed Column Based on Text/Image Column Causes AV When You Run DBCC CHECKDB Q308775 KB308775 October 17, 2003
308774 FIX: Sp_change_primary_role May Store Transaction Log Backup in the Wrong Location Q308774 KB308774 October 17, 2003
308766 FIX: Enabling TCP/IP Through the Server Network Utility May Not Enable the Server to Listen on TCP/IP Q308766 KB308766 October 17, 2003
308763 FIX: TOP_N_BY_RANK Argument May Not Return Top N by Rank Q308763 KB308763 October 17, 2003
308755 FIX: SQL Server May Stop Responding (hang) During Snapshot Backup of More Than One Database Q308755 KB308755 October 17, 2003
308751 FIX: SQL Profiler May Return Unavailable Error Messages for a Remote Output File Q308751 KB308751 October 17, 2003
308749 FIX: Access Violation Occurs When You Execute DBCC SHOWCONTIG Followed by Any System Function Q308749 KB308749 October 17, 2003
308746 FIX: Cannot Attach Database When You Change the Database Name and Use ENTER Key in the Attach Database Dialog Box Q308746 KB308746 October 17, 2003
308723 FIX: Access Violation Occurs When You Use SQL Profiler or SQL Trace Q308723 KB308723 October 17, 2003
308716 FIX: Index Is Corrupt When Full-Text Catalog Population Is Interrupted on a Cluster Q308716 KB308716 October 17, 2003
305147 FIX: An Access Violation Occurs in CEsExec::ReleaseInterfaces If You Insert NTEXT Column with "Insert - Exec" Q305147 KB305147 October 17, 2003
304711 FIX: SQL Server 2000 Service Pack 1 Setup Fails with No Errors Q304711 KB304711 October 17, 2003
303224 FIX: Use of the Copy Database Wizard to Copy a Database Disables Full-Text Indexing on the Source Database Q303224 KB303224 October 17, 2003
300391 FIX: Profiler Replay Output File Does not Show Events When Looking at Properties Q300391 KB300391 October 17, 2003
300388 FIX: SQL Profiler Stops Responding When Saving Output to Hard Disk That Is Out of Space Q300388 KB300388 October 17, 2003
300380 FIX: Intense Database Backup Stress Causes BackupSync to Generate an Assertion when Releasing Memory Q300380 KB300380 October 17, 2003
300194 FIX: Error 644 Using Two Indexes on a Column with Uppercase Preference Sort Order Q300194 KB300194 October 17, 2003
300180 FIX: sp_MSexpandnotbelongs May Be Called at Publisher Due to Invalid Evaluation of Join Filter Q300180 KB300180 October 17, 2003
299299 FIX: Export of Specific DBCS to Excel Fails When Text Type is Used Q299299 KB299299 October 17, 2003
296386 FIX: AUTO-SHRINK Option or DBCC SHRINKDATABASE May Slow Down SQL Server 2000 Performance Q296386 KB296386 October 17, 2003
294938 FIX: Exception Error Caused by WHERE Clause with OR Logical Operator with Third Party OLEDB Provider Q294938 KB294938 October 17, 2003
290175 FIX: SQL Server ODBC Driver Does Not Transfer Return Values from Stored Procedures Q290175 KB290175 October 17, 2003
287405 FIX: Access Violation Occurs When You Use the Server Network Utility Without Administrator Privileges on Computer Q287405 KB287405 October 17, 2003
287167 FIX: Some Full-Text Search Failures Do Not Set @@ERROR Q287167 KB287167 October 17, 2003
286749 FIX: Table Creation, Row Insertion, and Index Creation Inside Transaction, Followed By Addition of Constraint May Result in Consistency Errors Q286749 KB286749 October 17, 2003
286119 FIX: Incorrect Behavior in SQL Profiler Event Generation Q286119 KB286119 October 17, 2003
283825 FIX: DBCC DBREINDEX Does Not Keep Original Fillfactor Q283825 KB283825 October 17, 2003
282286 FIX: DBCC INDEXDEFRAG May Leave a Transaction Open Which Can Cause the Log to Grow Large Q282286 KB282286 October 17, 2003
281409 FIX: BULK INSERT Fails with BATCHSIZE=1, FIRE_TRIGGERS, and TABLOCK Q281409 KB281409 October 17, 2003
281238 FIX: xp_findnextmsg Does Not Return a Value for @msg_id Parameter on Output Q281238 KB281238 October 17, 2003
280720 FIX: xp_sendmail Generates UNICODE CSV File Format Q280720 KB280720 October 17, 2003
279338 FIX: DBCC CHECKCONSTRAINTS Does Not Handle Names with Special Characters Q279338 KB279338 October 17, 2003
279080 FIX: Sqldiag Utility Exits if SQL Server Service Is Not Started Q279080 KB279080 October 17, 2003
272737 FIX: SQL Profiler Generates Error when Reading Trace Files that Exceed 1023 SPIDs Q272737 KB272737 October 17, 2003
327969 FIX: Only System Administrators Can Perform Ad Hoc Queries in SQL Server Service Pack 3 Q327969 KB327969 October 16, 2003
317261 FIX: Setup to Named Instance of SQL Server 2000 Fails with General Network Error Q317261 KB317261 October 16, 2003
312948 FIX: SQL Server Access Violation During SSL Connection Q312948 KB312948 October 16, 2003
310640 FIX: Access Violation on OPENXML XPath Query with Large Text Node Q310640 KB310640 October 16, 2003
310473 FIX: Open of DTS Package Fails with Type Mismatch Error Message Q310473 KB310473 October 16, 2003
308888 FIX: sp_MSdependencies May Run for a Long Time to Script Tables and Views Q308888 KB308888 October 16, 2003
308872 FIX: Unable to Overwrite Read-Only Dynamic Snapshot Pre_snapshot_script Q308872 KB308872 October 16, 2003
308860 FIX: SQLDMO ExportData Method Fails If There Is a Space in the Database Name Q308860 KB308860 October 16, 2003
308837 FIX: AV When Selecting from View Based on Multiple Other Views in Compatibility Mode 70 Q308837 KB308837 October 16, 2003
308826 FIX: User Defined Function Returns Incorrect Result for SELECT Statement with DEFAULT Keyword That References a View Q308826 KB308826 October 16, 2003
308819 FIX: Merge Replication Snapshot Agent Fails with Error "Line 1: Incorrect syntax near 'as'." Q308819 KB308819 October 16, 2003
308811 FIX: SELECT DISTINCT Operation Generates 1505 Error Message Q308811 KB308811 October 16, 2003
308810 FIX: Select Query That Compares a Tinyint to a Converted Int in the Where Clause Fails to Find Valid Row Q308810 KB308810 October 16, 2003
308806 FIX: Database Files Are Created in the Wrong Folder During the Creation of a New Database on a Named Instance Q308806 KB308806 October 16, 2003
308804 FIX: Distribution Agent Fails with "Invalid Distribution Command" Error Message Q308804 KB308804 October 16, 2003
308803 FIX: SQL Server Ignores ORDER BY When You Use ROLLUP and Only One Row Meets the Search Criteria Q308803 KB308803 October 16, 2003
308800 FIX: Optimizer Chooses Poor Plan for a Query That Contains a Substring Function and a Comparison Operator Q308800 KB308800 October 16, 2003
308789 FIX: SQL DMO's SQLBackup Method Fails with Error Message 3206 Q308789 KB308789 October 16, 2003
308772 FIX: Unicode Wildcard Comparisons with Latin1_general_CI_AS May Return Incorrect Results Q308772 KB308772 October 16, 2003
308765 FIX: Spurious Merge Conflict After Metadata Proxy Failure Q308765 KB308765 October 16, 2003
308761 FIX: Access Violation from Query with Multiple UNIONs Within Parenthesis Q308761 KB308761 October 16, 2003
308760 FIX: SQL Server Optimizer Ignores Index Hint for UPDATE If One or More Non-Clustered Indexes Exist Q308760 KB308760 October 16, 2003
308757 FIX: Select from Nested Views May Not Return Result After SQL Server Updates Statistics Q308757 KB308757 October 16, 2003
308756 FIX: Use of User-Defined Data Types from Two Different Databases in a Single Batch Causes Infinite Recompile Q308756 KB308756 October 16, 2003
308743 FIX: SQL Server Merge Replication Agent Fails with Error Message 2812: "Could not find stored procedure" Q308743 KB308743 October 16, 2003
308740 FIX: Incorrect Per-Article Contents BCP for Dynamic Snapshot Q308740 KB308740 October 16, 2003
308736 FIX: Incorrect Results Returned When Query Compares Large Precision and Scale Decimal Value with Integer Q308736 KB308736 October 16, 2003
308732 FIX: Missing Views in Transactional Replication Q308732 KB308732 October 16, 2003
308727 FIX: Performance Issues with Concurrent Replication Agents and/or High Replication Monitor Refresh Setting Q308727 KB308727 October 16, 2003
308725 FIX: Replication of Table with Computed Column Defined as the Primary Key Results in Error Message 4817 Q308725 KB308725 October 16, 2003
308715 FIX: SQL Profiler Trace Has Extraneous Values in Mode Column Q308715 KB308715 October 16, 2003
308714 FIX: Attach of a Subscription to a Database with an Embedded Period Fails with Error Message 7202 Q308714 KB308714 October 16, 2003
308436 FIX: ANSI Outer Join is Changed into an Inner Join in INSTEAD OF Trigger Q308436 KB308436 October 16, 2003
308370 FIX: Query Containing LIKE NULL May Not Return Correct Results Q308370 KB308370 October 16, 2003
307946 FIX: SQL Profiler Truncates Seconds and Milliseconds for Datetime RPC Parameter Q307946 KB307946 October 16, 2003
305066 FIX: Merge Agent Access Violation Occurs with Large Batch Size and Several Columns Q305066 KB305066 October 16, 2003
304551 FIX: Merge Publishing with Vertical Filters Results in Nonconvergence Q304551 KB304551 October 16, 2003
304532 FIX: Snapshot Agent Reports "Must Declare the Variable" on Initial Snapshot for Merge Replication Q304532 KB304532 October 16, 2003
303114 FIX: Memory and Handle Leak When You Use MSXML Inside SQL Server Stored Procedure Q303114 KB303114 October 16, 2003
302675 FIX: Delete on Nonindexed Column Fails with Error 1203 Q302675 KB302675 October 16, 2003
300383 FIX: Initial Snapshot Fails with 8115 Error "Arithmetic Overflow Error Converting Expression to Data Type Int" Q300383 KB300383 October 16, 2003
300042 FIX: DTS Transfer Reports Error "Non-whitespace characters in row" Even Though All Rows are Imported From Text File Q300042 KB300042 October 16, 2003
299675 FIX: International Characters (DBCS) Corrupted in the Exported XML File from Meta Data Services Q299675 KB299675 October 16, 2003
299539 FIX: Merge Agent Failure That Occurs with SQL Server Initial Snapshot Delivery Is Not Recognized in Subsequent Run of the Merge Agent Q299539 KB299539 October 16, 2003
297369 FIX: Incorrect Error Occurs When You Add Merge Article to a Publication with NO SYNC Subscriber Q297369 KB297369 October 16, 2003
297063 FIX: ORDER BY on "Numeric" Data Type May Return Incorrect Data Q297063 KB297063 October 16, 2003
296438 FIX: Error Message 1205 Is Not Returned with the Localized Message Text Q296438 KB296438 October 16, 2003
295030 FIX: Index Tuning Wizard Execution May Generate Floating Point Exception Q295030 KB295030 October 16, 2003
292637 FIX: Unicode Character String Longer Than Seven Bytes in a LIKE Clause Is Truncated in Execution Plan Q292637 KB292637 October 16, 2003
291376 FIX: Cannot Use Dynamic SQL Statements Within OPENQUERY Q291376 KB291376 October 16, 2003
290055 FIX: Error Message: "The process can not add message to message queue. The step failed" Q290055 KB290055 October 16, 2003
287234 FIX: No Vertical Scroll Bar in DTS Dynamic Properties Task Properties Dialog Box Q287234 KB287234 October 16, 2003
286773 FIX: DTS FTP Task Does Not Behave as Expected if Destination Is Out of Space or the Destination File Exists Q286773 KB286773 October 16, 2003
286756 FIX: DTS Source Logging Fails if Source Contains Unmapped Columns Q286756 KB286756 October 16, 2003
286268 FIX: User and Owner Passwords are Dimmed When You Save a Package as a File By Using DTSWIZ Q286268 KB286268 October 16, 2003
286249 FIX: Complex Update Statement Returns 8624 Internal SQL Server Error Q286249 KB286249 October 16, 2003
286234 FIX: Suboptimal Execution Plan on an Indirect UPDATE to an Indexed View Q286234 KB286234 October 16, 2003
285979 FIX: Changing Autostart Options for Named Instances Change Autostart Settings for the Default Instance Q285979 KB285979 October 16, 2003
285952 FIX: NO_TRUNCATE May Be Added to Backup Log Statement when You Perform a Log Backup from SEM Q285952 KB285952 October 16, 2003
285544 FIX: Dividing 0 by a Negative Decimal or Numeric Number Results in -0 Q285544 KB285544 October 16, 2003
282982 FIX: Suboptimal Performance Using a Cursor to Update a Heap Involved in an Indexed View Q282982 KB282982 October 16, 2003
282749 FIX: Deadlock Information Reported with SQL Server 2000 Profiler Is Incorrect Q282749 KB282749 October 16, 2003
281239 FIX: xp_findnextmsg Returns Multiple Rows When No Parameters Are Specified Q281239 KB281239 October 16, 2003
279804 FIX: INSERT Statement Incorrectly Conflicts with Constraint Q279804 KB279804 October 16, 2003
279659 FIX: SQL Server 2000 Takes Much Longer to Compile the Query Against Local Partitioned View Than SQL Server 7.0 Q279659 KB279659 October 16, 2003
276043 FIX: Error Message 5180 May Occur When You Retrieve Text or Image Data Q276043 KB276043 October 16, 2003
323553 FIX: Query with OUTER JOINs May Neglect Built-in Function in WHERE Clause Q323553 KB323553 October 9, 2003
320603 FIX: Distribution Agent May Experience an Access Violation in a Republisher Topology Q320603 KB320603 October 9, 2003
316213 FIX: SQLDMO Transfer Operation Truncates Transaction Log of Destination Database Q316213 KB316213 October 9, 2003
309377 FIX: Miscalculation of CPU Time Occurs If SQL Server Uses a New Thread to Execute a Batch on a Connection That Already Exists Q309377 KB309377 October 9, 2003
308112 FIX: SQL Server May an Encounter Access Violation During a BULK IMPORT Q308112 KB308112 October 9, 2003
306893 FIX: Unexpected Results Occur When You Use a Sort and a Stream Aggregate Q306893 KB306893 October 9, 2003
306816 FIX: ActiveX Controls for Replication May Cause Access Violation with More Than 256 Articles in a Publication Q306816 KB306816 October 9, 2003
306769 FIX: Transaction Log of Snapshot Published Database Cannot Be Truncated Q306769 KB306769 October 9, 2003
306401 FIX: Error Message 7355 "..Inconsistent metadata for a column" Occurs When You Use a Linked Server Q306401 KB306401 October 9, 2003
305573 FIX: Return Code of xp_findnextmsg Changed to 1 Against an Empty Inbox Q305573 KB305573 October 9, 2003
305042 FIX: UPDATE After ALTER TABLE Can Result in Unexpected Data to Added Columns Q305042 KB305042 October 9, 2003
304703 FIX: Pull Subscribers Experience Non-Convergence After Running sp_mergecleanupmetadata Against a Published Database Q304703 KB304703 October 9, 2003
304658 FIX: Distribution Task Encounters Syntax Error During Application of Initial Snapshot Q304658 KB304658 October 9, 2003
304519 FIX: Nonclustered Indexes Rebuilt For CREATE UNIQUE CLUSTERED INDEX ... WITH DROP_EXISTING Query Q304519 KB304519 October 9, 2003
304222 FIX: Merge Replication Non-Convergence Occurs with Local Subscribers when Published Table has 32 or More Columns Q304222 KB304222 October 9, 2003
303640 FIX: Latch Timeout Warnings Appear in Error Log and Slow SQL Server Response Occurs with AWE Enabled Q303640 KB303640 October 9, 2003
303042 FIX: Spanish VSwitch Causes Setup to Fail Q303042 KB303042 October 9, 2003
302825 FIX: Complex Join Query with Views and Redundant Tables May Cause Error 8623 Q302825 KB302825 October 9, 2003
302477 FIX: Cursor Created on Linked Server That Requests Meta-Data May Cause Handled Access Violation Q302477 KB302477 October 9, 2003
300414 FIX: SQL Mail Operations May Lead to Failures and Memory Leaks Q300414 KB300414 October 9, 2003
300412 FIX: Shared Table Lock Incorrectly Held for Lifetime of Transaction Instead of Statement Q300412 KB300412 October 9, 2003
300195 FIX: The SQL-DMO Transfer Method Silently Fails to Copy All Data Q300195 KB300195 October 9, 2003
296849 FIX: BULK INSERT Replaces Current Datetime Column Value with Previous Column Value if Data File Contains All Spaces Q296849 KB296849 October 9, 2003
296465 FIX: Mssearch.exe Memory Leak Occurs When Results Are Not Completely Processed Q296465 KB296465 October 9, 2003
294976 FIX: SQL Profiler Causes Handled Access Violation in SQL Server While Tracing Large Data Q294976 KB294976 October 9, 2003
293232 FIX: Undetected Deadlock Occurs When Lock Owner Is Waiting on CXPACKET Q293232 KB293232 October 9, 2003
286565 FIX: SQL Server Process Terminates Attempting to Reset from an sp_OA Based Batch Q286565 KB286565 October 9, 2003
286253 FIX: Multiple SQL Agent Jobs Launched At The Same Time May Fail With Primary Key Error Message Q286253 KB286253 October 9, 2003
285290 FIX: Complex ANSI Join Query with Distributed Queries May Cause Handled Access Violation Q285290 KB285290 October 9, 2003
284228 FIX: New Trace Flag to Enhance Stored Procedure Replication Q284228 KB284228 October 9, 2003
282416 FIX: Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes a Long Time Q282416 KB282416 October 9, 2003
282279 FIX: Execution of sp_OACreate on COM Object Without Type Information Causes Server Shut Down Q282279 KB282279 October 9, 2003
282229 FIX: SP_OA Procedures Leak Memory and Cause Various Errors Q282229 KB282229 October 9, 2003
279293 FIX: CASE Using LIKE with Empty String Can Result in Access Violation or Abnormal Server Shutdown Q279293 KB279293 October 9, 2003
279183 FIX: Scripting Object with Several Extended Properties May Cause Exception Q279183 KB279183 October 9, 2003
278698 FIX: Exception Access Violation Encountered During Compile of Hash Match Team Plan Q278698 KB278698 October 9, 2003
275900 FIX: Linked Server Query with Hyphen in LIKE Clause May Run Slowly Q275900 KB275900 October 9, 2003
274329 FIX: Optimizer Slow to Generate Query Plan for Complex Queries that have Many Joins and Semi-Joins Q274329 KB274329 October 9, 2003
814572 FIX: SQL Server Does Not Start and an Access Violation Occurs After You Install SQL Server 2000 Service Pack 3 Q814572 KB814572 October 3, 2003
810969 FIX: Log Shipping with SQL Server Authentication Generates Backup and "Out of Sync" Threshold Alerts Q810969 KB810969 October 3, 2003
317956 FIX: A Text Parameter May Return an Error If the SQL Server and the Client Code Pages Are Different Q317956 KB317956 October 3, 2003
317852 FIX: An INSERT May Fail with a 3624 Error Message After a Failed Attempt to Add New Table Column Q317852 KB317852 October 3, 2003
316783 FIX: Log Reader Agent Fails with 18767 and 18762 Error Messages Q316783 KB316783 October 3, 2003
308398 FIX: Execution of Stored Procedure That Uses a TEXT Parameter in Cursor Definition Causes AV Q308398 KB308398 October 3, 2003
308113 FIX: Built-in String Functions Return Incorrect Results Q308113 KB308113 October 3, 2003
305056 FIX: Must Enter DTS Package Name in Subscription Properties Q305056 KB305056 October 3, 2003
303981 FIX: Merge Agent Fails with Error: "Line38: Incorrect syntax near "." " During Initial Snapshot Application Q303981 KB303981 October 3, 2003
303300 FIX: Queue Reader Fails in SQL Server 2000 French Version Q303300 KB303300 October 3, 2003
303218 FIX: Distribution Agent Fails when Applying Snapshot if the Table has a Self-referencing Foreign Key Q303218 KB303218 October 3, 2003
302421 FIX: Query Issued Against Two Instances of the Same Table May Cause an Access Violation Q302421 KB302421 October 3, 2003
301936 FIX: Merge Agent Fails with Access Violation in Replprov.dll if Publication has Horizontal Partitioning Q301936 KB301936 October 3, 2003
300607 FIX: Network Interface Bottleneck on Large SMP Systems Q300607 KB300607 October 3, 2003
300500 FIX: Server Name is not Being Populated on the Client Side (UI or File) in SQL Profiler Q300500 KB300500 October 3, 2003
300494 FIX: Profiler Can Only Capture 1 GB File Size for SQL Server Activities Q300494 KB300494 October 3, 2003
300480 FIX: OPENXML WITH TableName Statement May Return Incorrect Result if Datatype is DECIMAL Q300480 KB300480 October 3, 2003
299935 FIX: Attempt to Set SQL Server Startup Account to SQL Server Login without Rights Gives the Login Sysadmin Privileges Q299935 KB299935 October 3, 2003
299915 FIX: Large SQL Statement Fails When Using 512-Byte Packet Size Q299915 KB299915 October 3, 2003
299685 FIX: Aborting a Parallel Index Creation May Result in Error 602 Q299685 KB299685 October 3, 2003
299575 FIX: SELECT Joining Table with a Complex Subquery Having an IN clause in the JOIN Fails with AV Q299575 KB299575 October 3, 2003
299494 FIX: Incorrect Text "There are no EFS keys" in Sqlstp.log for Error 6006 During Upgrade Q299494 KB299494 October 3, 2003
298828 FIX: Query Analyzer Stops Responding and Cannot be Started Until Visual Studio Analyzer is Stopped Q298828 KB298828 October 3, 2003
298093 FIX: BOL Incorrectly Demonstrates Usage of sp_change_primary_role with @job_id Parameter Q298093 KB298093 October 3, 2003
297156 FIX: Snapshot Agent Error Occurs While Adding Table with a Space in it's Name to an Existing Merge Publication Q297156 KB297156 October 3, 2003
297104 FIX: Backup or Restore Using Large Transaction Logs May Return Error 3241 Q297104 KB297104 October 3, 2003
275024 FIX: SQL Server Enterprise Manage Does Not List all Tables in the TaskPad View and the Next and Last Buttons Do Not Appear Q275024 KB275024 October 3, 2003
308984 FIX: Nondynamic Snapshot Performs Poorly for Partitioned Merge Publication Q308984 KB308984 September 25, 2003
306334 FIX: Objects May Fail to Retain Quoted Identifier Setting When You Use SQL-DMO to Create or Alter Objects Q306334 KB306334 September 25, 2003
288122 FIX: Lock Monitor Uses Excessive CPU Q288122 KB288122 September 12, 2003
822855 FIX: Access Violation Occurs in BufferPartition::Steal Q822855 KB822855 July 7, 2003
292316 FIX: Bad Plan May Be Chosen for Subquery with Aggregate and OR Clause Q292316 KB292316 June 4, 2003
308831 FIX: SQL Server 2000 Service Pack 1 Setup Fails with 703 Error Message: "An internal read error.." Q308831 KB308831 April 24, 2003

SQL Server 2000 articles, fixes and updates - letter F