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 B that have been released. The list is daily updated.

318432 BUG: Cannot connect to a clustered named instance through a firewall Q318432 KB318432 April 21, 2018
830575 Backup fails on a computer that is running Small Business Server 2003 Q830575 KB830575 April 19, 2018
887165 BUG: You may receive an "Access is denied" error message when a query calls an extended stored procedure after you upgrade from SQL Server 2000 to SQL Server 2000 Service Pack 4 Q887165 KB887165 April 13, 2018
823466 BUG: You cannot install SQL Server Desktop Engine on a computer that has an operating system locale that does not have a default SQL Server collation mapping Q823466 KB823466 April 13, 2018
279888 BUG: Error When You Use Client Cursor to Add Record to SQL Server Table That Has Default Value in Datetime Field Q279888 KB279888 April 13, 2018
922663 BUG: Error message when you replicate a table to a SQL Server destination by using snapshot replication in SQL Server 2000: "Bulk-copy commit failed (bcp_batch) ODBC message: SQLSTATE 37000, native error 4813" Q922663 KB922663 January 17, 2015
917544 BUG: You receive an error message when you run the "Log Shipping Alert Job - Restore" job in SQL Server 2000 Q917544 KB917544 January 17, 2015
910741 BUG: Login names that contain leading zero characters are not visible when you use SQL Profiler to audit connections to SQL Server 2000 Q910741 KB910741 January 17, 2015
908243 BUG: You receive an "Error 14269" error message when you try to modify the SQL Server Agent job if the combination of the computer name and the instance name is more than 30 characters in SQL Server 2000 Q908243 KB908243 January 17, 2015
906117 BUG: Queries against indexed views may run slower when you install a SQL Server 2000 post-SP3 hotfix, a SQL Server 2000 post-SP3a hotfix, or SQL Server 2000 SP4 Q906117 KB906117 January 17, 2015
888530 BUG: The permissions for a multi-statement table-valued function are not retained when you use the ALTER FUNCTION statement in SQL Server 2000 Q888530 KB888530 January 17, 2015
842434 BUG: IntelliSense feature of Visual Studio .NET 2003 does not work correctly when you use the VBCommenter add-in in a solution that includes a report project Q842434 KB842434 January 17, 2015
826310 BUG: You cannot connect to a SQL Server 2000 Analysis Services computer after you install Analysis Services Service Pack 3 Q826310 KB826310 January 17, 2015
298723 BUG: SQL Mail may not be fully supported for use with virtual SQL Servers Q298723 KB298723 January 16, 2015
293111 BUG: Error "Login Failed" from Data View Window If Allow Saving Password Is Not Checked Q293111 KB293111 January 16, 2015
273502 BUG: Cannot uninstall SQL Server 6.5 after SQL Server 7.0 is upgraded to SQL Server 2000 on the same computer Q273502 KB273502 January 16, 2015
270061 BUG: Access Violation Occurs When You Debug Stored Procedure Q270061 KB270061 January 16, 2015
269883 BUG: SQL Server Optimizer Chooses Bad Plan with Self Joined Tables Q269883 KB269883 January 16, 2015
268808 BUG: Create Database Statement Does Not Allow Creation of Maximum Size Database File Q268808 KB268808 January 16, 2015
248602 BUG: ODBC Driver Incorrectly Shows Linked Data as #DELETED Q248602 KB248602 January 16, 2015
233161 BUG: Xp_logininfo Returns Error 8198 Q233161 KB233161 January 16, 2015
231880 BUG: Import Wizard Fails if Excel File is Open During Import/Export Q231880 KB231880 January 16, 2015
229747 BUG: Query with Joins, Aggregate, Concatenation May Cause AV Q229747 KB229747 January 16, 2015
221981 BUG: Xp_sendmail Sends Text Data in 4 KB Chunks Q221981 KB221981 January 16, 2015
207718 BUG: User's Role Not Updated Instantly in Multiple Sessions Q207718 KB207718 January 16, 2015
178642 BUG: Many WRITETEXT Calls Causes DB-Library Error 10005 Q178642 KB178642 January 16, 2015
161351 BUG: Bcp_bind Does Not Correctly Convert Real DBFLT4 Q161351 KB161351 January 16, 2015
153996 BUG: The error message provides an incorrect table name when you use an ambiguous update statement in SQL Server Q153996 KB153996 January 16, 2015
152393 BUG: Set FIPS_FLAGGER Fails to Warn of SELECT Extensions Q152393 KB152393 January 16, 2015
141664 BUG: Convert From Binary to Numeric Gives Error 8114 Q141664 KB141664 January 16, 2015
811589 BUG: The Generate Wizard in Microsoft Visio does not create the "Unique index with constraint on top" index in a SQL Server database Q811589 KB811589 January 10, 2015
904652 BUG: You receive an "Error 25003" error message when you restart the computer after you install SQL Server Desktop Engine Service Pack 3 Q904652 KB904652 June 20, 2014
282827 BUG: Transaction Names Are Case Sensitive on a Non-Case-Sensitive SQL Server Q282827 KB282827 April 30, 2014
825393 Building OLE DB applications for SQL Server CE 1.1, SQL Server CE 2.0, and Windows CE .NET Q825393 KB825393 February 28, 2014
829091 BUG: Database Components Are Not Installed When You Install SQL Server Notification Services Q829091 KB829091 February 27, 2014
821270 BUG: A SET USER command run by using an Xp_cmdshell or a CmdExecJob job step returns an incorrect value for the service logon account in a SQL Server 2000 cluster Q821270 KB821270 February 27, 2014
818552 BUG: Replication Agent Might Run Continuously Even When the Replication Job is Completed Q818552 KB818552 February 27, 2014
818550 BUG: Upgrade of SQL Server 6.5 to SQL Server 2000 Service Pack 3 Fails During the Export and Import Through Named Pipe Task Q818550 KB818550 February 27, 2014
815122 BUG: Sp_addarticle Stored Procedure Failures Occur After You Apply SQL Server 2000 SP3 Q815122 KB815122 February 27, 2014
814132 BUG: The SQL Server 2000 Service Manager Utility Does Not List Instances That Have Not Enabled Network Connections Q814132 KB814132 February 27, 2014
198520 BUG: You receive an "OLE DB Provider 'atlprov' reported an error" error message when you try to use an ATL wizard-generated OLE DB Provider in Visual C++ Q198520 KB198520 December 27, 2013
914191 BUG: The vacuuming process stops running when you configure the generator to run on a different computer in SQL Server 2000 Notification Services Q914191 KB914191 November 2, 2013
886835 BUG: You receive an "Unable to update role in cube" error message, and Analysis Manager or a DSO application indicates incorrect permissions in SQL Server 2000 Analysis Services Q886835 KB886835 November 2, 2013
819541 BUG: MDX Query Does Not Return Correct Results When Writeback Data Is Not Committed Q819541 KB819541 November 2, 2013
818389 BUG: Unexpected Behavior Occurs When You Perform a Drill Down of a Parent-Child Dimension That Has a Ragged Hierarchy Q818389 KB818389 November 2, 2013
811903 BUG: Stored Procedures Do Not Accurately Report Failed Notifications Q811903 KB811903 November 2, 2013
325788 BUG: Documentation error in the "Reinitializing a Subscription" topic in SQL Server CE 1.1 Books Online Q325788 KB325788 November 2, 2013
322677 BUG: You Receive an Error Message If the Member Caption Is Different from the Member Name Q322677 KB322677 November 2, 2013
319636 BUG: Date Formats Change to DBTimeStamp After Server Processes Cube Q319636 KB319636 November 2, 2013
319634 BUG: User Cannot Create or Process an OLAP Database Even if the User is a Member of the OLAP Administrators Group Q319634 KB319634 November 2, 2013
319601 BUG: The second cluster node is not listed as a possible owner in Cluster Administrator Q319601 KB319601 November 2, 2013
311528 BUG: Infinite Recursion Error with Parent-Child Dimension and Custom Member Q311528 KB311528 November 2, 2013
308853 BUG: SP1 Regression: Uninstalling SQL Server 2000 Does Not Remove the MSSQLServerADHelper Service Q308853 KB308853 November 2, 2013
300478 BUG: Print Jobs from Query Analyzer Fail to Complete Spooling Q300478 KB300478 November 2, 2013
313474 BUG: An Insert statement that uses a function to parse a string may receive error message 8626 Q313474 KB313474 October 26, 2013
299351 BUG: MSDE Installation Fails on Systems That Have SQL Server 2000 Service Pack 1 or 2 Installed Q299351 KB299351 October 26, 2013
295589 BUG: You receive Cluster Administrator error messages and any subsequent attempt to move the SQL Server Resource Group to the newly rebuilt node fails Q295589 KB295589 October 26, 2013
292295 BUG: Unable to Connect to Analysis Services 2000 When OfficeXP is Installed Q292295 KB292295 October 26, 2013
229608 BUG: SQL 7.0 Desktop Edition Install on Windows 98 Causes "Assertion Failed File: ..\SRC\SQLSSPI.C Line: 119" Q229608 KB229608 October 26, 2013
311863 BUG: Internal Error Occurs When You Run a MDX Query with a NON EMPTY Clause Against a Virtual Cube Q311863 KB311863 October 24, 2013
311310 BUG: Analysis Manager Does Not Support HTTP or HTTPS Connections Q311310 KB311310 October 24, 2013
309423 BUG: Analysis Manager Stops Responding During Restore on Remote Server Q309423 KB309423 October 24, 2013
304957 BUG: Analysis Manager May Fail To Connect After Migration of Repository Q304957 KB304957 October 24, 2013
294180 BUG: ADO: Append Cannot Be Used with OLE DB Provider For SQL Server if the Name of the Table Contains Spaces Q294180 KB294180 October 23, 2013
293782 BUG: Can Only Administer Analysis Server if User is a Member of Administrators Group Q293782 KB293782 October 23, 2013
293627 BUG: Failure to migrate repository from Meta Data format to SQL Server 7.0 format Q293627 KB293627 October 23, 2013
290799 BUG: Missing Horizontal Scroll Bar in Cube Browser Q290799 KB290799 October 23, 2013
290416 BUG: Unable to Drill Down to Next Level with Hide Member if Property Set Q290416 KB290416 October 23, 2013
289748 BUG: Missing Values For Database Event Constants Q289748 KB289748 October 23, 2013
285103 BUG: BOL Incorrect on SAPASSWORD and USEDEFAULTSAPWD Options for SQL Server 2000 Desktop Engine Installation Q285103 KB285103 October 23, 2013
283564 BUG: Alias Parameters Do Not Work with Oracle Databases Q283564 KB283564 October 23, 2013
298743 BUG: All Changes May Not be Rolled Back when Log Shipping Maintenance Wizard Fails Q298743 KB298743 October 24, 2012
291255 BUG: IsAlive check does not run under the context of the BUILTIN\Administrators account in SQL Server 2000 Enterprise Edition Q291255 KB291255 September 17, 2011
812774 BUG: Changes to the Group Membership In Windows Are Not Reflected Immediately in the SQL Server IS_MEMBER Function Q812774 KB812774 May 7, 2009
909584 BUG: The Setup program closes unexpectedly when you try to maintain or remove a clustered instance of SQL Server 2000 64-bit when you have installed a clustered instance of SQL Server 2005 64-bit on the same computer Q909584 KB909584 March 11, 2009
290622 BUG: Database maintenance plan on system databases fails on integrity check if "Attempt to repair minor problems" is selected Q290622 KB290622 February 5, 2009
938943 Blank space appears in the file when you export a report to a physical page format file in SQL Server 2005 Reporting Services or in SQL Server 2000 Reporting Services Q938943 KB938943 June 13, 2008
841773 BUG: SQL Server Setup stops responding when you upgrade an instance of SQL Server Desktop Engine (Windows) to SQL Server 2000 Q841773 KB841773 December 3, 2007
294160 BUG: Update of Newly Inserted Row Causes DB_E_ERRORSOCCURRED Q294160 KB294160 November 30, 2007
816939 BUG: File growth value for the tempdb database is not persistent when changed from fixed increments to percentage Q816939 KB816939 November 26, 2007
897886 BUG: The return data type depends on the location of a UNION operation where char and varchar data types are combined in SQL Server 2000 Q897886 KB897886 November 2, 2007
892803 BUG: You may receive the "Server: Msg 8929" error message or the "Server: Msg 8968" error message when you run a maintenance plan or a command that examines the integrity of the database in SQL Server 2000 Q892803 KB892803 November 2, 2007
892451 BUG: You receive an "EXCEPTION_ACCESS_VIOLATION" error message when you use a RIGHT OUTER JOIN clause in SQL Server 2000 Q892451 KB892451 November 2, 2007
891553 BUG: There is a decrease in performance when you frequently create and drop temporary tables in SQL Server 2000 Q891553 KB891553 November 2, 2007
883783 BUG: You may receive an error message when you try to initialize full-text indexing for a database on a computer that is running Windows XP SP2 Q883783 KB883783 November 2, 2007
285025 BUG: SQL 6.5 Logins upgraded to SQL 7.0 and subsequently moved to SQL 2000 through CDW cannot log in Q285025 KB285025 November 2, 2007
278667 BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or ME Computers Q278667 KB278667 November 2, 2007
273833 BUG: Restore of a Large Database on Windows 98 May Fail with 3257 Error Message Q273833 KB273833 November 2, 2007
271070 BUG: Desktop Engine and Personal Edition Fails When You Upgrade MSDE 1.0 & Desktop Edition 7.0 Q271070 KB271070 November 2, 2007
148224 BUG: Cross-database table creation/drop in stored procedure Q148224 KB148224 November 2, 2007
316046 BUG: SQL Server 2000 Evaluation Edition Does Not Extract Q316046 KB316046 October 29, 2007
817843 BUG: Error Message: "The colv1 parameter is shorter..." Occurs When Replicated Column is Updated Q817843 KB817843 June 1, 2007
823871 BUG: Error Message "Either BOF or EOF is True, or the current record has been deleted." Occurs When You Archive an OLAP Database Q823871 KB823871 May 31, 2007
885712 BUG: An 8144 error occurs when you try to attach a database to an instance of SQL Server by using SQL Server Enterprise Manager Q885712 KB885712 May 18, 2007
824421 BUG: You receive an error message that contains a decimal representation of the SQL Server version number Q824421 KB824421 May 16, 2007
819264 BUG: Error Message: "Could not find database ID..." Occurs When a User Defined Function is Referenced in the JOIN Condition of a Subquery Q819264 KB819264 May 16, 2007
819260 BUG: The Transfer of a File by Using an FTP Task in a DTS Package Returns a Success Message Even When the Source File is Not Available Q819260 KB819260 May 16, 2007
832902 BUG: The Distribution Agent or the Merge Agent does not succeed when you replicate stored procedures or views in SQL Server 2000 Q832902 KB832902 April 29, 2007
827204 BUG: You may not be able to connect to an instance of Microsoft SQL Server 2000 Desktop Engine SP3a after you enable the server network libraries Q827204 KB827204 April 18, 2007
817089 BUG: Recovery of database logical file names might fail after a RESTORE operation Q817089 KB817089 April 9, 2007
839617 BUG: You cannot connect to an instance of SQL Server on a server computer after you turn on SSL encryption on the SQL Server client computer Q839617 KB839617 March 20, 2007
838303 BUG: You receive an "Unable to determine system default collation" error message when you try to remove Microsoft SQL Server 2000 Desktop Engine or Microsoft SQL Server 2000 Desktop Engine (Windows) Q838303 KB838303 March 19, 2007
838302 BUG: You may receive an error message when you try to install SQL Server Desktop Engine (Windows) or SQL Server Desktop Engine SP2 or later Q838302 KB838302 March 19, 2007
897014 BUG: You are redirected to the logon Web page when you try to run more than 18 different reports and you use a Forms Authentication extension in SQL Server 2000 Reporting Services Q897014 KB897014 March 15, 2007
308264 BUG: SQLDescribeCol Returns Wrong Column Size in a Complex Union Query with Parameters Q308264 KB308264 February 23, 2007
324305 BUG: SQL Server Virtual Server Setup Fails and You Receive an Error Message Q324305 KB324305 February 22, 2007
322965 BUG: Excel Mode Function Returns #ERR in MDX Calculated Member Q322965 KB322965 February 22, 2007
320338 BUG: Starting the SQL Server Agent is Unsuccessful on a Backup Domain Controller Q320338 KB320338 February 22, 2007
313883 BUG: Memory Leak When You Load and Unload the SQL Server ODBC Driver or OLE DB Provider Q313883 KB313883 February 22, 2007
311801 BUG: Error 3154 Reported in Log Shipping Restore Job Sporadically Q311801 KB311801 February 22, 2007
310882 BUG: sp_resolve_logins Stored Procedure Fails If Executed During Log Shipping Role Change Q310882 KB310882 February 22, 2007
301913 BUG: Error Message: "There is not enough space on drive" Occurs When You Extract SQL Server 2000 Downloads Q301913 KB301913 February 22, 2007
300080 BUG: Property Changes in the Merging Changes Tab of an Indexed View Article Are Not Saved Q300080 KB300080 February 22, 2007
292586 Backup, copy, and load job information is not updated on the log shipping monitor Q292586 KB292586 February 22, 2007
289107 BUG: Incorrect Reference to the Second Virtual Server Instance Name Q289107 KB289107 February 22, 2007
311145 BUG: Update of Column That is Part of an Indexed View May Cause a Handled Access Violation Q311145 KB311145 February 21, 2007
310624 BUG: DBCC DBREINDEX on Indexed View May Cause Handled Access Violation Q310624 KB310624 February 21, 2007
313597 BUG: Analysis Services Performance Counters Disappear after You Install Service Pack 2 Q313597 KB313597 February 20, 2007
310714 BUG: DBCC DBREINDEX Can Cause Error 8623 on Indexed View Q310714 KB310714 February 19, 2007
819261 BUG: Error 15023, 15024 or 21002 Occurs When You Try to Add a Domain User or a Domain Group to the Database Q819261 KB819261 February 16, 2007
300597 BUG: NOT FOR REPLICATION clause causes SQL Server CE replication to fail Q300597 KB300597 February 12, 2007
280459 BUG: SQL Server CE Filtered Recordset Permits Navigation Outside Filter Q280459 KB280459 February 12, 2007
830775 BUG: The Server Network Utility dialog box does not open when you try to open the utility by using SQL Server Enterprise Manager Q830775 KB830775 February 8, 2007
906508 BUG: You receive a "System.Data.SqlClient.SqlException" error message when you run the Data Extraction Program tool (Rpdataextraction.exe) Q906508 KB906508 February 2, 2007
832955 BUG: The dtproperties system table is displayed as a user table in Visual Studio .NET Server Explorer Q832955 KB832955 January 22, 2007
897020 BUG: You receive a "Failed to find property in cache: InstalledInstances. failed to perform discovery on machine" error message when you try to install SQL Server 2000 Reporting Services Q897020 KB897020 January 16, 2007
888531 BUG: You receive an "Unable to read file" error message in Excel when you try to export a report in SQL Server 2000 Reporting Services Q888531 KB888531 January 16, 2007
330741 BUG: A transfer of data from a SQL Server CE or SQL Server 2005 Compact Edition database to a remote SQL Server database fails when you use the Push method in SQL Server CE Remote Data Access Q330741 KB330741 December 7, 2006
843026 BUG: You receive an error message when you try to deny access to a dimension member for a cube role by using a custom rule in Analysis Manager Q843026 KB843026 November 21, 2006
324426 BUG: FoodMart 2000 Does Not Install When You Install Analysis Server on Windows XP Professional Chinese Version Q324426 KB324426 November 21, 2006
310647 BUG: Visual Basic 6.0 T-SQL Debugger fails against SQL Server 2000 named instance Q310647 KB310647 September 29, 2006
231403 BUG: BOL incorrectly states that a member of db_owner role can issue SETUSER command Q231403 KB231403 July 31, 2006
295337 BUG: Virtual SQL Server fails to install into a cluster group with a local quorum Q295337 KB295337 April 7, 2006
319349 BUG: Turning on the "Force Protocol Encryption" option is irreversible if there is no certificate Q319349 KB319349 April 6, 2006
298570 BUG: Virtual SQL Server 2000 installations may fail if you try to install SQL Server 2000 to Windows 2000 domain controllers Q298570 KB298570 April 6, 2006
293788 BUG: The installation of a SQL Server virtual server stops responding (hangs) if the disk name and the group name are the same Q293788 KB293788 April 6, 2006
318672 BUG: Error message when you try to set up a SQL Server 2000 virtual server on multiple nodes: "Setup failed to perform the required operation on the cluster nodes" Q318672 KB318672 March 18, 2006
296769 BUG: Cannot use SQL Enterprise Manager to create stored procedures containing linked server objects Q296769 KB296769 December 23, 2005
286303 Behavior of SQL Server 2000 network library during dynamic port detection Q286303 KB286303 December 13, 2005
323602 BUG: The SQL Server VDI Backup and Restore Operations Are Not Successful and the CoCreateInstance Error Occurs Q323602 KB323602 December 1, 2005
313993 BUG: VSS Database Truncates Stored Procedures Larger Than 4 KB Q313993 KB313993 October 21, 2005
310639 BUG: SP_ADD_JOBSTEP Does Not Recognize Server Names Longer Than 30 Characters Q310639 KB310639 September 26, 2005
221574 BUG: Can't Save Changes When OLAP Repository on SQL Server 6.5 Q221574 KB221574 July 21, 2005
305711 BUG: DBO user does not display in Enterprise Manager Q305711 KB305711 June 6, 2005
839278 BUG: The changes in a remote subscriber are not updated to the publisher for a queued updating replication that uses Message Queuing on a computer that is running Windows XP Service Pack 2 Q839278 KB839278 May 13, 2005
811476 BUG: Rollback fails with errors 3314 and 9001 if you enlist multiple connections in the same transaction Q811476 KB811476 April 25, 2005
895467 BUG: Calling the DatabaseMetaData.getPrimaryKeys function generates lots of temporary files when you use the SQL Server 2000 Driver for JDBC Q895467 KB895467 March 23, 2005
198141 BUG: DTS: Two or More Columns with the Same Name Cannot Transfer Q198141 KB198141 March 14, 2005
197392 BUG: Error 16929, "Cursor Is Read Only" for Cursor w/OpenQuery() Q197392 KB197392 March 14, 2005
196935 BUG: Cannot Convert Between TEXT and NTEXT by Using UPDATETEXT Q196935 KB196935 March 14, 2005
196903 BUG: Full Text Search Fails with Unique Index on Multiple Columns Q196903 KB196903 March 14, 2005
141669 BUG: Wrong Error# Trying to Connect Client to Paused SQL Svr Q141669 KB141669 March 14, 2005
139407 BUG: Alternate Pipe Not Recognized in Unattended Installation Q139407 KB139407 March 2, 2005
166202 BUG: NSQLPREP Substitutes DBCS Object Name with a Null String Q166202 KB166202 February 22, 2005
164171 BUG: dbprocerrhandle Does Not Get Fired For Error 10029 Q164171 KB164171 February 22, 2005
115333 BUG: Recreating a Table Causes sysdepends to Become Invalid Q115333 KB115333 February 22, 2005
180490 BUG: SP_Depends Does Not List Triggers Q180490 KB180490 February 14, 2005
179657 BUG: BCP Fails to Parse Format File If It Has White Space in Column Name Q179657 KB179657 February 14, 2005
173848 BUG: Sp_OA Procedures May Produce "Bad Variable Type" or "Type Mismatch" Error Q173848 KB173848 February 14, 2005
169641 BUG: Xp_sendmail with Large Row Results May Cause Error 35909 Q169641 KB169641 February 14, 2005
161592 BUG: CREATE TABLE Trailing Comma Not Treated as Syntax Error Q161592 KB161592 February 14, 2005
89938 BUG: ISQL Problems with PRINT in Stored Procedures Q89938 KB89938 February 14, 2005
322099 Bitmaps in Microsoft SQL Server 2000 (White Paper) Q322099 KB322099 December 27, 2004
275912 BUG: Generated scripts include ON INSERT/ DELETE CASCADE statements when scripting SQL Server 7.0 compatible features Q275912 KB275912 December 21, 2004
839796 Bugs that are fixed by SQL Server 2000 Reporting Services Service Pack 1 Q839796 KB839796 November 24, 2004
281310 BUG: You cannot create an index on a computed column in a SQL Server 2000 database that was restored from SQL Server 7.0 Q281310 KB281310 November 17, 2004
291587 BUG: SQL Server 6.5 Upgrade to SQL Server 2000 May Fail When "Preparing sql-dmo for upgrade" Because Path is not in 8.3 Format Q291587 KB291587 November 16, 2004
815126 BUG: Renaming tasks or steps by using the DTS Object model results in a non-editable package Q815126 KB815126 September 29, 2004
320524 BUG: The Setup program of SQL Server 2000 Service Pack 2 or a later version may stop responding in a Windows clustering environment if there is an offline database Q320524 KB320524 September 2, 2004
823467 BUG: You cannot start the SQL Server Agent Service for an instance of SQL Server or the SQL Server 2000 Desktop Engine that has the same instance name as a previously uninstalled instance of the SQL Server 2000 Desktop Engine (Windows) Q823467 KB823467 August 13, 2004
875411 BUG: Only 65,534 rows are inserted when you try to insert more than 65,535 records in a SQL Server table by using the SQLBulkOperations ODBC function Q875411 KB875411 July 22, 2004
841845 Behavior of the ORDER BY clause in views, derived tables, inline functions, and subqueries in SQL 2000 Q841845 KB841845 July 13, 2004
272145 BUG: SQL-DMO Treats Shutdown Message from SQL Server as Error Condition After Shutdown Method Runs Q272145 KB272145 July 13, 2004
305387 BUG: UpdateBatch Generates SQL Statement That Cannot Reuse SQL Server Query Plans Q305387 KB305387 June 28, 2004
230236 BUG: Scm.exe command line arguments not documented in SQL 7.0 Books Online Q230236 KB230236 June 28, 2004
304091 BUG: Replication Transactional Pull Subscriptions Fail with "Error 14262:The specified @job_id could not be found" Error Message Q304091 KB304091 June 25, 2004
294397 BUG: sp_change_secondary_role Fails with Error 3101 if There Are Outstanding Transaction Log Backups Q294397 KB294397 June 25, 2004
821480 BUG: Snapshot failures occur when you use an alternate snapshot folder or FTP and the first article is dropped from the publication Q821480 KB821480 June 17, 2004
839564 BUG: An access violation exception may occur in the ASPNET_WP.exe process when you view a report that is based on an Oracle data source in SQL Server 2000 Reporting Services Q839564 KB839564 May 21, 2004
839417 Blocking problems may occur when you use SQL Server Enterprise Manager to make design changes to a table Q839417 KB839417 May 19, 2004
833044 BUG: You receive an error message when you copy a large subscription database Q833044 KB833044 April 6, 2004
330088 BUG: SQLServer:Databases Performance Counters Limited to First 99 Databases in Windows System Monitor Q330088 KB330088 April 6, 2004
328197 BUG: SQL Server Agent Job with E-Mail Notification Option Stops Responding When Microsoft Exchange Server is Not Available Q328197 KB328197 April 6, 2004
319058 BUG: DTS Package Execution Is Canceled Unexpectedly in a Visual Basic Application Q319058 KB319058 April 6, 2004
823465 BUG: You may not be able to distinguish between instances of Microsoft SQL Server 2000 Desktop Engine or Microsoft SQL Server 2000 Desktop Engine (Windows) in the Add or Remove Programs entry in Control Panel Q823465 KB823465 February 26, 2004
555064 BUG: sysperfinfo counters are not time-adjusted Q555064 KB555064 February 25, 2004
248659 BUG: Performance Problem Restoring OLAP Database to a Repository with Many Objects Q248659 KB248659 February 24, 2004
247750 BUG: Table Names Enclosed in Double Quotes When Transferred from SQL Server to Oracle Q247750 KB247750 February 24, 2004
231988 BUG: 7.0 Upgrade Loops When 6.5 Parameters Are Reversed Q231988 KB231988 February 24, 2004
219272 BUG: ROLAP Cube Processing Fails with Big Numbers in Measures Columns Q219272 KB219272 February 24, 2004
201021 BUG: DOC: DB_OWNER Roles Cannot Administer All Jobs Q201021 KB201021 February 24, 2004
823521 BUG: A separate entry is not created in Add or Remove Programs when you reuse the Windows Installer package with the SQL Server 2000 Desktop Engine (Windows) setup and with the SQL Server 2000 Desktop Engine Service Pack 3 setup Q823521 KB823521 February 23, 2004
196918 BUG: Comments in Views Removed When Using View Designer Q196918 KB196918 February 23, 2004
196916 BUG: Statistics Are Printed Twice with Statistics Time On Q196916 KB196916 February 23, 2004
830477 BUG: You cannot repair SQL Server 2000 Desktop Engine (Windows) by using the Add/Remove Programs tool Q830477 KB830477 February 13, 2004
832964 BUG: Parent referential integrity triggers are not generated when you use Visio to generate a SQL Server 2000 database Q832964 KB832964 January 8, 2004
247070 BUG: Opening a Long-Running View from SQL Server Enterprise Manager Gets ODBC Timeout Q247070 KB247070 December 5, 2003
313408 BUG: The Xp_logevent Stored Procedure Truncates Messages to 256 Characters Q313408 KB313408 December 3, 2003
311351 BUG: Transfer Login Task Is Slow with a Large Number of Logins Q311351 KB311351 December 3, 2003
303774 BUG: "Renaming A Server" Topic in SQL Server Books Online is Incomplete Q303774 KB303774 December 2, 2003
825728 BUG: SQL Server Books Online Incorrectly States That the Age Field of a Query Plan Is Incremented by Compilation Cost Factor Q825728 KB825728 November 26, 2003
298758 BUG: Using the Auto_Fix Option with sp_change_users_login Can Leave Security Vulnerabilities Q298758 KB298758 November 21, 2003
201041 BUG: Stored Procedure Remains After Deleting Web Wizard File Q201041 KB201041 November 21, 2003
296437 BUG: Database Restore May Result in DBO Mismatch if DBO Has Been Changed More Than Once Q296437 KB296437 November 19, 2003
279514 BUG: ExecuteWithResultsAndMessages2 Does Not Return Results Q279514 KB279514 November 17, 2003
244498 BUG: Dbcursoropen() Causes Access Violation When Selecting More than 254 Columns Q244498 KB244498 November 17, 2003
237973 BUG: Aggregate of an Expression May Return the Incorrect Scale Q237973 KB237973 November 17, 2003
295739 BUG: DTS Designer May Stop Responding When You Use Microsoft Jet 4.0 OLE DB Provider Q295739 KB295739 November 14, 2003
264901 BUG: Error 16917 When CURSOR_CLOSE_ON_COMMIT Is Set ON Q264901 KB264901 November 14, 2003
230393 BUG: SNMP Agent Message Causes Event ID 322 Q230393 KB230393 November 14, 2003
294412 BUG: SQLAgent T-SQL Job Does Not Respect SET NOCOUNT ON When Sending Output to File Q294412 KB294412 November 6, 2003
289475 BUG: SQLAgent Incorrectly Uses TLSAlloc for Transact-SQL Jobs Causing all TLS Slots to be Exhausted Q289475 KB289475 November 6, 2003
273572 BUG: Rebuildm.exe Utility Stops Responding When Source Directory is on a CD Q273572 KB273572 November 6, 2003
299382 BUG: Zeros Incorrectly Removed from the Binary Column in SQL Profiler Q299382 KB299382 November 5, 2003
270667 BUG: SQL Server 2000 SPX Named Instance Uses the Same Port as the Default Instance Q270667 KB270667 November 5, 2003
304372 BUG: SQLOLEDB May Fail with Parameterized Queries Q304372 KB304372 November 3, 2003
230406 BUG: DTS: Preview Shows Column Headers as Data When Invoked Multiple Times Q230406 KB230406 November 3, 2003
221480 BUG: DTS: Default Scheduling Information Displayed Q221480 KB221480 November 3, 2003
299452 BUG: Copy Database Wizard Exits Without Error if any of the Source Databases are in Single User Mode Q299452 KB299452 October 31, 2003
293177 BUG: Hypothetical Clustered Index From Index Tuning Wizard May Cause Recompile Loop Q293177 KB293177 October 31, 2003
275255 BUG: Incorrect Column Mapping: Destination Shows TIMESTAMP From Nullable BINARY Source Q275255 KB275255 October 31, 2003
246722 BUG: OLAP Repository Migration Wizard Fails When Repository is Empty Q246722 KB246722 October 31, 2003
241761 BUG: DTS Transfer Does Not Report Error When Input File Is Missing Text Qualifier in Last Row Q241761 KB241761 October 31, 2003
238673 BUG: Package Execution Can Fail if Target Table Has an Identity Q238673 KB238673 October 31, 2003
315994 BUG: DTS Wizard Generates Unspecified Error Message If Database with a Period in Name is Used Q315994 KB315994 October 30, 2003
312089 BUG: DTS Separates the Columns of Text at Invalid Trail Byte of DBCS Q312089 KB312089 October 30, 2003
251119 BUG: Last Row of Fixed Length File Fails to Import When File Does Not End with Row Delimiter Q251119 KB251119 October 30, 2003
300192 BUG: DTS Import/Export Wizard or TransferObjectsTask Fails to Maintain Filegroup Settings for Transferred Objects Q300192 KB300192 October 29, 2003
262340 BUG: LIKE with ESCAPE May Result in Different Query Access Plan Q262340 KB262340 October 29, 2003
244124 BUG: Creating a View in Enterprise Manager Using a Domain Account May Fail Q244124 KB244124 October 29, 2003
218995 BUG: Error "Invalid Object Name" on Linked Server Table Through OLEDB Q218995 KB218995 October 29, 2003
239092 BUG: BOL Incorrectly States That SQL Server Doesn't Support TOP Queries Q239092 KB239092 October 28, 2003
232864 BUG: Cannot Delete OLAP Service Directory After Removing OLAP Services Q232864 KB232864 October 28, 2003
303712 BUG: Use of the sp_rename Stored Procedure to Change the Case of a Column Name Fails Q303712 KB303712 October 17, 2003
303515 BUG: BCP May Fail to Import All Rows When You Use a Multi-character Row Delimiter Q303515 KB303515 October 17, 2003
300701 BUG: BCP into Temporary Table Fails with Error 229 "INSERT Permission Denied" Q300701 KB300701 October 17, 2003
296434 BUG: SQL Server 2000 Enterprise Manager Taskpad May Not Show Tables in Table Info Tab Q296434 KB296434 October 17, 2003
295742 BUG: UPDATE Statement Using a SELECT with Aggregates and JOIN May Generate Internal Error Q295742 KB295742 October 17, 2003
291307 BUG: DTS Message Queue Task May Truncate Messages to 255 Characters Q291307 KB291307 October 17, 2003
288527 BUG: SQL Server Enterprise Manager Design View May Change the T-SQL Syntax of a View Q288527 KB288527 October 17, 2003
286290 BUG: Entity Defaults Are Ignored When Clarification Question Is Asked Q286290 KB286290 October 17, 2003
285635 BUG: SQL Scheduled Job Skips Every Other Day with Weekly Schedule Q285635 KB285635 October 17, 2003
285114 BUG: When You Use a Full Text Query Clause Greater Than 8K an Error Message Occurs That Does Not Indicate Overflow of Size Limit Q285114 KB285114 October 17, 2003
281347 BUG: Can't Append Columns to Tables with Large Number of Columns in SEM Table Designer Q281347 KB281347 October 17, 2003
281346 BUG: Fetch From a Dynamic Cursor Causes an Access Violation Q281346 KB281346 October 17, 2003
279159 BUG: Cancel Button in DTS Package Designer Save Dialog Box Exits Form Without Saving Q279159 KB279159 October 17, 2003
278897 BUG: Existing Maintenance Plan Fails to Download to New Target Server Q278897 KB278897 October 17, 2003
277848 BUG: Error Message "Table Corrupt Object ID 0, index ID 0, page ID.." Occurs When You Run DBCC DBREINDEX in SQL Server Q277848 KB277848 October 17, 2003
275696 BUG: DCR: Enterprise Manager May Allow You to Select Backups that No Longer Exist Q275696 KB275696 October 17, 2003
275025 BUG: Cannot Design Table in SQL Server Enterprise Manager if Database Compatibility is Set to 60 Q275025 KB275025 October 17, 2003
274643 BUG: Estimated Execution Plan Steps Can Show Costs Greater Than 100% Q274643 KB274643 October 17, 2003
274165 BUG: Select Query Against a View That Contains Left Outer Joins May Return Incorrect Results Q274165 KB274165 October 17, 2003
273972 BUG: fn_trace_gettable Function Cannot Read Rollover Files Generated by SQL Profiler Q273972 KB273972 October 17, 2003
273593 BUG: SEM Help Displays Incorrect Size Information for Unicode Columns Q273593 KB273593 October 17, 2003
266224 BUG: Only One Double-Quoted String Allowed in xp_cmdshell String Q266224 KB266224 October 17, 2003
264163 BUG: Upgrade of Logins with Default Language Francais Cause Error 15033 Q264163 KB264163 October 17, 2003
263887 BUG: Upgrade of an Empty Table Resets Identity Value to Seed Q263887 KB263887 October 17, 2003
262258 BUG: Alert May Fail to Send E-mail Notification with xp_logevent or RAISERROR Q262258 KB262258 October 17, 2003
259466 BUG: SELECT Statement with a Correlated Subquery on a View with a Substring Causes an Access Violation on a Multi-Proc Computer Q259466 KB259466 October 17, 2003
258806 BUG: Maintenance Job History Does Not Show Correct Durations When a Job Takes Longer Than an Hour Q258806 KB258806 October 17, 2003
253274 BUG: xp_sqltrace Cannot Be Used as a Startup Procedure Q253274 KB253274 October 17, 2003
252733 BUG: Optimizer Chooses Table Scan Instead of Index Seek Q252733 KB252733 October 17, 2003
252519 BUG: Transfer Manager Fails When Application Role Defined Q252519 KB252519 October 17, 2003
249887 BUG: BCP/BULK INSERT Into a View May Cause Defaults Defined in Base-table to be Ignored Q249887 KB249887 October 17, 2003
249032 BUG: Error Message 8644 Returned When Inserting into a Table with a Trigger Q249032 KB249032 October 17, 2003
245556 BUG: Running SQLDIAG.EXE Produces an Internal Error in the Application Event Log - EventID 998 Q245556 KB245556 October 17, 2003
243754 BUG: Other Users Can See Your Registered SQL Servers in SQL Enterprise Manager Q243754 KB243754 October 17, 2003
236989 BUG: Uninstalling SQL 6.5 After Upgrade to 7.0 May Remove 7.0 Data Files Q236989 KB236989 October 17, 2003
234890 BUG: 7.0 ISQL.EXE Returns Different Results than 6.5 ISQL.EXE Q234890 KB234890 October 17, 2003
231889 BUG: DOCERR: BOL States T-SQL Outer Joins in FROM Clause Support to be Dropped Q231889 KB231889 October 17, 2003
226488 BUG: Database Owner is Not Associated w/ User Id DBO Q226488 KB226488 October 17, 2003
223423 BUG: Optimizer Uses Scan with Multiple OR Clauses on Composite Index Q223423 KB223423 October 17, 2003
201890 BUG: SEM: Title of a New Object Does Not Reflect the New Object Name After Save Q201890 KB201890 October 17, 2003
201846 BUG: Reference to Deferred Object in Stored Procedure Will Not Show in Sp_depends Q201846 KB201846 October 17, 2003
201042 BUG: Stored Procedure Remains After Execution by Sp_makewebtask Q201042 KB201042 October 17, 2003
323323 BUG: Certain Field Terminators May Cause the BCP Utility or a BULK INSERT Statement to Import DBCS Data Incorrectly Q323323 KB323323 October 16, 2003
307930 BUG: Distribution Agent Parameters Listed After -QuotedIdentifier Are Ignored Q307930 KB307930 October 16, 2003
306608 BUG: Distribution Agent May Fail with Incorrect Syntax when Table Name Contains Hyphens Q306608 KB306608 October 16, 2003
300640 BUG: DTS Imports Empty Strings for Character Strings That Were Exported as NULLs Q300640 KB300640 October 16, 2003
300187 BUG: DTS UI Incorrectly Maps Tinyint to Decimal When You Transfer Data to DB2 Using HIS OLEDB Provider for DB2 Q300187 KB300187 October 16, 2003
295949 BUG: Source File with Several ESQLC Statements May Cause Access Violation in the Precompiler Q295949 KB295949 October 16, 2003
289287 BUG: BOL Incorrectly States the Precedence of Bitwise Operators Q289287 KB289287 October 16, 2003
288438 BUG: DTS Send Mail Task Does Not Display Correct Mail Profile Name in DTS Designer Q288438 KB288438 October 16, 2003
284443 BUG: Destroying OLE Automation Object May Leave Orphaned SQL Processes Q284443 KB284443 October 16, 2003
281680 BUG: FORMATMESSAGE Works with the Same User-Defined Messages as RAISERROR Q281680 KB281680 October 16, 2003
281326 BUG: Cannot Rename an Index on a View Q281326 KB281326 October 16, 2003
280468 BUG: SELECT with GROUP BY ALL Clause in a Nested Correlated Subquery Causes 8624 Error Message or Access Violation Q280468 KB280468 October 16, 2003
279857 BUG: Error 3910, "Transaction Context in Use by Another Session" Q279857 KB279857 October 16, 2003
278486 BUG: Stored Procedures May Retain Variable Value Between Executions Q278486 KB278486 October 16, 2003
277703 BUG: Cannot Specify Length of User-Defined Data Type When Based on Float Q277703 KB277703 October 16, 2003
276195 BUG: Some String Functions Do Not Work as Expected on Binary Data Q276195 KB276195 October 16, 2003
275307 BUG: Installation of SQL Server 2000 Desktop Engine Fails on Computers That Already Have SQL Server 7.0 Tools Installed Q275307 KB275307 October 16, 2003
274729 BUG: Internal Error with SELECT Statement Containing Correlated Subquery and GROUP BY Q274729 KB274729 October 16, 2003
272496 BUG: DCR: SQL Server Books Online Incorrectly States That IS_NULLABLE Returns YES or NO Q272496 KB272496 October 16, 2003
271827 BUG: DOC Error: Cannot Use Variables as SEED Parameter to the IDENTITY() Function Q271827 KB271827 October 16, 2003
271234 BUG: sp_getqueuedrows Stored Procedure Does Not Return Any Rows Although Queued Rows Exist Q271234 KB271234 October 16, 2003
269204 BUG: The Addition of a Merge Article with a Subset Filter Might Cause the Snapshot Agent to Fail Q269204 KB269204 October 16, 2003
264194 BUG: DB Maintenance Plan Cannot Be Modified to Include/Exclude Integrity Checks Before Backups Q264194 KB264194 October 16, 2003
260252 BUG: Merge Replication to Jet 4.0 Subscribers Performs Initial Synchronization when You Select the Manual Synchronization Option Q260252 KB260252 October 16, 2003
260246 BUG: Merge Replication to Jet 4.0 Subscriber Does Not Allow You to Set the ROWGUIDCOL Column as a Primary Key Column Q260246 KB260246 October 16, 2003
257345 BUG: SQL Server Books Online States That the Single User Mode Prevents All Locks Q257345 KB257345 October 16, 2003
257334 BUG: SQL Server Books Online States that TRUNCATE TABLE Is Nonlogged Q257334 KB257334 October 16, 2003
246330 BUG: Large Number of Agents on a Replication Distribution Server May Cause Heavy Deadlocking in TEMPDB Q246330 KB246330 October 16, 2003
234736 BUG: SQLDMO - Query Analyzer May Fail to Connect if SQL Server Is Started as Part of Connection Attempt Q234736 KB234736 October 16, 2003
231848 BUG: Object Scripting Tool Places a TEXTIMAGE_ON Clause When no Text, Ntext, or Image Column is Present Q231848 KB231848 October 16, 2003
201909 BUG: Locking Behavior in Transactions Is Incorrect Q201909 KB201909 October 16, 2003
258234 BUG: Query Analyzer May Not Display All Results with Some Error Sequences Q258234 KB258234 October 9, 2003
812914 BUG: DBCC CHECKCONSTRAINTS Fails with Error Message 170 Q812914 KB812914 October 3, 2003
812282 BUG: "Login time-out" Property Value Does Not Take Effect For SQL Query Analyzer Q812282 KB812282 October 3, 2003
327552 BUG: SQL Mail Only Works From One Instance at a Time Q327552 KB327552 October 3, 2003
323502 BUG: BCP May Export Corrupted DBCS Characters That Are Stored In a Char or Varchar Data Type Q323502 KB323502 October 3, 2003
320600 BUG: Incremental Article Additions to an Existing Merge Publication Do Not Work When You Use FTP Q320600 KB320600 October 3, 2003
317797 BUG: Xp_sendmail with Attachment Option Does Not Include All Results in Attachment Q317797 KB317797 October 3, 2003
317527 BUG: Use of COALESCE Function Against a Subquery with an Aggregate Function May Cause Error 8624 Q317527 KB317527 October 3, 2003
317436 BUG: Information in SQL Server Books Online Topic "Creating a Setup File Manually" Incorrect Q317436 KB317436 October 3, 2003
317009 BUG: SQL Enterprise Manager Query Designer Table Columns Do Not Display If Database Name Contains a Period Q317009 KB317009 October 3, 2003
315967 BUG: UPDATE Trigger May Have Long Parse and Compile Time Q315967 KB315967 October 3, 2003
315666 BUG: XP_SENDMAIL Fails to Send Mail to Personal Distribution List Q315666 KB315666 October 3, 2003
312909 BUG: French Database Maintenance Logs Contain Incorrect Characters Q312909 KB312909 October 3, 2003
310540 BUG: Unable to Change Identity Range of Publisher If You Use Auto Identity Range Q310540 KB310540 October 3, 2003
310175 BUG: BOL Incorrectly States That Users Do Not Need to Be Sysadmin to Use Profiler or SQL Profiler SPs Q310175 KB310175 October 3, 2003
309002 BUG: You Cannot Set the Microsoft Message Queuing Body Property by Using the Sp_OASetProperty Stored Procedure Q309002 KB309002 October 3, 2003
308809 BUG: DTC Transaction Allows Commits While SQL Server Shuts Down Q308809 KB308809 October 3, 2003
308643 BUG: Query Optimizer May Select an Inefficient Query Plan for a Query Against a Partitioned View Q308643 KB308643 October 3, 2003
308091 BUG: Hide Server Option Cannot Be Used on Multiple Instances of SQL Server 2000 Q308091 KB308091 October 3, 2003
307956 BUG: sp_repladdcolumn Returns Error 21286 When Executed on a Merge Publication That Contains an Embedded Period Q307956 KB307956 October 3, 2003
306865 BUG: SQL Server May Not Listen on TCP/IP Sockets When TCP/IP is the Only Protocol Q306865 KB306865 October 3, 2003
306247 BUG: Unable to View SQL Server 2000 From the Licensing Manager "Product View" Tab Q306247 KB306247 October 3, 2003
304706 BUG: Identity Range Not Adjusted on Publisher When Merge Agent Runs Continuously Q304706 KB304706 October 3, 2003
303667 BUG: BOL Incorrectly States That the xp_readmail @suppress_attach Option Defaults to TRUE Q303667 KB303667 October 3, 2003
303666 BUG: SP_Processmail @set_user Parameter Defaults to Guest Instead of the Security Context of the Current User Q303666 KB303666 October 3, 2003
303665 BUG: BOL Incorrectly States That Data Type for @set_user in sp_processmail Is Sysname Q303665 KB303665 October 3, 2003
303467 BUG: Unattended Installation of Service Pack 1 Fails with No Errors Q303467 KB303467 October 3, 2003
303369 BUG: Service Manager of SQL Server 2000 Does Not Show MSDE 1.0 Services Q303369 KB303369 October 3, 2003
303292 BUG: Expired transaction log backups may not be deleted by maintenance plan Q303292 KB303292 October 3, 2003
302621 BUG: Cannot Perform BULK INSERT with Bulkadmin Privileges Q302621 KB302621 October 3, 2003
301113 BUG: BOL Incorrectly States That IGNORE_DUP_KEY Affects UPDATE Statements Q301113 KB301113 October 3, 2003
300971 BUG: SQL Does Not Display Error When Freeing a Nonexistent DLL Q300971 KB300971 October 3, 2003
300965 BUG: Freeing Dynamic-Linked Libraries (DLLs) Fails to Unload Them When a Path Is Specified Q300965 KB300965 October 3, 2003
298990 BUG: SQL Server XML Bulk Load Object Retains First Schema Information and Uses it For Subsequent Invocation of the Execute Method Q298990 KB298990 October 3, 2003
298916 BUG: Cannot Change the Type of Installation During SQL Server 2000 Setup Q298916 KB298916 October 3, 2003
298564 BUG: SP_DBOPTION May Not Set the Database ANSI_NULL_DEFAULT Option When You Use Turkish Collation Q298564 KB298564 October 3, 2003
297466 BUG: READPAST Locking Hint Returns an Incorrect Number of Rows Q297466 KB297466 October 3, 2003
296642 BUG: Cannot Refer to Column in a Query Using the Name of a Table Variable Q296642 KB296642 October 3, 2003
296539 BUG: T-SQL Debugger Doesn't Allow Stepping Through Stored Procedures with Same Name Owned by Non-DBO Users Q296539 KB296539 October 3, 2003
296197 BUG: Documentation of Ownership Chain in BOL May Be Misleading Q296197 KB296197 October 3, 2003
295727 BUG: Object Browser May Not Reconnect After SQL Server Restart Q295727 KB295727 October 3, 2003
295306 BUG: Log Shipping Elements are Missing After You Upgrade from Standard to Enterprise Edition Q295306 KB295306 October 3, 2003
295021 BUG: WMI MSSQL_Table.ExportData Always Uses Standard Security Q295021 KB295021 October 3, 2003
294353 BUG: DOC: sysalternates View Does Not Exist in SQL Server 2000 Q294353 KB294353 October 3, 2003
294350 BUG: User Databases Do Not Contain INFORMATION_SCHEMA Views in SQL Server 2000 Q294350 KB294350 October 3, 2003
288969 BUG: Can't Insert into Views That Have INSTEAD OF Trigger in Enterprise Manager Q288969 KB288969 October 3, 2003
288395 BUG: SQL Server Books Online Does Not Display DELETE as an Option in the CREATE TRIGGER Topic Q288395 KB288395 October 3, 2003
287175 BUG: DOC: Incorrect Reference to Virtual Server Name VirtualServerA Should be VirtualServerX Q287175 KB287175 October 3, 2003
286239 BUG: Replay Tool Uses LoginName Column for SETUSER Instead of DatabaseUserName Column Q286239 KB286239 October 3, 2003
286199 BUG: Error Message "Transaction Cannot Start in Firehose Mode" Occurs When a Table is Open in SQL Server Enterprise Manager During a Failover Q286199 KB286199 October 3, 2003
282984 BUG: Multiple OR Clauses Combined with Non-selective Criteria May Result in Slower Plan Q282984 KB282984 October 3, 2003
282970 BUG: FAST_FORWARD Cursor that Joins Tables with Triggers are not Always Converted to Static Cursors Q282970 KB282970 October 3, 2003
280735 BUG: When You BCP More Than 117 Columns an Access Violation Occurs Q280735 KB280735 October 3, 2003
280100 BUG: Transact-SQL Debugger is not Available Through Terminal Server Session Q280100 KB280100 October 3, 2003
280099 BUG: Transact-SQL Debugger Cannot Debug a Stored Procedure that Contains a RAISERROR Statement that Raises any Error with Severity 16 or Higher Q280099 KB280099 October 3, 2003
279870 BUG: SNMP Configured Incorrectly When Default SQL Server 2000 Instance Is Not Installed Q279870 KB279870 October 3, 2003
279705 BUG: Example E in the sp_addlogin Topic of SQL Server 2000 Books Online is Incorrect Q279705 KB279705 October 3, 2003
279224 BUG: SQL Server 2000 BCP Utility Fails to Produce Proper Prefix-Length for Varbinary Column in Format File Q279224 KB279224 October 3, 2003
279083 BUG: Books Online Example Stored Procedure Sp_SetMark Q279083 KB279083 October 3, 2003
278664 BUG: BOL Incorrectly Leaves the Buffer Partition Counter Out of the List of SQL Server Performance Monitor Counters Q278664 KB278664 October 3, 2003
278016 BUG: Unable to Create Table in Enterprise Manager After Deleting a Column with Description Q278016 KB278016 October 3, 2003
275858 BUG: Maximum Number of Parameters Per Stored Procedure Q275858 KB275858 October 3, 2003
275199 BUG: UDF that Returns the Results of a CASE with a Correlated Subquery Returns Error Message 107 Q275199 KB275199 October 3, 2003
272433 BUG: SQL Server Books Online Incorrectly States the Names of the SQL Server 2000 Counters for Named Instances Q272433 KB272433 October 3, 2003
272418 BUG: Access Violation Occurs with Non-Updateable Derived Table in UPDATE Statement Q272418 KB272418 October 3, 2003
271344 BUG: An Error Message May Occur with the bcp Utility and BULK INSERT When You Load IMAGE Data Into Tables Q271344 KB271344 October 3, 2003
269971 BUG: TableIsLockedOnBulkLoad Property not Listed in SQL Server Books Online for OBJECTPROPERTY Q269971 KB269971 October 3, 2003
191234 BUG: ESQL: Error -19104 If Column, Table, or Alias Name Starts with CURRENT Q191234 KB191234 October 3, 2003
331999 BUG: SQLOLEDB Incorrectly Converts Char Data When AutoTranslate Is Turned On Q331999 KB331999 October 2, 2003
815123 BUG: SQL Enterprise Manager Displays Incorrect Database for QueueReader Subsystem Job Q815123 KB815123 September 25, 2003
812263 BUG: Infinite Loop in the lock_article_cache Function May Cause Log Reader to Stop Responding Q812263 KB812263 September 25, 2003
323283 BUG: WMI SQL Provider Does Not Work When Remotely Requesting Data from a Clustered SQL Server Q323283 KB323283 September 25, 2003
309555 BUG: Bcp.exe Executes Query Twice When QueryOut Argument Used Q309555 KB309555 September 25, 2003
303287 BUG: DTC Transactions May Fail When SQL Server Is Running in Lightweight Pooling Mode Q303287 KB303287 September 25, 2003
815594 BUG: A Failed Assertion Is Generated During a BULK INSERT Statement Q815594 KB815594 September 22, 2003
304365 BUG: Slow Performance with SQLOLEDB Inserting BLOB Data into SQL Server Using Stored Procedure Q304365 KB304365 September 17, 2003
203195 BUG: Wildcard (%) Is Not Recognized in the CONTAINS Clause for a Full-Text Search Q203195 KB203195 May 22, 2003
810322 BUG: Commerce Server Cannot Connect to a Clustered Named Instance Through a Firewall Q810322 KB810322 April 29, 2003

SQL Server 2000 articles, fixes and updates - letter B