SQL Server 2005 articles, fixes and updates - Year 2020

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 Year 2020. The list is daily updated.

• 2796944 Crash occurs when you call Automation procedures from CLR Objects in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012 Q2796944 KB2796944 December 17, 2020
• 2647989 Error message when you try to create an instance of an OLE DB provider in SQL Server: "Cannot create an instance of OLE DB provider" Q2647989 KB2647989 December 17, 2020
• 2009160 High CPU use occurs when you run queries in SQL Server Q2009160 KB2009160 December 17, 2020
• 950599 An SPN for the SQL Server Browser service is required when you establish a connection to a named instance of SQL Server Analysis Services Q950599 KB950599 December 17, 2020
• 307864 Error message when you connect to an instance of SQL Server: "Cannot open user default database" Q307864 KB307864 December 17, 2020
• 969052 How to restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update Q969052 KB969052 December 1, 2020
• 931279 SQL Server timing values may be incorrect when you use utilities or technologies that change CPU frequencies Q931279 KB931279 December 1, 2020
• 914288 How to generate a script of the necessary database metadata to create a statistics-only database in SQL Server Q914288 KB914288 November 8, 2020
• 264474 You cannot restore system database backups to a different build of SQL Server Q264474 KB264474 November 8, 2020
• 139444 How to remove duplicate rows from a table in SQL Server Q139444 KB139444 November 8, 2020
• 2539091 You should not disable the guest user in the msdb database in SQL Server Q2539091 KB2539091 October 20, 2020
• 917825 How to use the Sqldumper.exe utility to generate a dump file in SQL Server Q917825 KB917825 October 20, 2020
• 321185 How to determine the version, edition, and update level of SQL Server and its components Q321185 KB321185 October 1, 2020
• 3049257 Error 3989 or 3988 when a distributed query that joins multiple tables is hosted by remote instances of SQL Server Q3049257 KB3049257 September 29, 2020
• 975681 FIX: The database mirroring session is suspended when you add more than one log transaction file to a folder on the principle server that does not exist on the mirror server in SQL Server 2005 or in SQL Server 2008 Q975681 KB975681 September 29, 2020
• 975090 FIX: Deadlocks may occur when multiple concurrent query notification subscriptions are fired on same objects in SQL Server 2005 or in SQL Server 2008 Q975090 KB975090 September 29, 2020
• 972498 FIX: You receive error messages or data is damaged after you run an SSIS package that contains a data flow task in a low memory situation in SQL Server 2005 or in SQL Server 2008 Q972498 KB972498 September 29, 2020
• 971402 FIX: Error message when you send an e-mail by using a private Database Mail profile in SQL Server 2005 or in SQL Server 2008: "profile name is not valid" Q971402 KB971402 September 29, 2020
• 969611 FIX: Error message when you run a job whose owner is a Windows user account after SQL Server 2005 Agent or SQL Server 2008 Agent is restarted: "The job failed. The owner () of job <Job Name> does not have server access" Q969611 KB969611 September 29, 2020
• 961282 FIX: Error message when you try to display a report in SQL Server 2008 Management Studio: "System.IndexOutOfRangeException: Index was outside the bounds of the array" Q961282 KB961282 September 29, 2020
• 555332 "Login failed for user" error message when you log on to SQL Server Q555332 KB555332 September 29, 2020
• 294209 How to rebuild or move a MSDTC installation to be used with a SQL failover cluster Q294209 KB294209 September 29, 2020
• 240872 How to resolve permission issues when you move a database between servers that are running SQL Server Q240872 KB240872 September 29, 2020
• 906547 How to create a dynamic subject or message for the Send Mail task in SQL Server 2005 Integration Services Q906547 KB906547 September 3, 2020
• 2874903 "System.OutOfMemoryException" exception when you execute a query in SQL Server Management Studio Q2874903 KB2874903 August 20, 2020
• 909801 How to make sure that you are using Kerberos authentication when you create a remote connection to an instance of SQL Server 2005 Q909801 KB909801 August 20, 2020
• 2295405 SQL Server service crashes when you run an Oracle linked server query Q2295405 KB2295405 August 18, 2020
• 327270 SQL Server is not supported on Windows Server 2003 or Windows Server 2008 Terminal Server application server Q327270 KB327270 May 31, 2020
• 243589 How to troubleshoot slow-running queries on SQL Server 7.0 or on later versions Q243589 KB243589 May 31, 2020
• 2722715 Support for the leap second Q2722715 KB2722715 May 28, 2020
• 2003681 Possible causes of "Failed to initialize the Common Language Runtime (CLR)" when using SQL CLR Q2003681 KB2003681 April 30, 2020
• 2001270 Things to consider when setting up database mirroring in SQL Server. Q2001270 KB2001270 April 30, 2020
• 949296 Some SQL Server replication agents cannot run when you configure many replication agents to run on a server Q949296 KB949296 April 30, 2020
• 945934 How to register Microsoft Filter Pack IFilters with SQL Server Q945934 KB945934 April 30, 2020
• 920700 An introduction to SQL Server 2005 Compact Edition Q920700 KB920700 April 30, 2020
• 198891 How to run a DLL-based COM object outside the SQL Server process Q198891 KB198891 April 30, 2020
• 2618570 "0x80770006" and "3201" errors after you install an instance of SQL Server 2008 R2 and later versions Q2618570 KB2618570 April 14, 2020
• 2416767 You may get an error message when trying to load or save a SSIS package Q2416767 KB2416767 April 10, 2020
• 944837 Description of the Replay Markup Language (RML) Utilities for SQL Server Q944837 KB944837 April 10, 2020
• 909967 How to manually uninstall an instance of SQL Server 2005 Q909967 KB909967 April 10, 2020
• 2681562 Using SQL Server in Windows 8 and later versions of Windows operating system Q2681562 KB2681562 April 9, 2020
• 2027770 Understanding the .NET Framework requirements for various versions of SQL Server Q2027770 KB2027770 April 9, 2020
• 919023 SQL Server 2005 connectivity and Volume Shadow Copy Service (VSS) Q919023 KB919023 April 9, 2020
• 917047 Microsoft SQL Server I/O subsystem requirements for the tempdb database Q917047 KB917047 April 9, 2020
• 307288 The SQL Server service and the SQL Server Agent Service fail to start on a stand-alone server Q307288 KB307288 April 3, 2020
• 956893 Support policy for Microsoft SQL Server products that are running in a hardware virtualization environment Q956893 KB956893 March 31, 2020
• 2507769 Cumulative update package 3 for SQL Server 2005 Service Pack 4 Q2507769 KB2507769 February 20, 2020
• 2485757 The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 4 was released Q2485757 KB2485757 February 20, 2020
• 942657 FIX: You have to enter the old password of a SQL Server login when you try to change the password of the login by using SQL Server Management Studio in SQL Server 2005 Q942657 KB942657 February 20, 2020
• 939285 FIX: Error message when you run a stored procedure that starts a transaction that contains a Transact-SQL statement in SQL Server 2005: "New request is not allowed to start because it should come with valid transaction descriptor" Q939285 KB939285 February 20, 2020
• 937745 FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections Q937745 KB937745 February 20, 2020
• 937545 FIX: Error message when you use the BULK INSERT statement to import a data file into a table in SQL Server 2005 with SP1: "The OLE DB provider "BULK" for linked server "(null)" reported an error" Q937545 KB937545 February 20, 2020
• 937544 FIX: You may receive error 3456 when you try to restore a transaction log for a SQL Server 2005 database Q937544 KB937544 February 20, 2020
• 937517 FIX: Error message when you commit a distributed transaction that contains a query that retrieves data from a linked server in SQL Server 2005: "Transaction manager has cancelled the distributed transaction" Q937517 KB937517 February 20, 2020
• 937343 FIX: SQL Server 2005 stops and then restarts unexpectedly, and errors occur in the tempdb database Q937343 KB937343 February 20, 2020
• 937277 FIX: A memory leak occurs when you use the sp_OAMethod stored procedure or the sp_OAGetProperty stored procedure to call a method of a COM object in SQL Server 2005 Q937277 KB937277 February 20, 2020
• 937041 FIX: Changes in the publisher database are not replicated to the subscribers in a transactional replication if the publisher database runs exposed in a database mirroring session in SQL Server 2005 Q937041 KB937041 February 20, 2020
• 935446 FIX: You receive error messages when you use the BULK INSERT statement in SQL Server 2005 to import data in bulk Q935446 KB935446 February 20, 2020
• 934226 FIX: Error message when you try to use Database Mail to send an e-mail message in SQL Server 2005: "profile name is not valid (Microsoft SQL Server, Error 14607)" Q934226 KB934226 February 20, 2020
• 933508 Microsoft SQL Server 2005 Service Pack 2 issue: Cleanup tasks run at different intervals than intended Q933508 KB933508 February 20, 2020
• 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available Q933097 KB933097 February 20, 2020
• 932556 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1500 and later builds Q932556 KB932556 February 20, 2020
• 931821 FIX: High CPU utilization by SQL Server 2005 may occur when you use NUMA architecture on a computer that has SQL Server 2005 installed Q931821 KB931821 February 20, 2020
• 930775 FIX: Error message when you try to retrieve rows from a cursor that uses the OPTION (RECOMPILE) query hint in SQL Server 2005: "Could not complete cursor operation because the table schema changed after the cursor was declared" Q930775 KB930775 February 20, 2020
• 929240 FIX: I/O requests that are generated by the checkpoint process may cause I/O bottlenecks if the I/O subsystem is not fast enough to sustain the IO requests in SQL Server 2005 Q929240 KB929240 February 20, 2020
• 926773 FIX: Error message when you run a query that uses a fast forward-only cursor in SQL Server 2005: "Query processor could not produce a query plan because of the hints defined in this query" Q926773 KB926773 February 20, 2020
• 925001 FIX: Error message when you run queries between two SQL Server 2005 linked servers: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'" Q925001 KB925001 February 20, 2020
• 922804 FIX: After you detach a Microsoft SQL Server 2005 database that resides on network-attached storage, you cannot reattach the SQL Server database Q922804 KB922804 February 20, 2020
• 916086 FIX: Errors may be generated in the tempdb database when you create and then drop many temporary tables in SQL Server 2005 Q916086 KB916086 February 20, 2020
• 2492477 SQL Agent job that executes a distributed query may fail with 65535, 782 or 7437 error messages Q2492477 KB2492477 February 4, 2020