SQL Server 2005 articles, fixes and updates - December 2010

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

• 918644 FIX: The SQL Server Integration Services (SSIS) service does not start when you install SQL Server 2005 SP1 on a computer that is already running the SSIS service Q918644 KB918644 December 30, 2010
• 2470176 Applications may fail after upgrading your database from SQL Server 2000 to a later version Q2470176 KB2470176 December 29, 2010
• 2006312 Logshipping monitor incorrectly raises error number 14420 instead of 14421 when the secondary database is out of sync Q2006312 KB2006312 December 29, 2010
• 2003031 Query performance decreases when sys.dm_db_index_usage_stats has large number of rows Q2003031 KB2003031 December 27, 2010
• 2464079 Cumulative update package 1 for SQL Server 2005 Service Pack 4 Q2464079 KB2464079 December 24, 2010
• 2460783 RS 2005 Standard Edition may hang on systems with multiple CPUs Q2460783 KB2460783 December 24, 2010
• 2428229 FIX: Error message when you use Query Designer in SQL Server 2005:"Unable to find an entry point named 'GetWindowLongPtr' in 'user32.dll'" Q2428229 KB2428229 December 23, 2010
• 2397173 FIX: A blank cell is returned when you query XML data by using the "Results to Grid" mode in SQL Server 2005 Management Studio if a large amount of data exists Q2397173 KB2397173 December 23, 2010
• 2389533 FIX: "Infinite recursion detected" error message when a drillthrough action is used in SQL Server 2005 Analysis Services SP3 CU7 Q2389533 KB2389533 December 23, 2010
• 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 December 23, 2010
• 983500 FIX: The role synchronization process is delayed when a mirroring automatic failover occurs in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q983500 KB983500 December 22, 2010
• 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 December 20, 2010
• 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 or of SQL Server Q950599 KB950599 December 20, 2010
• 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 December 20, 2010
• 913089 How to obtain the latest service pack for SQL Server 2005 Q913089 KB913089 December 18, 2010
• 2292737 Rebuilding an index can result in fragmented index when ALLOW_PAGE_LOCKS option is not enabled Q2292737 KB2292737 December 17, 2010
• 955693 FIX: In SQL Server 2005, the file information about the transaction log that was last copied and the file information about the transaction log that was last restored are missing Q955693 KB955693 December 16, 2010
• 975860 FIX: A full backup with snapshot may cause SQL Server 2005 or SQL Server 2008 to stop responding Q975860 KB975860 December 15, 2010
• 2450864 PRB:You are not able to change the default location for Full-Text Catalogs Q2450864 KB2450864 December 13, 2010