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

200043 PRB: Dashes '-' Ignored in Search with SQL Full-Text and MSIDXS Queries Q200043 KB200043 January 25, 2021
830232 PSSDIAG data collection utility Q830232 KB830232 March 9, 2020
555070 Posting Message to MSMQ from SQL Server Q555070 KB555070 April 20, 2018
307002 PRB: ASP/ODBC/SQL Server Error 0x80040E4D "Login Failed for User '(Null)'" Q307002 KB307002 April 19, 2018
236605 PRB: DTS Wizard may not detect Excel column type for mixed data in SQL Server Q236605 KB236605 April 13, 2018
308266 PRB: Non-convergence when SQL Server processes child and parent generations in separate generation batches Q308266 KB308266 July 7, 2017
328306 Potential causes of the "SQL Server does not exist or access denied" error message Q328306 KB328306 April 27, 2017
900260 Permissions do not appear in the sysprotects table or in the output of the sp_helprotect stored procedure when you grant the permissions to an object in SQL Server 2000 Q900260 KB900260 January 17, 2015
281649 PRB: SQL Server Debugging with Visual Studio Service Pack 5 Requires a Non-System Account Q281649 KB281649 January 16, 2015
271727 PRB: Immediate Updating Subscriber Option Involving Different SQL Server Versions Q271727 KB271727 January 16, 2015
271601 PRB: REPLACE Sets First String to NULL if Third String is NULL Q271601 KB271601 January 16, 2015
203787 PRB: Error Msg 1007: The Number Is Out of Range / Err 8115: Arithmetic Overflow Q203787 KB203787 January 16, 2015
168257 PRB: Stored Procedure Scripts Not Generated in Dependency Order Q168257 KB168257 January 16, 2015
237604 PRB: SQL Server Agent does not start and displays error 18456 Q237604 KB237604 June 22, 2014
814398 PRB: Error 7399 When You Run a Linked Server Query That Uses the OLE DB Provider for Microsoft Jet Q814398 KB814398 June 20, 2014
829747 PRB: OLAP Cubes in an Analysis Services Database Are Not Accessible After You Apply Analysis Services SP3 Q829747 KB829747 February 27, 2014
827969 PRB: "Unhandled Token Type" Error Message When You Run a Transact-SQL Statement That Contains a COMPUTE Clause Q827969 KB827969 February 27, 2014
823066 PRB: Cannot Administer Analysis Services by Using DSO in ASP.NET Q823066 KB823066 February 27, 2014
822034 PRB: "SQLDMO Has Not Been Registered" Error Message If You Remove SQL Server Desktop Engine Q822034 KB822034 February 27, 2014
815486 PRB: Analysis Services with SQL Server Service Pack 3 Cannot Connect to Analysis Services Builds Between 8.00.0671 and 8.00.0727 Q815486 KB815486 February 27, 2014
815437 PRB: Windows Server 2003 System Compatibility Report Does Not List MSDE 2000 Q815437 KB815437 February 27, 2014
814571 PRB: Migrate Repository Wizard Does Not Migrate the Repository After You Install SQL Server 2000 Analysis Services Service Pack 3 Q814571 KB814571 February 27, 2014
814462 PRB: Analysis Services 2000 Service Pack 3 Setup Is Not Successful Because the RootDir Value Is Missing Q814462 KB814462 February 27, 2014
814115 PRB: LIKE Predicates Are Not Remoted to SQL Server 7.0 After You Install SQL Server 2000 Service Pack 3 Q814115 KB814115 February 27, 2014
812601 PRB: Cannot process a cube after you install SQL Server 2000 Analysis Services Service Pack 3 Q812601 KB812601 February 27, 2014
831352 PRB: Calculated Member Returns Incorrect Value When You Divide a Currency Data Type Measure with a Real Data Type Measure Q831352 KB831352 November 2, 2013
824042 PRB: The SQL Server Desktop Engine Setup Program May Stop Responding When It Is Started from an External Application Q824042 KB824042 November 2, 2013
810343 PRB: SQL Server 2000 Service Pack 3 Setup Fails If Windows Security Policy Is Set Q810343 KB810343 November 2, 2013
328721 PRB: Analysis Services Properties are Empty or Set to Zero Q328721 KB328721 November 2, 2013
328573 PRB: User in Two Roles May Cause Query Execution Failure Q328573 KB328573 November 2, 2013
320061 PRB: Error Message: "Evaluation copy has expired" May Occur After You Upgrade to Release Version of SQL Server CE Q320061 KB320061 November 2, 2013
319637 PRB: Incorrect Values Display When You Use a Count Function to View a Cube That Has a Virtual Dimension and a Measure Q319637 KB319637 November 2, 2013
319054 PRB: SELECT on a VIEW Generates an Access Violation When an 'IN' or 'OR' Clause Contains More Than 19 Values Q319054 KB319054 November 2, 2013
318898 PRB: The Merge Agent Stops Responding and You Receive the Error "The Schema Script 'File Location Pointed to a DRI Script File' Could Not Be Propagated to the Subscriber" Q318898 KB318898 November 2, 2013
317851 PRB: SQL Server CE x86 Emulation Files Do Not Work on Pocket PC 2002 Emulator Q317851 KB317851 November 2, 2013
304060 PRB: SQL Server CE Replication Error Message: 28557 : "The database is in an unusable state. " Q304060 KB304060 November 2, 2013
292724 PRB: Uninstalling SQL Server CE Version 1.1 Does Not Cause Platform Builder 3.0 to Remove Existing References Q292724 KB292724 November 2, 2013
285854 PRB: Application Error Occurs When You Run Two Instances of Replication or RDA Application on HPC Pro Devices Q285854 KB285854 November 2, 2013
282017 PRB: SQL Server 2000 Help File Contains Confusing Information About the Desktop Engine Setup Q282017 KB282017 November 2, 2013
281213 PRB: SQL Server CE Setup on Windows 2000 Error Message: The Installer Was Interrupted Q281213 KB281213 November 2, 2013
274255 PRB: ADOXCE Error Message: "..Specified type was invalid" for SQL Server CE Table Q274255 KB274255 November 2, 2013
826307 PRB: Slow Query Performance Occurs When You Run an MDX Query That References Dimension Member Properties Q826307 KB826307 October 26, 2013
328290 PRB: "Setup Was Unable to Verify the State of the Server for an Upgrade" Error Message When SQL Server Service Pack 2 Setup Stops Responding Q328290 KB328290 October 26, 2013
310663 PRB: SQLBrowseConnect Does Not Enumerate SQL Server 7.0 Servers Q310663 KB310663 October 26, 2013
307196 PRB: SQL Server 2000 Desktop Engine Error Message: "Error 126 loading library sqlcax.dll" Q307196 KB307196 October 26, 2013
290208 PRB: SQL Server CE Replication or RDA Fails When IIS Uses SHA1 Hashing Algorithm Q290208 KB290208 October 26, 2013
285865 PRB: SQL Server CE Connectivity Application Stops Responding When Network Connection is Dropped Q285865 KB285865 October 26, 2013
281983 PRB: Cannot Specify Instance Name Using SQL Server 2000 Merge Modules Q281983 KB281983 October 26, 2013
320304 PRB: A DTS Package That You Save as a Visual Basic File May Fail to Import Tab-Delimited Text Data Q320304 KB320304 October 24, 2013
317258 PRB: Member Key Column for Parent-Child Dimensions Must Be Unique Q317258 KB317258 October 24, 2013
306191 PRB: Drillthrough Queries Return More Rows than Expected If Cube Schema Is Optimized Q306191 KB306191 October 24, 2013
306039 PRB: Long Running OLAP Queries do not Return Data When Connected Through HTTP Q306039 KB306039 October 24, 2013
300099 PRB: Restoring Archive from Server with Metadata Format to Server with Access Repository Fails Q300099 KB300099 October 23, 2013
297799 PRB: Empty Cells Are Returned by a MDX Query that Uses a Non Empty Clause Q297799 KB297799 October 23, 2013
288890 PRB: Incompatible Repository Error Message Occurs After Installation of DSO on Client Computer Q288890 KB288890 October 23, 2013
286442 PRB: MDAC 2.6/2.7 Roll Back Installation or Get Error on Install Q286442 KB286442 January 17, 2013
245768 PRB: Case-Sensitive Unicode Collating Sequence and Windows NT Logins Q245768 KB245768 February 12, 2012
281517 PRB: Transfer of Data from Jet 4.0LEDB Source Fails with Buffer Overflow Error Q281517 KB281517 February 5, 2011
317746 PRB: SQL Server Full-Text Search Does Not Populate Catalogs Q317746 KB317746 August 17, 2009
298725 PRB: Scheduled DTS Package Fails With "Permission Denied: CreateObject" Q298725 KB298725 November 30, 2007
295743 PRB: SQL Server Local Temp Tables Aren't Created When Parameterized ADO Query Is Used Q295743 KB295743 November 30, 2007
823519 PRB: Windows Installer starts in Repair mode when you try to remove an instance of SQL Server 2000 on a computer that has an instance of SQL Server Desktop Engine or SQL Server Desktop Engine (Windows) Q823519 KB823519 November 2, 2007
321459 PRB: The CryptoAPI Function Generates an Error When You Try to Connect to an Instance of SQL Server 2000 Q321459 KB321459 November 2, 2007
298814 PRB: Unable to Manage Named Instances on Windows 98 or Windows ME Computers if DBCS Characters are Used to Name Instances Q298814 KB298814 November 2, 2007
303370 PRB: Memory Error When Loading Large Dimensions Q303370 KB303370 October 26, 2007
261225 PRB: TSQL PRINT Statement Breaks Lines Longer Than 255 Characters When You Use OSQL to Create a Flat File Q261225 KB261225 August 8, 2007
811030 PRB: Log Reader Agent Does Not Function and You Receive an Error Message During Transaction Replication Q811030 KB811030 May 30, 2007
816755 PRB: Error 5074 occurs when you try to drop a column from a published table Q816755 KB816755 May 18, 2007
819953 PRB: Auto Created Statistics Are Sampled by Using a Specified Sampling Rate Q819953 KB819953 May 16, 2007
811034 PRB: Inconsistent Error Handling Behavior Occurs with @@ERROR in SQL Server Q811034 KB811034 May 10, 2007
885715 Performance may decrease when you run a query to retrieve rows from a view that is created by using a UNION operation Q885715 KB885715 April 29, 2007
829746 PRB: You Cannot Create a Replication Publication If an Article Name Contains a Special Character Q829746 KB829746 April 19, 2007
289573 PRB: Configuring DSNs with SQL Server Net-Libraries Q289573 KB289573 March 27, 2007
280084 PRB: Parameters.Refresh Fails Using Parameter Token in Nested SQL Q280084 KB280084 February 23, 2007
326586 PRB: The Ordering of a Member in a Ragged Hierarchy May Not Be Correct Q326586 KB326586 February 22, 2007
314570 PRB: Cannot Modify Backup Network Share After You Change the Transaction Log Backup Folder Q314570 KB314570 February 22, 2007
307365 PRB: Cannot Connect Through Analysis Manager Although a Member of Administrator Group Q307365 KB307365 February 22, 2007
306756 PRB: Unable to Display Visual Totals Using the PivotTable Component Q306756 KB306756 February 22, 2007
305127 PRB: How to Generate a Snapshot of a Published Table and Apply It to the Subscribers Q305127 KB305127 February 22, 2007
301049 PRB: Database Loaded in Standby Mode if No Recovery Mode is Selected from Destination Database Window When You Configure Log Shipping Q301049 KB301049 February 22, 2007
298810 PRB: Deleting the Last Destination Removes Log Shipping Completely Q298810 KB298810 February 22, 2007
297211 PRB: Undocumented Filter Syntax for IReposQuery::GetCollection Method Q297211 KB297211 February 22, 2007
289872 PRB: Insufficient Room for Growth in Master or Model Databases May Corrupt the sysdepends Table in the Model Database Q289872 KB289872 February 22, 2007
287753 PRB: ExOleDB Provider Doesn't Work with SQL Server 2000 DTS Tool Q287753 KB287753 February 22, 2007
287651 PRB: Join Filter Causes Inconsistent Rows on SQL Server CE Subscriber Q287651 KB287651 February 22, 2007
301334 PRB: Connection Timeout Occurs When Connecting to a Remote OLAP Server Using an ADO Connection Q301334 KB301334 February 21, 2007
327572 PRB: You Cannot Change the Data Source for a PivotTable in Excel for an Analysis Services Connection Q327572 KB327572 February 20, 2007
307748 PRB: Duplicate Rows in Dimension Tables Inflate Measures Q307748 KB307748 February 19, 2007
303438 PRB: Unable to See All Cubes When Connecting from Excel 2000 to Analysis Services Q303438 KB303438 February 19, 2007
317268 PRB: The MSDE Installation Does Not Succeed If the Installation Computer Is Running Terminal Services in Application Server Mode Q317268 KB317268 February 12, 2007
257767 PRB: Cannot Open Pubs Table Image Data Through Microsoft Access Link Q257767 KB257767 February 12, 2007
811484 PRB: SQL Server Agent May Report Event ID: 318 Error After an Application Generates an Unhandled Exception Error with Dr. Watson as the Default Debugger Q811484 KB811484 January 10, 2007
241643 PRB: 8198 Error Message Returned from Job Owned by Windows NT Authenticated User Q241643 KB241643 November 27, 2006
918767 Programs may fail when you remove an instance of SQL Server 2000, MSDE 2000, or SQL Server 2000 Desktop Engine (Windows) Q918767 KB918767 October 12, 2006
288910 PRB: "Invalid class string" error message when opening DTS package Q288910 KB288910 July 5, 2006
811886 PRB: CryptoAPI function Error "Error 0x80090006: Invalid Signature" Connecting to SQL Server by Using SQL Server Authentication Q811886 KB811886 May 8, 2006
299410 Performing a SQL distributed query by using ADSI Q299410 KB299410 April 11, 2006
68941 Procedure for testing named pipes Q68941 KB68941 January 10, 2006
310836 PRB: SQL Server Enterprise Manager startup or service pack installation may fail with "OleMainThreadWndName: regsvr32.exe-Invalid DLL Entrypoint" error message Q310836 KB310836 December 29, 2005
268505 PRB: Deletion of rows with the same values behaves differently in SEM and Query Analyzer Q268505 KB268505 December 29, 2005
271889 PRB: Error message: "Exception Access Violation 2147221499.Need to run the object to perform this operation" occurs when you run a DTS package in Microsoft Visual Basic code Q271889 KB271889 December 28, 2005
281642 PRB: Error 14274 Occurs When You Update a SQL Agent Job After Renaming Windows Server Q281642 KB281642 December 21, 2005
329329 PRB: SQL Server 2000 Service Pack 2 (SP2) and earlier are not supported by the Microsoft Windows Server 2003 family Q329329 KB329329 December 13, 2005
262973 "Possible thread starvation detected" message may be reported in the SQL Server error log when all worker threads for a particular UMS scheduler are in a wait state in SQL Server Q262973 KB262973 December 13, 2005
305635 PRB: A Timeout Occurs When a Database Is Automatically Expanding Q305635 KB305635 December 2, 2005
302676 PRB: SQL Enterprise Manager Does Not Retain All Custom View Settings Q302676 KB302676 September 26, 2005
266277 PRB: Using the Visual Studio 6.0 and Access 2000 Visual Database Tools with SQL Server 2000 Q266277 KB266277 August 15, 2005
280067 PRB: Retrieving very large XML Documents from SQL Server 2000 by using ReadText method of ADO stream object may be slow Q280067 KB280067 June 30, 2005
154000 PRB: STR() Inconsistent with Exact Numeric Data Q154000 KB154000 March 16, 2005
151602 PRB: How to Use sp_displayoaerrorinfo in the sp_OA Samples Q151602 KB151602 March 14, 2005
135861 PRB: Datetime Rounding Up Behavior Undesirable Q135861 KB135861 March 14, 2005
47048 PRB: DATEADD Doesn't Work When Using a Variable as a Date Q47048 KB47048 March 14, 2005
164291 PRB: Proper Handling of the Escape Sequence \<cr><lf> Q164291 KB164291 March 1, 2005
135697 PRB: ISQL Without -U Parameter Uses Network User Name Q135697 KB135697 February 22, 2005
70267 PRB: Using COMPUTE with Converted Columns Q70267 KB70267 February 14, 2005
67303 PRB: Rolling Back Individual Rows from an INSERT Trigger Q67303 KB67303 February 14, 2005
64238 PRB: IF UPDATE Trigger with No Rows Changed Q64238 KB64238 February 14, 2005
302850 PRB: Upgrade to SQL Server 7.0 or SQL Server 2000 fails during "Import and Export" step Q302850 KB302850 November 17, 2004
298806 PRB: Index corruption occurs in a database that is upgraded to SQL Server 2000 Q298806 KB298806 November 17, 2004
286082 PRB: The Attach Database option and the Detach Database option are not available when you try to attach or detach a database on SQL Server 7.0 by using Enterprise Manager that was installed from SQL Server 2000 Q286082 KB286082 November 17, 2004
325818 PRB: SQL Server CE 2.0 in Visual Studio .NET 2003 Does Not Support eMbedded Visual Basic 3.0 Q325818 KB325818 November 16, 2004
291366 PRB: Upgrading SQL Server 6.5 Databases with Integrated Logins to SQL Server 7.0 or SQL Server 2000 Q291366 KB291366 November 16, 2004
324302 PRB: You cannot pass the LCID to the MSIXDS Provider to specify the connection to the Indexing Service Q324302 KB324302 October 29, 2004
326352 PRB: You receive error 3724 when you drop a non-replicated object Q326352 KB326352 October 11, 2004
298794 PRB: Population or Query of a Full Text Catalog May Stop Responding Q298794 KB298794 July 16, 2004
310542 PRB: Upgrade Wizard Fails with "Logins ID unable to open registry on the target computer." Error Message Q310542 KB310542 July 15, 2004
283845 PRB: RDO Rowcount Returns Zero For Large SQL Server Recordsets Q283845 KB283845 July 15, 2004
299314 PRB: Merge Replication to Jet 4.0 Subscribers May Fail During Process of Applying the Initial Snapshot Q299314 KB299314 July 14, 2004
296393 PRB: Attributes Are Not Generated for Fields That Contain a NULL Value When ADO Recordset Is Persisted in XML Q296393 KB296393 July 14, 2004
306216 PRB: Error "Unable to Load Communication Module" in ASP/ADO/SQL Server Q306216 KB306216 July 13, 2004
306385 PRB: CursorType Returns adOpenStatic When You Request adOpenDynamic from a Server-Side Recordset Q306385 KB306385 June 30, 2004
280134 PRB: Error When You Create SQL Server TEMP Tables Using Remote Data Objects (RDO) Q280134 KB280134 June 28, 2004
259571 PRB: DTS Connection Password Is Write Only Q259571 KB259571 June 24, 2004
220915 PRB: SQL Distributed Query with Oracle requires Oracle client and networking components Q220915 KB220915 May 13, 2004
813448 PRB: Row Size May Increase After the Datatype of a Column Is Altered Q813448 KB813448 April 12, 2004
293164 PRB: Errors May Occur When You Use SQL Server 2000 to Save a DTS Package as a Visual Basic File Q293164 KB293164 March 24, 2004
272439 PRB: SQL 2000 Profiler Doesn't Capture SHOWPLAN Events if the BinaryData Data Column Is Not Captured Q272439 KB272439 March 18, 2004
271223 PRB: sp_attach_single_file_db Does Not Work for Databases with Multiple Log Files Q271223 KB271223 February 26, 2004
285106 PRB: SQL Server Enterprise Manager Reports That the Replication Agent Is Suspect Q285106 KB285106 February 25, 2004
163069 PRB: Multiplying Numeric Datatypes May Yield Lower Precision Q163069 KB163069 February 25, 2004
247360 PRB: DTS May Skip More Rows than Specified for Fixed-Length Files Q247360 KB247360 February 24, 2004
238367 PRB: Error Message "Unspecified Error" When Executing a DTS Package Modified Dynamically Q238367 KB238367 February 24, 2004
221973 PRB: Err Msg - Duplicate Dimension Key "Product" in VBDSOCreateSmallCube Sample Application Q221973 KB221973 February 24, 2004
220163 PRB: DTS Does Not Copy Identity, Indexes, Primary Key or Other Constraints Q220163 KB220163 February 24, 2004
219176 PRB: Division by Zero Displays Results in Strange Format Q219176 KB219176 February 24, 2004
200797 PRB: OPTIMIZER LOCK HINTS Error with OpenQuery Q200797 KB200797 February 24, 2004
818883 PRB: You may receive error 7619 when you run a full-text query that contains many OR operators in the search string Q818883 KB818883 January 12, 2004
832412 PRB: You receive error message 8623 when you try to run a query that joins multiple tables Q832412 KB832412 January 2, 2004
831366 PRB: Job Status is Not Refreshed When You Connect Using Incorrect Case for the Login Name Q831366 KB831366 December 15, 2003
323920 PRB: Run-Time Error When You Use SQLXML 2.0 with ADO to Execute an Updategram Q323920 KB323920 December 5, 2003
286370 PRB: OpenQuery Function Fails with Queries That Exceed 8000 Characters Q286370 KB286370 December 5, 2003
272358 PRB: SQLOLEDB Allows Only One Connection in Scope of Transaction Q272358 KB272358 December 5, 2003
240340 PRB: SQL Distributed Query with Oracle Causes "Could not open table" Error Q240340 KB240340 December 5, 2003
296537 PRB: Sharing Violation Occurs with Operating System Job That Runs Batch File That Echoes Text to Ouput File Q296537 KB296537 December 3, 2003
63212 PRB: Assignment of NULL Value to Local Variable in SQL Q63212 KB63212 December 3, 2003
827448 PRB: Creating New Database Objects Fails in a SQL Server Database Q827448 KB827448 December 2, 2003
296711 PRB: "Unspecified error" Error 7399 Using OPENROWSET Against Jet Database Q296711 KB296711 December 1, 2003
203312 PRB: Cannot Register Server if Password Exceeds 60 Characters Q203312 KB203312 November 21, 2003
200796 PRB: SQL Enterprise Manager Requires Uppercase for Linked Server Name Q200796 KB200796 November 21, 2003
289278 PRB: Setting DBPROP_REMOVEDELETED Property to VARIANT_FALSE Fails to Open Fast-Forward Cursor Q289278 KB289278 November 17, 2003
327520 PRB: User Principal Names Are Not Supported by SQL Server 7.0 or SQL Server 2000 Q327520 KB327520 November 14, 2003
321456 PRB: SQL 6.5 Upgrade Results in Errors 4850 and 4851 Q321456 KB321456 November 14, 2003
319048 PRB: Cannot Use Data Transformation Services Event Handlers in Visual Basic with Execute Package Task Q319048 KB319048 November 14, 2003
303104 PRB: Unable to Save DTS Package to SQL Server When You Use Windows NT 4.0 French Localized Version Q303104 KB303104 November 14, 2003
281345 PRB: Dialog Box Opens During Backup Process Prompting You To Insert Disk in Drive A Q281345 KB281345 November 14, 2003
281126 PRB: System Tables Missing Primary Key Information After Upgrade from SQL Server 6.x to SQL Server 7.0 or SQL Server 2000 Q281126 KB281126 November 14, 2003
274472 PRB: BCP 'in' May Cause Exception When Input File Last Column Is Datatype DATETIME Q274472 KB274472 November 14, 2003
259372 PRB: Some Arguments in sp_sproc_columns and sp_columns Support Wildcard Pattern Matching Q259372 KB259372 November 14, 2003
248158 PRB: Select From Database on CD-ROM May Return Error 601 Q248158 KB248158 November 14, 2003
243198 PRB: Renaming Stored Procedure, View or Trigger does not update SYSCOMMENTS table Q243198 KB243198 November 14, 2003
253673 PRB: Recordset Based on SQL Server View Updates Base Tables Q253673 KB253673 November 7, 2003
263076 PRB: SQL Server 2000 Install May Fail Due to 'mfc42u.dll' Q263076 KB263076 November 6, 2003
252225 PRB: An Error Message Occurs With a Distributed Query That Has A Named Instance Q252225 KB252225 November 5, 2003
286213 PRB: Second Parameterized Command Fails with Server Cursor Q286213 KB286213 November 3, 2003
236789 PRB: Full-Text Catalog May Be Lost After Restoring Suspect Database Using WITH REPLACE Q236789 KB236789 November 3, 2003
220169 PRB: Keyset Cursor Based Off a Join Not Showing New Records Q220169 KB220169 November 3, 2003
218172 PRB: Cannot Change SA Password in Enterprise Manager Q218172 KB218172 November 3, 2003
295026 PRB: Errors When You Redistribute SQL Server 2000 DMO Clients in SQL Server 7.0 Environment Q295026 KB295026 October 31, 2003
293320 PRB: DTS Transfer From SQL Server to Oracle Through OLE DB Provider Shows Ongoing Private Bytes Consumption Q293320 KB293320 October 31, 2003
292588 PRB: Data Transformation Services May Fail to Import DBCS File Using Fixed Field Q292588 KB292588 October 31, 2003
288745 PRB: DBCC CHECKDB Reports Error Message 2501 During Database Activity Q288745 KB288745 October 31, 2003
275680 PRB: Bulk Operations into Tables Result in Rows Not Replicated in Merge Replication Q275680 KB275680 October 31, 2003
252439 PRB: Use of Math Operations with DTS and Numeric Data Types Q252439 KB252439 October 31, 2003
249901 PRB: DTS Diagram Changes When DTS Package is Opened and Saved Outside the Package Designer Q249901 KB249901 October 31, 2003
241371 PRB: Cube Design and Processing Problems Working with GUID Data Type Q241371 KB241371 October 31, 2003
238678 PRB: RebuildM Cannot Find Original Master Database Files for MSDE Installation Q238678 KB238678 October 31, 2003
327056 PRB: SQL Server Enterprise Manager Inserts Extra Spaces in a View's Column Names Q327056 KB327056 October 30, 2003
318819 PRB: A DTS Package Raises Exceptions or Stops Responding When You Run It as a Scheduled Job Q318819 KB318819 October 30, 2003
313178 PRB: Error Establishing Socket with JDBC Driver Q313178 KB313178 October 30, 2003
308843 PRB: Non-Unique Clustered Index on a Published Table Causes Incorrect Data to Replicate to Subscribers Q308843 KB308843 October 30, 2003
301076 PRB: Unable to Connect to SQL Server Through ODBC When Password Contains a Semi-colon Q301076 KB301076 October 30, 2003
274188 PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete Q274188 KB274188 October 30, 2003
247825 PRB: DTS Copy Table Uses Table Schema of Existing Table Q247825 KB247825 October 30, 2003
255067 PRB: Owner of a Table Cannot Access It Directly If Made Sysadmin After Creation Q255067 KB255067 October 29, 2003
216808 PRB: Use BUILTIN\Group to Grant Access to Predefined Windows NT Groups Q216808 KB216808 October 29, 2003
200794 PRB: Sp_addlinkedserver Does Not Validate the OLE DB Provider Q200794 KB200794 October 29, 2003
309392 PRB: BobMgr::GetBuf() Errors May Be Registered in the SQL Server Error Log Q309392 KB309392 October 28, 2003
238146 PRB: Constraint Violation Is Not Detected If Update with the Same Data Q238146 KB238146 October 28, 2003
824423 PRB: Restore Operation May Fail When You Try to Restore a SQL Server 2000 Database in SQL Server 7.0 Q824423 KB824423 October 23, 2003
279099 PRB: Application Center 2000 Installation Fails with Wait Operation Timed Out When You Set MSDE Security Q279099 KB279099 October 23, 2003
811899 PRB: Error 4928 Occurs When You Try to Rename a Non-Replicated Column Q811899 KB811899 October 17, 2003
324711 PRB: You Cannot See the Edit Insertion Point in SQL Server Enterprise Manager When You Edit a Table Row Q324711 KB324711 October 17, 2003
324192 PRB: SQL Server Maintenance Wizard Does Not Allow Scheduled Filegroup or Differential Backups Q324192 KB324192 October 17, 2003
323607 PRB: Unable to View the Properties for a Database Maintenance Plan Q323607 KB323607 October 17, 2003
321670 PRB: Backup Size Displayed Incorrectly in SQL Server Enterprise Manager When the Backup Size is Greater Than 2,147,483,647 Bytes (2 GB) Q321670 KB321670 October 17, 2003
321283 PRB: The MSDE Installation May Fail and Error 126 Is Logged When You Are Using Windows Installer Software Q321283 KB321283 October 17, 2003
313969 PRB: The Error "Cannot Open .pst File" Occurs When You Use a POP3 Server Profile with SQL Mail Q313969 KB313969 October 17, 2003
306366 PRB: Errors 3437, 3414, and "Could Not Connect to DTC" Occur When You Start SQL Server Q306366 KB306366 October 17, 2003
304096 PRB: Trigger Does Not Fire on View When Updated Through ADO Q304096 KB304096 October 17, 2003
303445 PRB: ObjectID Filter in SQL Profiler Triggers Only with Specific Events Q303445 KB303445 October 17, 2003
295371 PRB: Filegroup Log Restore May Fail with Error Message 4305 Q295371 KB295371 October 17, 2003
281664 PRB: You Must Select the Include All Dependent Objects Checkbox that Depend on Other Objects in DTS Q281664 KB281664 October 17, 2003
280759 PRB: SQL 7.0 VDI Backup May Fail When SQL Server 2000 Is Installed on the Same Computer Q280759 KB280759 October 17, 2003
279108 PRB: OSQL Utility Cannot Run Under Hindi Locale/Indic Language Setting on Window 2000 Q279108 KB279108 October 17, 2003
274390 PRB: Rebuildm.exe not Available After You Upgrade MSDE Edition to SQL Server 2000 Q274390 KB274390 October 17, 2003
270671 PRB: Full Text Search Menus Are Not Enabled for Local Windows NT Accounts Q270671 KB270671 October 17, 2003
269558 PRB: SQL Server Upgrade Wizard Generates a Warning for Stored Procedures Created with '.object_name' or '..object_name' Q269558 KB269558 October 17, 2003
269426 PRB: Use of FULL OUTER JOIN with TEXT Column Through a Linked Server Returns Error Message 8626 Q269426 KB269426 October 17, 2003
264593 PRB: RESTORE WITH STANDBY Does Not Catch Invalid or ReadOnly File Name Until After the Load Q264593 KB264593 October 17, 2003
262951 PRB: System Stored Procedures Return Underlying SQL Code or Unexpected Results Q262951 KB262951 October 17, 2003
260652 PRB: Nested Loop Join That Uses A "BOOKMARK LOOKUP ...WITH PREFETCH" May Hold Locks Longer Q260652 KB260652 October 17, 2003
259710 PRB: SQL Server Agent Fails to Start on Windows 9x When You Change the sa Password Q259710 KB259710 October 17, 2003
254492 PRB: Views Fail to Upgrade Q254492 KB254492 October 17, 2003
244513 PRB: Scheduled SQL Server Backups Display "BackupTapeFile::WriteFileMark: WriteTapemark failure" Error Q244513 KB244513 October 17, 2003
243023 PRB: Error 8104 Occurs with Non-Admin Owner Using Set IDENTITY_INSERT Q243023 KB243023 October 17, 2003
240839 PRB: Pressing ESC When Modifying SP in SEM Erases Changes Without Prompting Q240839 KB240839 October 17, 2003
217034 PRB: Two Digit Year Display of Date Fields in SQL Enterprise Manager (SEM) Q217034 KB217034 October 17, 2003
814579 PRB: You Receive Error Message: "The log file for database 'Database Name' is full" While Restoring a SQL Server 7.0 Database Backup on SQL Server 2000 Q814579 KB814579 October 16, 2003
813199 PRB: SQL Server Books Online Incorrectly States the Type of Result Set for @@CPU_BUSY, @@IO_BUSY and @@IDLE Functions Is Milliseconds Instead of Ticks Q813199 KB813199 October 16, 2003
811483 PRB: You Receive a Warning Message When You Create a Recursive Stored Procedure Q811483 KB811483 October 16, 2003
325187 PRB: Consecutively Declaring Nested Cursors Immediately Returns a FETCH_STATUS Value of -1 Q325187 KB325187 October 16, 2003
323596 PRB: You Can Only Use the Sp_grantlogin Stored Procedure with Windows NT Group Names That Are Less Than or Equal to 63 Characters Q323596 KB323596 October 16, 2003
323586 PRB: A SELECT INTO Query May Return the Internal Query Processor Error 8630 Q323586 KB323586 October 16, 2003
322746 PRB: Data Transformation Services Jobs May Fail Because the Path for Dtsrun.exe Cannot Be Found Q322746 KB322746 October 16, 2003
320773 PRB: Changes to a Table That Is Part of an "Immediate Updating" Subscription Generates an Error Message Q320773 KB320773 October 16, 2003
320208 PRB: Distributed Queries That Are Wrapped in a Stored Procedure with Input Parameters May Experience Performance Degradation Q320208 KB320208 October 16, 2003
317832 PRB: Subscriptions in System Databases Not Supported Q317832 KB317832 October 16, 2003
315868 PRB: Query Can Not Be Executed in SQL Enterprise Manager Query Designer on Windows XP Q315868 KB315868 October 16, 2003
305365 PRB: DTS Package Fails with "Unspecified Error" Error Message When You Use Transfer Logins Task to Move a SQL Server Login Q305365 KB305365 October 16, 2003
301299 PRB: Security Context of Dynamic SQL Statements Inside a Stored Procedure Q301299 KB301299 October 16, 2003
299354 PRB: DTS Execute Package Task May Fail to Execute Child Package Q299354 KB299354 October 16, 2003
298674 PRB: Subquery Resolves Names of Column to Outer Tables Q298674 KB298674 October 16, 2003
297861 PRB: Poor Performance on a Heap Q297861 KB297861 October 16, 2003
296792 PRB: Expired Subscription Cleanup Agent Fails if the First Published Database is Deleted Q296792 KB296792 October 16, 2003
296559 PRB: ALTER COLUMN Sets TrimTrailingBlanks Property to NO Q296559 KB296559 October 16, 2003
295305 PRB: Creating Temp Table Inside IF and ELSE Conditions Gives Error 2714 Q295305 KB295305 October 16, 2003
294942 PRB: SET CONCAT_NULL_YIELDS_NULL May Cause Stored Procedures to Recompile Q294942 KB294942 October 16, 2003
291263 PRB: Custom Stored Procedure Resolvers Don't Fire When Conflict Involves UPDATE and DELETE Q291263 KB291263 October 16, 2003
287515 PRB: Execution Plan and Results of Aggregate Concatenation Queries Depend Upon Expression Location Q287515 KB287515 October 16, 2003
284997 PRB: Information About Use of LIKE Operator to Convert String to Datetime Query Q284997 KB284997 October 16, 2003
281676 PRB: Converting Datetime to Another Datatype May Result in Inaccurate Value Q281676 KB281676 October 16, 2003
281341 PRB: Loss of Precision May Occur When You Use SUM or AVG Functions In a Formula with Division Q281341 KB281341 October 16, 2003
280834 PRB: Query Analyzer Returns Error Message When You Select NEWID() After You Reduce the Maximum Characters Per Column Q280834 KB280834 October 16, 2003
280684 PRB: Merge Replication Fails with "Process could not enumerate changes" Error Message When Assigning a Blank Value to an Image Column Q280684 KB280684 October 16, 2003
280406 PRB: Dynamic Cursor Infinite Loop When a Non-Unique Clustered Index Key Is Updated to an Equal or Larger Value Q280406 KB280406 October 16, 2003
280295 PRB: sp_attach_db and CREATE DATABASE FOR ATTACH Do Not Remove Replication Tables Q280295 KB280295 October 16, 2003
278984 PRB: Error 7321 Occurs When You Run a Query That Uses Four-Part Names Against DB2 on an AS/400 Computer Q278984 KB278984 October 16, 2003
278612 PRB: Installing SQL Server 7.0 Fails If SQL Server 2000 Is Already Installed Q278612 KB278612 October 16, 2003
275583 PRB: SELECT...FOR XML AUTO Results Are Separated into Lines of 2033 Chars with ODBC Q275583 KB275583 October 16, 2003
274747 PRB: Registered Remote SQL Servers May Be Lost from SQL Server 2000 Enterprise Manager Q274747 KB274747 October 16, 2003
270054 PRB: Indexed Views Can Be Created on All Versions of SQL Server 2000 Q270054 KB270054 October 16, 2003
268593 PRB: Querying a DATETIME Value Without Quotes Gives Unexpected Results Q268593 KB268593 October 16, 2003
241511 PRB: REPL: Msgs. 20515, 21054, or 20512 with Immediate-Updating Subscribers Q241511 KB241511 October 16, 2003
277002 PRB: Distributed Query Against Oracle 8.x Fails Q277002 KB277002 October 15, 2003
322988 PRB: sp_grantlogin "NT AUTHORITY\SYSTEM" Fails on Microsoft Windows NT 4.0 Q322988 KB322988 October 9, 2003
308604 PRB: SQLMail Is Not Supported When You Run the Server in Fiber Mode Q308604 KB308604 October 9, 2003
814577 PRB: "Incorrect Syntax Near" Error When You Run the DBCC CHECKCONSTRAINTS Statement Q814577 KB814577 October 3, 2003
811036 PRB: SQL Server Returns English Format for Numeric Data Regardless of the Collation Settings Q811036 KB811036 October 3, 2003
811035 PRB: The xp_sendmail Stored Procedure Fails with Error 0x80070005 When the Mailbox of the SQL Mail Profile is Different From the MSSQLServer Service Startup Domain Account Default Mailbox Q811035 KB811035 October 3, 2003
811028 PRB: You Receive Error Message: "Failed to enumerate changes in the filtered articles" When the SQL Server Merge Agent Fails Q811028 KB811028 October 3, 2003
331451 PRB: Copy Database Wizard Does Not Copy Server Roles When it Transfers Logins Q331451 KB331451 October 3, 2003
331450 PRB: The Copy Database Wizard Does Not Copy the Default Database Information for Logins Q331450 KB331450 October 3, 2003
330582 PRB: "No Data Was Provided for Column" Error Message When You Propagate Identity Column with SQLXMLBulkLoad Q330582 KB330582 October 3, 2003
328173 PRB: A Database User Cannot Debug Stored Procedures That Another User Owns Q328173 KB328173 October 3, 2003
324559 PRB: You Are Prompted for the CD Key During the SQL Server 2000 Evaluation Edition Remote Installation Q324559 KB324559 October 3, 2003
324417 PRB: An XLOCK Hint in a Serializable Transaction May Be Ignored Q324417 KB324417 October 3, 2003
324361 PRB: Automatic Identity Range Handling Is Not Correct If the Merge Agent Runs an Insert Trigger Q324361 KB324361 October 3, 2003
323249 PRB: "Error 229: Execute Permission Denied on Object 'xp_availablemedia' Owner 'dbo'" Q323249 KB323249 October 3, 2003
319138 PRB: User-Defined Function Call in Four-Part Linked Server Query Fails with Error Message 170 Q319138 KB319138 October 3, 2003
318241 PRB: SQL Server 2000 Views Not Replicated to Microsoft Access Through Merge Replication Q318241 KB318241 October 3, 2003
317391 PRB: Pull Subscription Status Is "Never Started" If Job Name Is More Than 100 Characters Q317391 KB317391 October 3, 2003
316371 PRB: SQLXMLBulkLoad Error Message 80040E14: "File Could Not Be Opened" or "File Does Not Exist" Q316371 KB316371 October 3, 2003
316361 PRB: SQLXMLBulkLoad Error Message 80046000: "The System Cannot Find The Path Specified" Q316361 KB316361 October 3, 2003
312637 PRB: SQL Server 2000 Service Pack 2 Setup Fails on a Server That Has Certificates Installed and Force Protocol Encryption Set ON Q312637 KB312637 October 3, 2003
312323 PRB: Cannot Pass Function as Parameter to Table Valued User Defined Function Q312323 KB312323 October 3, 2003
312106 PRB: Distribution Agent Fails After You Apply Replication Scripts Q312106 KB312106 October 3, 2003
309435 PRB: SQL 2000 Server Fails to Start Due to Exception Access Violation After You Configure a High Lock Value Q309435 KB309435 October 3, 2003
308886 PRB: NOLOCK Optimizer Hint May Cause Transient Corruption Errors in the SQL Server Error Log Q308886 KB308886 October 3, 2003
308771 PRB: A Full-Text Search May Not Return Any Hits If It Fails to Index a File Q308771 KB308771 October 3, 2003
307482 PRB: Foreign Key Conflicts at Merge Subscriber Result in DELETE During Next Upload Q307482 KB307482 October 3, 2003
305704 PRB: Windows Collations Ignore Single Quote and Hyphen When Ordering Q305704 KB305704 October 3, 2003
305192 PRB: OSQL Error Message Leaves Out ODBC Header Information Q305192 KB305192 October 3, 2003
304535 PRB: ANSI Warnings May Incorrectly Show Replication Agents As Failed Q304535 KB304535 October 3, 2003
304346 PRB: Schema Definition of Base Table at Subscriber Does Not Match Table in Publisher Database Q304346 KB304346 October 3, 2003
300385 PRB: Error 7321 When Executing a Select Statement to Query a Linked Server Using the Exchange OLE DB Provider Q300385 KB300385 October 3, 2003
300365 PRB: DTS FTP Task Does Not Allow User to Return to Parent Directory from an Empty Folder Q300365 KB300365 October 3, 2003
299518 PRB: Update Statistics Statement Without Fullscan Option Returns Wrong Density Value Q299518 KB299518 October 3, 2003
286134 PRB: Cannot Update Partitioned View After BCP or BULK INSERT into Base Table Q286134 KB286134 October 3, 2003
279434 PRB: Limitations of OpenXML in SQL Server 2000 Q279434 KB279434 October 3, 2003
279430 PRB: sp_xml_preparedocument Stored Procedure Fails with Error 6603 Q279430 KB279430 October 3, 2003
279078 PRB: Access Violation Occurs with the Use of OpenXML in a User-Defined Function Q279078 KB279078 October 3, 2003
278274 PRB: Index Tuning Wizard Does Not Suggest Proper Index When There Is Not Enough Space Q278274 KB278274 October 3, 2003
272706 PRB: Restarting a Paused Profiler Trace May Return General Network Error Q272706 KB272706 October 3, 2003
271853 PRB: READTEXT on Text Nullable Columns May Fail at a Replication Subscriber Q271853 KB271853 October 3, 2003
270600 PRB: Index Tuning Wizard May Not Recommend Indexes for SQL Statements in Triggers Q270600 KB270600 October 3, 2003
270013 PRB: Cannot Update Distributed Partitioned Views When You Alter Base Table Constraints Q270013 KB270013 October 3, 2003
270007 PRB: If You Update Partitioned Column on a Distributed Partitioned View Error 8626 May Occur When the Base Table has TEXT Column Q270007 KB270007 October 3, 2003
173843 PRB: Microsoft ESQL for C Generates Compiler Error with an Array Q173843 KB173843 October 3, 2003
317312 PRB: Unexpected Warning About Eliminating NULLs from Aggregate Q317312 KB317312 September 25, 2003
310421 PRB: Behavior Change for SUBSTRING with Starting Position Less Than One Q310421 KB310421 September 25, 2003
811008 PRB: You Receive Error Message: "The replication agent is not registered properly" When the SQL Server Replication Agent Fails Q811008 KB811008 September 24, 2003
824106 PRB: "ResultSet Can Not Re-Read Row Data"' Error When Reading Data from a JDBC ResultSet Object Q824106 KB824106 September 23, 2003
240882 PRB: Stored Procedure Calls May Result in Attentions Being Seen on SQL Server Q240882 KB240882 September 17, 2003
811887 PRB: Error 17882 "Error Accepting Connection Request via Net-Library 'SSNETLIB'. Execution Continuing" When You Connect to SQL Server Q811887 KB811887 September 16, 2003
239759 PRB: Error 5177 May Be Raised When Creating Databases Q239759 KB239759 August 12, 2003
280836 PRB: 'Read From Remote' Does Not Display Registered Servers in Enterprise Manager Q280836 KB280836 August 4, 2003
313181 PRB: Cannot Start a Cloned Connection While in Manual Transaction Mode Q313181 KB313181 June 30, 2003
316779 PRB: Clients with Force Protocol Encryption Set On May Fail to Connect with an IP Address Q316779 KB316779 June 13, 2003
816499 PRB: "Setup Failed to Configure the Server" Error Message When You Install MSDE Q816499 KB816499 June 10, 2003
810426 PRB: Error Message: "28037: HttpSendRequest failed;…" Occurs with SQL Server CE Application Q810426 KB810426 May 29, 2003
194014 PRB: Data Designer Does Not Support CASE Statements in Views Q194014 KB194014 May 29, 2003
327080 PRB: SQL Server datetime Values Are Randomly Rounded Up in ADO Application Q327080 KB327080 May 28, 2003
820220 PRB: 0x80070005 or 0x80040005 Error Occurs When You Send E-Mail by Using the Xp_sendmail Extended Stored Procedure Q820220 KB820220 May 8, 2003
308980 PRB: Native Error Is Not Sent Back to ADO When You Run a SQL XML Query Q308980 KB308980 May 8, 2003
306388 PRB: CursorType Returns adOpenStatic from Server-Side Recordset and Behaves Like a Forward-Only Recordset Q306388 KB306388 May 8, 2003
305333 PRB: Error "INSERT Failed" When You Update Table Referenced in an Indexed View Q305333 KB305333 May 8, 2003
297502 PRB: Error -2147217887 "No Error Description" When You Send SQL Text Field to Output Stream Q297502 KB297502 May 8, 2003
811890 PRB: Error Message: "Unable to copy the initialization file..." Occurs When You Set Up Log Shipping Between Two Clustered SQL Server Servers Q811890 KB811890 April 30, 2003
811881 PRB: "Internal Error 2755. 1632, C:\MSDE\setup\SqlRun01.msi" Setup Error with Microsoft SQL Server 2000 Desktop Engine Q811881 KB811881 January 27, 2003
313220 PRB: Unexpected Connections to SQL Server with JDBC Q313220 KB313220 June 5, 2002
271887 PRB: Desktop Engine Upgrade of MSDE 1.0 Fails Q271887 KB271887 July 28, 2001

SQL Server 2000 articles, fixes and updates - letter P