SQL Server 2005 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 2005 that have been released in April 2018. The list is daily updated.

• 953752 Cumulative update package 9 for SQL Server 2005 Service Pack 2 Q953752 KB953752 April 23, 2018
• 932376 How to configure SharePoint Server 2007 to use a database that is hosted on a server that is running SQL Server in an untrusted domain Q932376 KB932376 April 23, 2018
• 926150 Using database mirroring for cross-database transactions or distributed transactions is not supported in SQL Server Q926150 KB926150 April 23, 2018
• 956854 Cumulative update package 10 for SQL Server 2005 Service Pack 2 Q956854 KB956854 April 22, 2018
• 974205 FIX: Error message in the Errorlog file of SQL Server 2005 or of SQL Server 2008 after the SQL Server service stops responding: "Timeout occurred while waiting for latch" Q974205 KB974205 April 21, 2018
• 969775 FIX: Distribution Agent fails when you try to apply a snapshot for a newly added view in a publication in SQL Server 2005 or in SQL Server 2008 Q969775 KB969775 April 21, 2018
• 955500 Error message when you try to install an instance of SQL Server 2005 on a computer that has an instance of SQL Server 2008 already installed: "An instance with the same name is already installed on this computer" Q955500 KB955500 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
• 978430 FIX: The Ghost Cleanup task uses 100% of the CPU on an idle system in SQL Server 2008 or in SQL Server 2005 Q978430 KB978430 April 20, 2018
• 960791 Error message when you run the DBCC CHECKDB command on a computer that contains a SQL Server database: "Error 8967" Q960791 KB960791 April 20, 2018
• 958999 Best practices for changing the service account for the report server in SQL Server 2005 Reporting Services Q958999 KB958999 April 20, 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
• 942176 Description of the SQL Server Integration Services (SSIS) service and of alternatives to clustering the SSIS service Q942176 KB942176 April 20, 2018
• 941823 Some or all SQL Server 2005 services are not listed in SQL Server Configuration Manager, or you receive a "No SQL Server 2005 components were found" error message when you perform operations in SQL Server 2005 Surface Area Configuration Q941823 KB941823 April 20, 2018
• 937137 The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released Q937137 KB937137 April 20, 2018
• 934751 Error message when you log on to an instance of Microsoft SQL Server 2005 from SQL Server Management Studio: "Timeout expired. This timeout period elapsed prior to completion of the operation or the server is not responding" Q934751 KB934751 April 20, 2018
• 934653 How to use the 64-bit SQL Server Agent to schedule a SQL Server 2005 Integration Services package Q934653 KB934653 April 20, 2018
• 929667 Error message when you install SQL Server 2005 Express Edition Service Pack 2 Community Technology Preview: "An installation package for the product Microsoft SQL Server Native Client cannot be found" Q929667 KB929667 April 20, 2018
• 928779 The SQL Server service cannot start after you configure an instance of SQL Server 2005 to use a Secure Sockets Layer (SSL) certificate using the Microsoft Enhanced Cryptographic Provider 1.0 Q928779 KB928779 April 20, 2018
• 926070 Error messages may be logged in the SQL Server error log after you run a DBCC command in SQL Server Q926070 KB926070 April 20, 2018
• 925719 BUG: You may receive an error message when you try to use SQL Server Management Studio to update a row of a table in SQL Server 2005 Q925719 KB925719 April 20, 2018
• 924947 SQL Server significantly increases the unused space for some tables Q924947 KB924947 April 20, 2018
• 923355 Error message when you perform a full backup of a database in SQL Server 2005: "Backup failed for Server 'ComputerName\SQLInstanceName' " or "The backup of the file or filegroup 'sysft_FullTextCatalog' is not permitted because it is not online" Q923355 KB923355 April 20, 2018
• 920769 How to use custom assemblies or embedded code in Reporting Services Q920769 KB920769 April 20, 2018
• 919710 Error message when you try to connect to an instance of SQL Server 2005: "No process is on the other end of the pipe" or "An existing connection was forcibly closed by the remote host" Q919710 KB919710 April 20, 2018
• 916760 Error message when you install SQL Server 2005: "There was an unexpected failure during the setup wizard" Q916760 KB916760 April 20, 2018
• 913967 How to add the SQL Server 2005 tools or SQL Server 2005 Integration Services to an existing instance of SQL Server 2005 Q913967 KB913967 April 20, 2018
• 913817 You receive an error message when you use Business Intelligence Development Studio to build a SQL Server 2005 Integration Services package Q913817 KB913817 April 20, 2018
• 913050 Error message when you run a query in SQL Server 2005: "Internal error: An expression services limit has been reached" Q913050 KB913050 April 20, 2018
• 912911 How to run a SQL Server 2005 Integration Services package as a SQL Server Agent job step Q912911 KB912911 April 20, 2018
• 911003 You may receive an error message when you try to export a table by using the SQL Server Import and Export Wizard Q911003 KB911003 April 20, 2018
• 910016 Release manifest for Microsoft SQL Server Native Client (9.00.1399.06) Q910016 KB910016 April 20, 2018
• 909036 Error message when you create a new maintenance plan in SQL Server 2005: "Create maintenance plan failed" Q909036 KB909036 April 20, 2018
• 908460 How to add an incremental counter in a SQL Server 2005 Integration Services package by using a Script component in a Data Flow task Q908460 KB908460 April 20, 2018
• 908018 How to create a package template in SQL Server Business Intelligence Development Studio Q908018 KB908018 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
• 905618 You may receive a connection error message when you try to connect to an instance of SQL Server 2000 or of SQL Server 7.0 that was installed after you installed SQL Server 2005 Q905618 KB905618 April 20, 2018
• 904803 Character data is represented incorrectly when the code page of the client computer differs from the code page of the database in SQL Server 2005 Q904803 KB904803 April 20, 2018
• 904800 You receive an "Error loading" error message when you try to run an SQL Server 2005 Integration Services package in SQL Server 2005 Q904800 KB904800 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
• 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
• 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
• 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
• 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
• 300488 How to run SQL Server stored procedures from an ASP Page Q300488 KB300488 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
• 2002980 Problems with SQL Server Express user instancing and ASP.net Web Application Projects Q2002980 KB2002980 April 19, 2018
• 972387 SQL Server Failover Cluster Instance is taken offline when you change the password for the service account on the passive node Q972387 KB972387 April 19, 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
• 938245 How to install and how to configure SQL Server 2005 Reporting Services on a computer that is running Windows Server 2008 Q938245 KB938245 April 19, 2018
• 919157 How to display a report that contains a subreport by using the ReportViewer control in Visual Studio 2005 Q919157 KB919157 April 19, 2018
• 918357 BUG: Error message when you try to install SQL Server 2005 Service Pack 1: "Unable to install Windows Installer MSP file" Q918357 KB918357 April 19, 2018
• 822499 Naming schema and Fix area descriptions for SQL Server software update packages Q822499 KB822499 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
• 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
• 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
• 969962 Various memory errors are logged to SQL Server error log when using SQL CLR objects Q969962 KB969962 April 18, 2018
• 967576 Microsoft SQL Server Database Engine Input/Output requirements Q967576 KB967576 April 18, 2018
• 926824 How to install service packs and hotfixes on an instance of SQL Server that is configured to use database mirroring Q926824 KB926824 April 18, 2018
• 918685 Error message when you install SQL Server 2005 or SQL Server 2008: "The file C:\Windows\Microsoft.NET\Framework\[version_number]\mscorlib.tlb could not be loaded" Q918685 KB918685 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
• 2007728 Error message when you use SSL for connections to SQL Server: "The certificate received from the remote server was issued by an untrusted certificate authority" Q2007728 KB2007728 April 17, 2018
• 960090 MS09-004: Description of the security update for SQL Server 2005 QFE: February 10, 2009 Q960090 KB960090 April 17, 2018
• 955725 Known issues installing SQL Server on Windows 7 or Windows Server 2008 R2 Q955725 KB955725 April 17, 2018
• 950891 You cannot restore a database from a backup file when you use a SQL Server login ID that has the dbcreator server role to connect to an instance of SQL Server 2005 Q950891 KB950891 April 17, 2018
• 948109 MS08-040: Description of the security update for SQL Server 2005 GDR: July 8, 2008 Q948109 KB948109 April 17, 2018
• 937682 How to add a Windows user to the sysadmin fixed server role in SQL Server 2005 as a failure recovery mechanism Q937682 KB937682 April 17, 2018
• 920114 Error message when you try to install SQL Server Express or SQL Server Express Edition or SQL Server Express Edition with Advanced Services: "The SQL Server service failed to start" Q920114 KB920114 April 17, 2018
• 919160 How to enable the snapshot transaction isolation level in SQL Server 2005 Analysis Services Q919160 KB919160 April 17, 2018
• 918040 You may receive an error message when you try to run an existing CLR object or create an assembly that has the external_access or unsafe permission set on a database that is attached or restored from a different server Q918040 KB918040 April 17, 2018
• 918038 You receive an error message when you try to load an SSIS package that contains a DateTime type variable in SQL Server 2005 Q918038 KB918038 April 17, 2018
• 911305 SQL Server Agent jobs may fail after you change the SQL Server Agent service startup account by using the Windows Service Control Manager Q911305 KB911305 April 17, 2018
• 909953 How to uninstall SQL Server Management Studio Q909953 KB909953 April 17, 2018
• 908711 You receive an “Explicit value must be specified for identity column” error message when you use the replication feature to run an INSERT statement on a table in SQL Server 2005 Q908711 KB908711 April 17, 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
• 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
• 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
• 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
• 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
• 274750 How to configure SQL Server to use more than 2 GB of physical memory Q274750 KB274750 April 16, 2018
• 959823 How to customize the quota for the TokenAndPermUserStore cache store in SQL Server 2005 Service Pack 3 Q959823 KB959823 April 13, 2018
• 943525 You cannot start the SQL Server Agent service of a failover cluster of SQL Server 2005 if the build of SQL Server is 3179 or a later build Q943525 KB943525 April 13, 2018
• 935563 You receive syntax error messages when you use transactional replication in SQL Server 2005 Q935563 KB935563 April 13, 2018
• 933837 How to make an MDX query return a value in the numeric format in SQL Server 2005 Analysis Services Q933837 KB933837 April 13, 2018
• 932881 How to make unwanted access to SQL Server 2005 by an operating system administrator more difficult Q932881 KB932881 April 13, 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
• 923827 Unhandled exceptions are caught by the Visual Studio JIT debugger instead of Dr. Watson or a third-party debugger after you install certain versions of SQL Server 2005 Q923827 KB923827 April 13, 2018
• 922670 How to use the Add or Remove Programs item in Control Panel to add or remove components for stand-alone installations and clustered installations of SQL Server 2005 Q922670 KB922670 April 13, 2018
• 922651 BUG: Error message when you try to save a maintenance plan in SQL Server Management Studio: "Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" Q922651 KB922651 April 13, 2018
• 921901 BUG: You receive error code -2147024893 when you uninstall SQL Server 2005 Reporting Services on a computer that is running Windows Vista Beta 2 or Windows Server 2008 Q921901 KB921901 April 13, 2018
• 919945 Error message when you uninstall SQL Server 2005 or install SQL Server 2005 Service Pack 1: "The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation" Q919945 KB919945 April 13, 2018
• 919711 How to configure SQL Server 2005 Analysis Services to generate memory dump files Q919711 KB919711 April 13, 2018
• 917407 How to upgrade or downgrade an assembly that has a referenced assembly for a CLR object in an instance of SQL Server 2005 Q917407 KB917407 April 13, 2018
• 917040 How to use the timestamp column of a table for optimistic concurrency control in SQL Server 2005 Q917040 KB917040 April 13, 2018
• 914171 Error message when you restore or attach an msdb database or when you change the syssubsystems table in SQL Server 2005: "Subsystem % could not be loaded" Q914171 KB914171 April 13, 2018
• 914158 You receive an error message when you try to upgrade an expired installation of SQL Server 2005 Evaluation Edition to a retail version of SQL Server 2005 Q914158 KB914158 April 13, 2018
• 913668 Error message when you use a common language runtime object in SQL Server 2005: "Cannot load dynamically generated serialization assembly" Q913668 KB913668 April 13, 2018
• 910067 Error message when you try to open a full-text catalog after you restore a database in SQL Server 2005: "Property IsAccentSensitive is not available for FullTextCatalog '[CatalogName]'" Q910067 KB910067 April 13, 2018
• 909003 Error message when you run a DBCC check command in SQL Server 2005: "8909 16 1 Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type unknown)" Q909003 KB909003 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
• 900495 BUG: You cannot enable encryption by using a certificate when SQL Server 2005 is running under the Network Service account Q900495 KB900495 April 13, 2018
• 899634 Description of the Database Tuning Advisor (DTA) cleanup script for SQL Server 2005 Q899634 KB899634 April 13, 2018
• 818334 Replication setup is not successful when SQL Server is deployed by using a disk image Q818334 KB818334 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
• 322884 Using extended stored procedures or SP_OA stored procedures to load CLR in SQL Server is not supported Q322884 KB322884 April 13, 2018
• 317428 Where to find information about SQL Server licensing Q317428 KB317428 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
• 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