SQL Server 2005 articles, fixes and updates - Year 2021

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

• 974006 SQL Server query optimizer hotfix trace flag 4199 servicing model Q974006 KB974006 August 18, 2021
• 919349 Error message when you start SQL Server Management Studio on a computer that is running Microsoft Dynamics GP 9.0 "The file C:\WINDOWS\Microsoft.NET\Framework\\mscorlib.tlb could not be loaded." Q919349 KB919349 May 17, 2021
• 2860310 FIX: Incorrect results when you run a query that uses a LIKE operator in a WHERE clause in SQL Server Compact 3.5 Q2860310 KB2860310 January 26, 2021
• 2718718 FIX: "Cannot open the shared memory" error message when you try to create or open a SQL Server Compact 3.5 SP2 database file on a shared network folder Q2718718 KB2718718 January 26, 2021
• 2665342 Cumulative update package 7 for SQL Server Compact 3.5 Service Pack 2 Q2665342 KB2665342 January 26, 2021
• 2628887 Cumulative update package 6 for SQL Server Compact 3.5 Service Pack 2 Q2628887 KB2628887 January 26, 2021
• 2616117 FIX: Incorrect mail profile is displayed in the Alert System page in SQL Server 2008 R2 Q2616117 KB2616117 January 26, 2021
• 2598903 FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q2598903 KB2598903 January 26, 2021
• 2591902 FIX: XML data loss when a merge replication encounters a foreign key violation error in SQL Server 2005, in SQL Server 2008, in SQL Server 2008 R2, or in SQL Server 2012 Q2591902 KB2591902 January 26, 2021
• 2590839 FIX: Low CPU spikes at a set interval even without user activity in SQL Server 2008 R2 or in SQL Server 2012 Q2590839 KB2590839 January 26, 2021
• 2585082 FIX: "A specified value violated the integrity constraints for a column or table" error if the merge publication contains many articles and constraints in SQL Server Compact 3.5 Q2585082 KB2585082 January 26, 2021
• 2583994 FIX: SSIS Checkpoint restores an incorrect variable value for an Execute SQL Task item of a For Loop Container item in SSIS 2008 or in SSIS 2008 R2 if an SSIS package executes again after it fails or stops Q2583994 KB2583994 January 26, 2021
• 2539378 FIX: Replmerg.exe crashes when it enumerates changes to a statement in SQL Server if the stored procedure contains more than 4,000 characters Q2539378 KB2539378 January 26, 2021
• 2527494 An update for SQL Server Compact 3.5 SP2 is available to add support for replication operations that use SQL Server "Denali" Q2527494 KB2527494 January 26, 2021
• 2526552 FIX: SQL Server Browser service periodically does not respond to incoming requests Q2526552 KB2526552 January 26, 2021
• 2515286 FIX: "There is no function '{urn:schemas-microsoft-com:xml-sql}:variable()" error for an XQuery query that updates the value of an XML column in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q2515286 KB2515286 January 26, 2021
• 2511151 FIX: Column of a Flat File source is not imported if the next column data is one byte longer than the output column width in SSIS 2005, SSIS 2008 or in SSIS 2008 R2 Q2511151 KB2511151 January 26, 2021
• 2498818 FIX: Error 7359 when you run a query against a user-defined function or a view that uses a synonym on a linked server in SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2 Q2498818 KB2498818 January 26, 2021
• 2490920 FIX: "Msg 2601, Level 14, State 1, Line 1 Cannot insert duplicate key row" error when you run the ALTER PARTITION FUNCTION statement to split or merge a partition range in SQL Server 2005 or in SQL Server 2008 Q2490920 KB2490920 January 26, 2021
• 2489667 FIX: SQL Server Agent job runs incorrectly if it is scheduled to run every hour on the last day of every week or month in SQL Server 2005 or in SQL Server 2008 or in SQL Server 2008 R2 Q2489667 KB2489667 January 26, 2021
• 2482977 FIX: 10061 Winsock error code occurs when an application uses the extended OLE DB initialization properties for the SQL Server Native Client 10.0 OLE DB provider in the connection string Q2482977 KB2482977 January 26, 2021
• 2481274 FIX: A query that uses the DATEDIFF function may run slowly in SQL Server 2005 or in SQL Server 2008 or in SQL Server 2008 R2 Q2481274 KB2481274 January 26, 2021
• 2463332 List of the issues that are fixed in SQL Server 2005 Service Pack 4 Q2463332 KB2463332 January 26, 2021
• 2451540 FIX: Poor performance may occur when you execute a query that contains multiple self-join operations on the same column in SQL Server 2005, in SQL Server 2008 and in SQL Server 2008 R2 Q2451540 KB2451540 January 26, 2021
• 2448991 FIX: The variables of an SSIS 2008, SSIS 2008 R2 or SSIS 2005 package are evaluated incorrectly when you run the package in parallel Q2448991 KB2448991 January 26, 2021
• 2413430 FIX: "Cannot locate version record and page is not allocated" error message occurs when you rebuild an index by using the ONLINE option in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q2413430 KB2413430 January 26, 2021
• 2407172 FIX: An exception occurs before the error output for invalid data of an "XML Source" task is redirected in SSIS 2005, SSIS 2008 or SSIS 2008R2 Q2407172 KB2407172 January 26, 2021
• 2403218 FIX: Database mirroring session is suspended in SQL Server 2005 and in SQL Server 2008 and in SQL Server 2008 R2 if the High-performance (asynchronous) mode is used Q2403218 KB2403218 January 26, 2021
• 2295878 FIX: LOB pages that are allocated in a failed INSERT statement may not be reclaimed after you apply SQL Server 2005 SP3, SQL Server 2005 SP4, SQL Server 2008 SP1 or SQL Server 2008 R2 Q2295878 KB2295878 January 26, 2021
• 2295869 FIX: An unresolved deadlock occurs when a database is recovered in SQL Server 2005, SQL Server 2008, or in SQL Server 2008 R2 Q2295869 KB2295869 January 26, 2021
• 2295460 Fix: Replication error message when you register a custom resolver to a merge replication in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 if a BIGINT column contains a NULL value Q2295460 KB2295460 January 26, 2021
• 2276717 FIX: Error code 1456 when you add a witness to a new database mirroring session that has the same database name as an existing database mirroring session in Microsoft SQL Server 2008 and in Microsoft SQL Server 2008 R2 Q2276717 KB2276717 January 26, 2021
• 2268122 FIX: "User 'guest' does not have permission to run DBCC checkdb for database 'mssqlsystemresource'" error message when you run the DBCC CHECKDB('master') command on a computer that is running SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q2268122 KB2268122 January 26, 2021
• 2261403 FIX: The "SQL Server:SSIS Pipeline 10.0" performance object does not appear in the "Performance object" list while another user accesses some SSIS pipeline counters in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2005 Q2261403 KB2261403 January 26, 2021
• 2252955 Considerations when using the SQL Server Full-Text search engine for the Japanese language Q2252955 KB2252955 January 26, 2021
• 2159286 FIX: The Remote Registry service crashes when an application tries to retrieve performance counter data from an instance of SQL Server on another computer Q2159286 KB2159286 January 26, 2021
• 983516 FIX: A Deadlock occurs when two transactions try to perform a DML operation on a table that contains a TABLOCK locking hint or an XLOCK locking hint Q983516 KB983516 January 26, 2021
• 982376 FIX: A non-yielding scheduler error or an error 8623 occurs when you run a query that contains a large IN clause in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q982376 KB982376 January 26, 2021
• 980849 FIX: You experience high latency for peer-to-peer distribution agents in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2 Q980849 KB980849 January 26, 2021
• 980653 SQL Server 2008 R2 CU2, SQL Server 2008 SP1 CU7 and SQL Server 2005 SP3 CU9 introduce trace flag 4136 to disable the "parameter sniffing" process Q980653 KB980653 January 26, 2021
• 980142 FIX: "Provider Load Failure" error message or the Wmiprvse.exe process stops responding when you use a SQL Server WMI provider to obtain information about SQL Server 2012, SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 services Q980142 KB980142 January 26, 2021
• 979212 FIX: A DateTime value is replaced by a NULL value when a conflict is resolved by using a custom resolver in Microsoft SQL Server 2005, Microsoft SQL Server 2008 or Microsoft SQL Server 2008 R2 merge replication Q979212 KB979212 January 26, 2021
• 974660 FIX: You receive out-of-memory error messages when you use merge replication with Web synchronization in SQL Server 2005 or in SQL Server 2008 Q974660 KB974660 January 26, 2021
• 973524 FIX: The execution of the xp_readerrorlog command in SQL Server 2005 and in SQL Server 2008 stops responding and the usage of the CPU that is running the command increases to 100 percent Q973524 KB973524 January 26, 2021
• 970279 Cumulative update package 4 for SQL Server 2005 Service Pack 3 Q970279 KB970279 January 26, 2021
• 970070 Support for Locked Pages on SQL Server Standard Edition (64-bit) systems Q970070 KB970070 January 26, 2021
• 969845 FIX: Error message when you run a SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Integration Services package (SSIS) after you install the .NET Framework 2.0 SP2 or the .NET Framework 3.5 SP1: "ADO NET Source [1424]" Q969845 KB969845 January 26, 2021
• 968834 FIX: Error message when you send an e-mail by using Database Mail in SQL Server 2005 or in SQL Server 2008: "The operation has timed out" Q968834 KB968834 January 26, 2021
• 968381 All records in the query log table are truncated when you synchronize a database in SQL Server Analysis Services Q968381 KB968381 January 26, 2021
• 967908 Cumulative update package 13 for SQL Server 2005 Service Pack 2 Q967908 KB967908 January 26, 2021
• 961930 Cumulative update package 2 for SQL Server 2005 Service Pack 3 Q961930 KB961930 January 26, 2021
• 959015 FIX: A conflict with the foreign key constraint occurs when you update the case of the column values in the primary key table or you pad column values in the primary key table in SQL Server 2005 Q959015 KB959015 January 26, 2021
• 958478 FIX: Error message when you run a "LINQ to Entities" query that uses a string parameter or a binary parameter against a SQL Server Compact 3.5 database: "The ntext and image data types cannot be used in WHERE, HAVING, GROUP BY, ON, or IN... Q958478 KB958478 January 26, 2021
• 958006 FIX: The size of the error log file for the SQL Server 2008 error log file grows very quickly when query notifications are created and destroyed in a high ratio Q958006 KB958006 January 26, 2021
• 955706 List of the bugs that are fixed in SQL Server 2005 Service Pack 3 Q955706 KB955706 January 26, 2021
• 954950 FIX: Error message when you run a distributed query in SQL Server 2005 or SQL Server 2008: "OLE DB provider 'SQLNCLI' for linked server '<Linked Server>' returned message 'No transaction is active'" Q954950 KB954950 January 26, 2021
• 942712 FIX: The W3WP.exe process of Internet Information Services stops unexpectedly when you configure a merge replication that uses Web synchronization in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 Q942712 KB942712 January 26, 2021
• 934458 FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances in SQL Server 2005 builds 3042 through 3053 Q934458 KB934458 January 26, 2021
• 930283 FIX: You receive error 1456 when you add a witness to a database mirroring session and the database name is the same as an existing database mirroring session in SQL Server 2005 or SQL Server 2008 Q930283 KB930283 January 26, 2021
• 926421 FIX: You receive error messages when you use SQL Server Management Studio or SQL Server Business Intelligence Development Studio after you install Microsoft Office Excel 2007 on a computer that has SQL Server 2005 Analysis Services installed Q926421 KB926421 January 26, 2021
• 926292 FIX: When you query through a view that uses the ORDER BY clause in SQL Server 2008, the result is still returned in random order Q926292 KB926292 January 26, 2021
• 924291 FIX: Error message when you execute a user-defined function in SQL Server 2005: "Invalid length parameter passed to the SUBSTRING function" or "A transport-level error has occurred when receiving results from the server" Q924291 KB924291 January 26, 2021
• 922578 FIX: Lots of messages that have message ID 19030 and message ID 19031 are logged in SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2 Errorlog file when you use SQL Server Profile in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q922578 KB922578 January 26, 2021
• 897284 Diagnostics in SQL Server help detect stalled and stuck I/O operations Q897284 KB897284 January 26, 2021
• 826433 SQL Server diagnostics added to detect unreported I/O problems due to stale reads or lost writes Q826433 KB826433 January 26, 2021
• 328476 Description of TCP/IP settings that you may have to adjust when SQL Server connection pooling is disabled Q328476 KB328476 January 26, 2021
• 322385 SQL Server support in a hyper-threaded environment Q322385 KB322385 January 26, 2021
• 3027860 Error 17066 or 17310 during SQL Server startup Q3027860 KB3027860 January 25, 2021
• 2985455 Kerberos Configuration Manager for SQL Server is available Q2985455 KB2985455 January 25, 2021
• 2974455 DBCC CHECKDB behavior when the SQL Server database is located on an ReFS volume Q2974455 KB2974455 January 25, 2021
• 2926557 SQL Server VDI backup and restore operations require Sysadmin privileges Q2926557 KB2926557 January 25, 2021
• 2882905 A 9017 informational message is logged when you start an instance of SQL Server or restore or attach a database Q2882905 KB2882905 January 25, 2021
• 2869522 The .NET Framework 4.x assemblies are not supported in SQL Server Reporting Services Q2869522 KB2869522 January 25, 2021
• 2860895 SQL Server is not supported on a Windows operating system on which case sensitivity is enabled Q2860895 KB2860895 January 25, 2021
• 2795690 SQL Server agent crashes when you try to start it or takes longer than expected to start Q2795690 KB2795690 January 25, 2021
• 2729953 You may encounter a 'result == LCK_OK' assertion on a SQL Server mirror server Q2729953 KB2729953 January 25, 2021
• 2656988 How to enable the CHECKSUM option if backup utilities do not expose the option Q2656988 KB2656988 January 25, 2021
• 2543893 MS11-049: Vulnerability in the Microsoft XML Editor could allow information disclosure: June 14, 2011 Q2543893 KB2543893 January 25, 2021
• 2523744 The transaction log may grow without a log backup for a database using the FULL recovery model Q2523744 KB2523744 January 25, 2021
• 2494123 MS11-049: Description of the security update for SQL Server 2005 Service Pack 4 QFE: June 14, 2011 Q2494123 KB2494123 January 25, 2021
• 2494120 MS11-049: Description of the security update for SQL Server 2005 Service Pack 4 GDR: June 14, 2011 Q2494120 KB2494120 January 25, 2021
• 2494113 MS11-049: Description of the security update for SQL Server 2005 Service Pack 3 GDR: June 14, 2011 Q2494113 KB2494113 January 25, 2021
• 2481773 You get "Error code 64" when accessing Replisapi.dll through ISA server Q2481773 KB2481773 January 25, 2021
• 972767 FIX: The SQL Server database engine and SQL Server Reporting Services may consume more power on Windows client computers than expected Q972767 KB972767 January 25, 2021
• 961040 Microsoft Security Advisory: Vulnerability in SQL Server could allow remote code execution Q961040 KB961040 January 25, 2021
• 960089 MS09-004: Description of the security update for SQL Server 2005 GDR: February 10, 2009 Q960089 KB960089 January 25, 2021
• 959420 MS09-004: Vulnerabilities in Microsoft SQL Server could allow remote code execution Q959420 KB959420 January 25, 2021
• 957488 MS09-062: Vulnerabilities in GDI+ could allow remote code execution Q957488 KB957488 January 25, 2021
• 957008 SQL Server 2005 Service Pack 2 is not successfully updated when you try to install or to uninstall a security update Q957008 KB957008 January 25, 2021
• 954606 MS08-052: Description of the security update for GDI&#x2B; for SQL Server 2005 Service Pack 2 GDR: September 9, 2008 Q954606 KB954606 January 25, 2021
• 954593 MS08-052: Vulnerabilities in GDI+ could allow remote code execution Q954593 KB954593 January 25, 2021
• 953199 How to configure and troubleshoot the SubscriptionStreams parameter of the Distribution Agent in SQL Server 2005 and above Q953199 KB953199 January 25, 2021
• 941203 MS08-040: Vulnerabilities in Microsoft SQL Server could allow elevation of privilege Q941203 KB941203 January 25, 2021
• 927396 Queries take a longer time to finish running when the size of the TokenAndPermUserStore cache grows in SQL Server 2005 Q927396 KB927396 January 25, 2021
• 926930 Hard disk drive sector-size support boundaries in SQL Server Q926930 KB926930 January 25, 2021
• 923247 Troubleshooting DBCC error 2570 in SQL Server 2005 and later versions Q923247 KB923247 January 25, 2021
• 920093 Tuning options for SQL Server when running in high performance workloads Q920093 KB920093 January 25, 2021
• 913089 How to obtain the latest service pack for SQL Server 2005 Q913089 KB913089 January 25, 2021
• 906560 How to write information to the Application event log by using a Script task in a SQL Server 2005 Integration Services package Q906560 KB906560 January 25, 2021
• 819546 SQL Server support for mounted volumes Q819546 KB819546 January 25, 2021
• 811889 How to troubleshoot the "Cannot generate SSPI context" error message Q811889 KB811889 January 25, 2021
• 321363 How to adjust memory usage by using configuration options in SQL Server Q321363 KB321363 January 25, 2021
• 316898 How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console Q316898 KB316898 January 25, 2021
• 310834 Description of common causes of SQL Server error message 844 or error message 845 Q310834 KB310834 January 25, 2021
• 309422 How to choose antivirus software to run on computers that are running SQL Server Q309422 KB309422 January 25, 2021
• 307487 How to shrink the tempdb database in SQL Server Q307487 KB307487 January 25, 2021
• 307356 How to understand Merge Replication article processing order Q307356 KB307356 January 25, 2021
• 306397 How to use Excel with SQL Server linked servers and distributed queries Q306397 KB306397 January 25, 2021
• 234656 Information about using disk drive caches with SQL Server that every database administrator should know Q234656 KB234656 January 25, 2021
• 200043 PRB: Dashes '-' Ignored in Search with SQL Full-Text and MSIDXS Queries Q200043 KB200043 January 25, 2021
• 86903 Description of caching disk controllers in SQL Server Q86903 KB86903 January 25, 2021
• 913945 Microsoft does not certify that third-party products will work with Microsoft SQL Server Q913945 KB913945 January 20, 2021
• 75722 How to reduce lock contention in SQL Server Q75722 KB75722 January 14, 2021
• 918222 Cumulative hotfix package (build 2153) for SQL Server 2005 is available Q918222 KB918222 January 13, 2021
• 935897 An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems Q935897 KB935897 January 12, 2021
• 933835 Error message when an SSIS package runs that is scheduled to run as a SQL Server Agent job: "An OLE DB error has occurred. Error code: 0x80004005" Q933835 KB933835 January 7, 2021
• 930615 How to schedule a database backup operation by using SQL Server Management Studio in SQL Server 2005 Q930615 KB930615 January 7, 2021
• 917828 You may experience a decrease in query performance after you perform certain database maintenance operations or regular transaction operations in SQL Server 2005 Q917828 KB917828 January 7, 2021
• 913423 You cannot run a statement or a module that includes the EXECUTE AS clause after you restore a database in SQL Server 2005 Q913423 KB913423 January 7, 2021