SQL Server 2000 articles, fixes and updates - April 2018

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

• 916287 A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2187 Q916287 KB916287 April 23, 2018
• 810826 INF: New Switches in MSDE Service Pack 3 Setup Q810826 KB810826 April 23, 2018
• 260418 Frequently asked questions - SQL Server 2000 - Server Q260418 KB260418 April 23, 2018
• 956160 You receive an error message when you try to access Reporting Services after you repair a failed upgrade from SQL Server 2000 Reporting Services to SQL Server 2008 Reporting Services Q956160 KB956160 April 21, 2018
• 884012 You may not be able to connect to an instance of SQL Server 2000 Service Pack 2 or earlier that is installed on a Windows Server 2003 computer through the TCP/IP port Q884012 KB884012 April 21, 2018
• 840219 You may not be able to connect to a SQL Server that is running on a Windows Server 2003 computer by using Windows authentication Q840219 KB840219 April 21, 2018
• 318432 BUG: Cannot connect to a clustered named instance through a firewall Q318432 KB318432 April 21, 2018
• 243899 How to access additional information about errors that are returned when you use the OLE Automation system stored procedures Q243899 KB243899 April 21, 2018
• 953740 How to identify and enable disabled SQL Server instances in SQL Server 2000 Q953740 KB953740 April 20, 2018
• 943471 Error messages when you create a snapshot backup of many databases at the same time in SQL Server: "ERROR Selected writer 'Microsoft Writer (Service State)' is in failed state" Q943471 KB943471 April 20, 2018
• 924947 SQL Server significantly increases the unused space for some tables Q924947 KB924947 April 20, 2018
• 920769 How to use custom assemblies or embedded code in Reporting Services Q920769 KB920769 April 20, 2018
• 906566 How to use XQuery to query XML data from a SQL Server 2000 database in SQL Server 2005 Q906566 KB906566 April 20, 2018
• 842423 A call to the AuthzInitializeContextFromSid API function fails during the delivery of an e-mail subscription in SQL Server Reporting Services Q842423 KB842423 April 20, 2018
• 839569 You may not be able to connect to an instance of SQL Server by using an anonymous login Q839569 KB839569 April 20, 2018
• 827575 SQL Server does not finish execution of a large batch of SQL statements Q827575 KB827575 April 20, 2018
• 827452 FIX: General network error when you try to back up or restore a SQL Server database on a computer that is running Windows Server 2003 Q827452 KB827452 April 20, 2018
• 818182 You receive an "Unspecified error" error message when SQL Server accesses a linked server that uses Microsoft OLE DB provider for Jet 4.0 Q818182 KB818182 April 20, 2018
• 816701 Error message: OLE DB provider SQLOLEDB was unable to begin a distributed transaction Q816701 KB816701 April 20, 2018
• 815154 HOW TO: Configure SQL Server Security for .NET Applications Q815154 KB815154 April 20, 2018
• 555266 How to pass array of values into SQL Server stored procedure using XML and Visual Basic .NET Q555266 KB555266 April 20, 2018
• 555070 Posting Message to MSMQ from SQL Server Q555070 KB555070 April 20, 2018
• 329133 Description of error message 14420 and error message 14421 that occur when you use log shipping in SQL Server Q329133 KB329133 April 20, 2018
• 328383 SQL Server clients may change protocols when the client computers try to connect to an instance of SQL Server Q328383 KB328383 April 20, 2018
• 327817 Use the "-SkipErrors" parameter in Distribution Agent cautiously Q327817 KB327817 April 20, 2018
• 325335 How to transfer a database from one collation to another collation in SQL Server Q325335 KB325335 April 20, 2018
• 324401 How to manually remove a replication in SQL Server 2000 or in SQL Server 2005 Q324401 KB324401 April 20, 2018
• 322112 Comparing SQL collations to Windows collations Q322112 KB322112 April 20, 2018
• 321247 How to configure security for SQL Server log shipping Q321247 KB321247 April 20, 2018
• 319942 How to determine proper SQL Server configuration settings Q319942 KB319942 April 20, 2018
• 318605 How SQL Server uses a certificate when the Force Protocol Encryption option is turned on Q318605 KB318605 April 20, 2018
• 316872 Error message occurs when you use OLE DB Provider for SQL Server in ADO.NET: "Cannot start more transactions on this session" Q316872 KB316872 April 20, 2018
• 316749 There may not be enough virtual memory when you have a large number of databases in SQL Server Q316749 KB316749 April 20, 2018
• 315521 How to troubleshoot SQL Server merge replication problems Q315521 KB315521 April 20, 2018
• 313295 How to use the server name parameter in a connection string to specify the client network library Q313295 KB313295 April 20, 2018
• 311209 HOW TO: Configure ASP.NET for Persistent SQL Server Session State Management Q311209 KB311209 April 20, 2018
• 309256 How to troubleshoot SQL Server error 8645 Q309256 KB309256 April 20, 2018
• 306212 How to troubleshoot error 7391 that occurs when you use a linked server in SQL Server Q306212 KB306212 April 20, 2018
• 303722 How to grant access to SQL logins on a standby database when the guest user is disabled in SQL Server Q303722 KB303722 April 20, 2018
• 303229 A transaction log backup job that is created in Database Maintenance Planner fails to execute Q303229 KB303229 April 20, 2018
• 301934 INF: MDX: How to Determine the First or Last Member with Data Q301934 KB301934 April 20, 2018
• 301901 INF: TCP Ports Used by OLAP Services when Connecting Through a Firewall Q301901 KB301901 April 20, 2018
• 301637 INF: How to Calculate the Cumulative Value of a Measure Q301637 KB301637 April 20, 2018
• 300488 How to run SQL Server stored procedures from an ASP Page Q300488 KB300488 April 20, 2018
• 300183 FIX: SQL Server cluster resource fails to come online until the cluster service is restarted Q300183 KB300183 April 20, 2018
• 298402 INF: Understanding How to Set the SQL Server I/O Affinity Option Q298402 KB298402 April 20, 2018
• 298147 You receive an "Invalid Class String" error when SQL Server connects to a Cluster Server through the Cluster Administrator Q298147 KB298147 April 20, 2018
• 295732 How to create databases or change disk file locations on a shared cluster drive on which SQL Server was not originally installed Q295732 KB295732 April 20, 2018
• 295108 Incomplete transaction may hold large number of locks and cause blocking Q295108 KB295108 April 20, 2018
• 288809 How to recover SQL Server after a tempdb database is marked suspect Q288809 KB288809 April 20, 2018
• 288577 How to troubleshoot problems that occur when you use a Database Maintenance plan in SQL Server Q288577 KB288577 April 20, 2018
• 270119 Error messages when you perform an UPDATE, INSERT, or DELETE Transact-SQL statement on a remote table by using the OpenQuery function: "7357" and "7320" Q270119 KB270119 April 20, 2018
• 264154 You must start an instance of SQL Server in single-user mode when you use DBCC CHECKDB/CHECKTABLE with REPAIR options Q264154 KB264154 April 20, 2018
• 246800 How to correctly parse quotation marks in Full Text Search queries Q246800 KB246800 April 20, 2018
• 243588 How to troubleshoot the performance of Ad-Hoc queries in SQL Server Q243588 KB243588 April 20, 2018
• 238254 UPDATE Statements May be Replicated as DELETE/INSERT Pairs Q238254 KB238254 April 20, 2018
• 235880 You receive an "Error 605" error message when you run a query with the optimizer hint NOLOCK or you set the transaction isolation level to READ UNCOMMITTED in SQL Server Q235880 KB235880 April 20, 2018
• 232580 Description of storing UTF-8 data in SQL Server Q232580 KB232580 April 20, 2018
• 217395 You receive an "Error 18482" error message when you try to make a remote procedure call (RPC) from one server to another in SQL Server Q217395 KB217395 April 20, 2018
• 199037 How to capture error messages that are sent to clients from an instance of SQL Server Q199037 KB199037 April 20, 2018
• 175574 How to rotate a table in SQL Server Q175574 KB175574 April 20, 2018
• 168001 User logons and permissions on a database may be incorrect after the database is restored Q168001 KB168001 April 20, 2018
• 137983 How to troubleshoot orphaned connections in SQL Server Q137983 KB137983 April 20, 2018
• 70956 How to remove duplicate rows from a SQL Server table by using a script Q70956 KB70956 April 20, 2018
• 69133 How to convert CHAR values into DATETIME values in SQL Server Q69133 KB69133 April 20, 2018
• 939422 Events and Errors help for Windows Server 2008 and Windows Server 2008 R2 offers detailed explanations, recommendations, and additional resources that apply to event IDs Q939422 KB939422 April 19, 2018
• 899599 A BizTalk Server Host instance fails, and a "General Network" error is written to the Application log when the BizTalk Server-based server processes a high volume of documents Q899599 KB899599 April 19, 2018
• 839279 You may receive a 7391 error message in SQL Server 2000 when you run a distributed transaction against a linked server after you install Windows Server 2003 or Windows XP Service Pack 2 Q839279 KB839279 April 19, 2018
• 830575 Backup fails on a computer that is running Small Business Server 2003 Q830575 KB830575 April 19, 2018
• 829142 How to dynamically page through a large result set in ASP.NET by using SQL Server stored procedures in Visual C# .NET Q829142 KB829142 April 19, 2018
• 822499 Naming schema and Fix area descriptions for SQL Server software update packages Q822499 KB822499 April 19, 2018
• 328551 Concurrency enhancements for the tempdb database Q328551 KB328551 April 19, 2018
• 321081 Installation of MSDE creates an 'sa' account with a blank password in Visio Q321081 KB321081 April 19, 2018
• 319930 How to connect to an instance of SQL Server Desktop Edition or of SQL Server 2005 Express Edition Q319930 KB319930 April 19, 2018
• 312839 How to send e-mail without using SQL Mail in SQL Server Q312839 KB312839 April 19, 2018
• 308157 How To Implement Forms-Based Authentication in Your ASP.NET Application by Using Visual Basic .NET Q308157 KB308157 April 19, 2018
• 307002 PRB: ASP/ODBC/SQL Server Error 0x80040E4D "Login Failed for User '(Null)'" Q307002 KB307002 April 19, 2018
• 305977 INF: Frequently Asked Questions - SQL Server 2000 - Table Variables Q305977 KB305977 April 19, 2018
• 290991 How to manually remove SQL Server 2000 default, named, or virtual instance Q290991 KB290991 April 19, 2018
• 290212 INF: List of Bugs Fixed in SQL Server 2000 Service Pack 1 (1 of 2) Q290212 KB290212 April 19, 2018
• 290211 How to obtain the latest SQL Server 2000 service pack Q290211 KB290211 April 19, 2018
• 283811 How to change the SQL Server or SQL Server Agent service account without using SQL Enterprise Manager in SQL Server 2000 or SQL Server Configuration Manager in SQL Server 2005 Q283811 KB283811 April 19, 2018
• 272318 INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE Q272318 KB272318 April 19, 2018
• 271509 How to monitor blocking in SQL Server 2005 and in SQL Server 2000 Q271509 KB271509 April 19, 2018
• 269541 Error message when you connect to SQL Server if the Windows NT LM Security Support Provider registry key is missing: "cannot generate SSPI context" Q269541 KB269541 April 19, 2018
• 268591 The Sql.log file may consume all disk space and cause SQL Server to run slowly when you turn on ODBC Tracing Q268591 KB268591 April 19, 2018
• 169377 How to access SQL Server in Active Server Pages Q169377 KB169377 April 19, 2018
• 967576 Microsoft SQL Server Database Engine Input/Output requirements Q967576 KB967576 April 18, 2018
• 908915 FIX: You receive an error message when you use Microsoft OLE DB Provider for Visual FoxPro in SQL Server Q908915 KB908915 April 18, 2018
• 260414 Frequently asked questions - SQL Server 2000 - multiple instances Q260414 KB260414 April 18, 2018
• 888228 You receive a "SQL Server does not exist or access denied" error message when you try to connect to a SQL Server named instance in a cluster by using TCP/IP sockets Q888228 KB888228 April 17, 2018
• 883732 A SQL Server cluster resource goes to a "failed" state when you try to bring the resource online in SQL Server Q883732 KB883732 April 17, 2018
• 873235 Recover from a full transaction log in a SQL Server database Q873235 KB873235 April 17, 2018
• 841549 How to enable ports on Windows XP SP2 for Analysis Services and SQL Server 7.0 OLAP Services Q841549 KB841549 April 17, 2018
• 839269 You may not be able to connect to an instance of SQL Server that is configured to use the Named Pipes server network library on a computer that is running Windows XP Service Pack 2 Q839269 KB839269 April 17, 2018
• 555128 HowTo: Backup to UNC name using Database Maintenance Wizard Q555128 KB555128 April 17, 2018
• 323630 How to resolve blocking problems that are caused by lock escalation in SQL Server Q323630 KB323630 April 17, 2018
• 322336 How to verify and change the system administrator password in MSDE or SQL Server 2005 Express Edition Q322336 KB322336 April 17, 2018
• 321843 Error message 1785 occurs when you create a FOREIGN KEY constraint that may cause multiple cascade paths Q321843 KB321843 April 17, 2018
• 315512 Considerations for the "autogrow" and "autoshrink" settings in SQL Server Q315512 KB315512 April 17, 2018
• 314530 Error message when you execute a linked server query in SQL Server: "Timeout Expired" Q314530 KB314530 April 17, 2018
• 314520 How to pass a variable to a linked server query Q314520 KB314520 April 17, 2018
• 313100 HOW TO: Get Started with Microsoft JDBC Q313100 KB313100 April 17, 2018
• 290787 Error message when you perform a database backup to disk or tape or a database restore from disk or tape: "3266," "3013" Q290787 KB290787 April 17, 2018
• 282254 SQL Server service does not start successfully because of a logon failure Q282254 KB282254 April 17, 2018
• 246133 How to transfer logins and passwords between instances of SQL Server that are running older versions of SQL Server Q246133 KB246133 April 17, 2018
• 218592 How to perform a SQL Server distributed query with OLAP Server Q218592 KB218592 April 17, 2018
• 207187 You cannot back up databases to a network drive if your account have not sufficient permissions to access the network drive Q207187 KB207187 April 17, 2018
• 203638 How to return information about SQL Server linked servers Q203638 KB203638 April 17, 2018
• 274750 How to configure SQL Server to use more than 2 GB of physical memory Q274750 KB274750 April 16, 2018
• 928317 You must perform a full database backup before you back up the transaction log for a database in SQL Server 2005 and in SQL Server 2000 Q928317 KB928317 April 13, 2018
• 906892 You may experience slow performance when you run 32-bit SQL Server tools on 64-bit operating systems Q906892 KB906892 April 13, 2018
• 903002 A "Failed to reserve contiguous memory" error message may be logged in the SQL Server error log when users connect to an instance of SQL Server by using a network packet size that is larger than 8,060 bytes Q903002 KB903002 April 13, 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
• 818334 Replication setup is not successful when SQL Server is deployed by using a disk image Q818334 KB818334 April 13, 2018
• 815431 Installation of a named instance of SQL Server 2000 virtual server on a Windows Server 2003-based cluster fails Q815431 KB815431 April 13, 2018
• 814576 How to consolidate physical files and rename the logical file name in SQL Server 2000 and in SQL Server 2005 Q814576 KB814576 April 13, 2018
• 810056 How to manually re-create the resource-specific registry keys for SQL Server cluster resources Q810056 KB810056 April 13, 2018
• 555686 When running "SQL Server Management Studio" the application may load slowly. Q555686 KB555686 April 13, 2018
• 555017 HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows Server 2003 Q555017 KB555017 April 13, 2018
• 329332 You receive error 7391 when you run a distributed transaction against a linked server in SQL Server 2000 on a computer that is running Windows Server 2003 Q329332 KB329332 April 13, 2018
• 322884 Using extended stored procedures or SP_OA stored procedures to load CLR in SQL Server is not supported Q322884 KB322884 April 13, 2018
• 320141 HOW TO: Retrieve an Identity Value from a Newly Inserted Record from SQL Server by Using Visual Basic .NET Q320141 KB320141 April 13, 2018
• 317428 Where to find information about SQL Server licensing Q317428 KB317428 April 13, 2018
• 316989 Error message when you create a trusted data connection from ASP.NET to SQL Server: "Login failed for user: 'AccountName'" Q316989 KB316989 April 13, 2018
• 313702 The SQL Server service may fail to start with I/O error message 38 in the tempdb database Q313702 KB313702 April 13, 2018
• 307197 SQL Server cannot bind to the TCP/IP port on which SQL Server is listening when the TCP\IP port is used by another application Q307197 KB307197 April 13, 2018
• 281122 Description of restoring file and filegroup backups in SQL Server Q281122 KB281122 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
• 272067 How To Get a Record Count from a SQL Server CE Recordset Q272067 KB272067 April 13, 2018
• 239885 How to change service accounts for a clustered computer that is running SQL Server Q239885 KB239885 April 13, 2018
• 236605 PRB: DTS Wizard may not detect Excel column type for mixed data in SQL Server Q236605 KB236605 April 13, 2018
• 234748 You cannot correctly translate character data from a client to a server by using the SQL Server ODBC driver if the client code page differs from the server code page Q234748 KB234748 April 13, 2018
• 207595 How to do SQL Server 2000 distributed queries with FoxPro .dbf files Q207595 KB207595 April 13, 2018