SQL Server 2005 articles, fixes and updates - January 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 January 2010. The list is daily updated.

• 2002452 The formatting of the columns is incorrect when using Excel to view csv file attachments sent from SQL Server's Database Mail Q2002452 KB2002452 January 28, 2010
• 978597 Error code when you use Windows Update or Microsoft Update to install updates on a computer that has SQL Server 2005 installed: "0x737D" Q978597 KB978597 January 22, 2010
• 970672 FIX: Error message in the Errorlog file when you run a query in SQL Server 2005: "A time-out occurred while waiting for buffer latch" Q970672 KB970672 January 22, 2010
• 2009212 You are not able to browse SharePoint pages in non-default zone after uninstalling Reporting Services add-in Q2009212 KB2009212 January 19, 2010
• 978851 FIX: The -R parameter is ignored when you use the BCP.exe utility together with the -R parameter and the -F parameter in SQL Server 2005 or in SQL Server 2008 Q978851 KB978851 January 18, 2010
• 977842 FIX: An access violation occurs when you run the SET FMTONLY statement to set the value of the FMTONLY option to ON and a SQL Server 2005 or SQL Server 2008 server is under memory pressure Q977842 KB977842 January 18, 2010
• 977450 FIX: Error message when you run a query that uses a common table expression to shred XML data in SQL Server 2005 or in SQL Server 2008: "Internal Query Processor Error: The query processor could not produce a query plan" Q977450 KB977450 January 18, 2010
• 977309 FIX: A SSAS 2005 or SSAS 2008 server crashes when you run a Multidimensional Expressions query that uses the CDBL function in a calculated member Q977309 KB977309 January 18, 2010
• 977151 FIX: Error message when you add a subscription to a republisher that is in a merge publication in SQL Server 2005 or in SQL Server 2008: “Cannot create the subscription because the subscription already exists in the subscription database” Q977151 KB977151 January 18, 2010
• 976974 FIX: You are continuously prompted for credentials when you use Business Intelligence Development Studio to deploy a SQL Server 2005 Reporting Services or SQL Server 2008 Reporting Services report Q976974 KB976974 January 18, 2010
• 976691 FIX: An access violation occurs intermittently when you run an application that uses SQL Server 2005 service broker or SQL Server 2008 service broker Q976691 KB976691 January 18, 2010
• 976565 FIX: A query that opens a cursor in an inline table-valued function or a view returns an incorrect result in SQL Server 2005 or in SQL Server 2008 Q976565 KB976565 January 18, 2010
• 976410 FIX: Performance issues occur when the join predicate in your query has outer reference columns in SQL Server 2005 or in SQL Server 2008 Q976410 KB976410 January 18, 2010
• 975950 FIX: Error message when you run an SSIS 2005 or SSIS 2008 package that uses the IBM DB2 OLE DB provider to export data to an IBM DB2 server: "The number of failing rows exceeds the maximum specified. Out of memory" Q975950 KB975950 January 18, 2010
• 975825 FIX: A row is not deleted at a subscriber when you delete a row at the publisher and then perform synchronization in a SQL Server 2005 or SQL Server 2008 merge replication Q975825 KB975825 January 18, 2010
• 974749 FIX: The last character of a char column or an nchar column is incorrectly replaced by a space character (char(32)) after a conflict is resolved by a customized conflict resolver in SQL Server 2005 or in SQL Server 2008 Q974749 KB974749 January 18, 2010
• 973785 FIX: Membership is not scripted in the predefined database roles after you script a database and enable the "Script object-level permissions" option in SQL Server 2005 or in SQL Server 2008 Q973785 KB973785 January 18, 2010
• 2008195 Issues to consider when changing the default value of network packet size for SQL server connections Q2008195 KB2008195 January 14, 2010
• 2006769 "Communication link failure" error message is reported for SSIS packages on SQL servers configured to use encryption and a large network packet size Q2006769 KB2006769 January 14, 2010
• 2009160 High CPU utilization may occur with your queries on SQL Server 2005 and SQL Sever 2008 servers compared to SQL Server 2000 Q2009160 KB2009160 January 13, 2010
• 919023 SQL Server 2005 connectivity and Volume Shadow Copy Service (VSS) Q919023 KB919023 January 13, 2010
• 883732 A SQL Server cluster resource goes to a "failed" state when you try to bring the resource online in SQL Server Q883732 KB883732 January 8, 2010
• 945934 How to register Microsoft Filter Pack IFilters with SQL Server 2005 and with SQL Server 2008 Q945934 KB945934 January 7, 2010
• 811889 How to troubleshoot the "Cannot generate SSPI context" error message Q811889 KB811889 January 7, 2010
• 2007166 Log Reader Agent reports “The process could not execute 'sp_replcmds' on '%s'” on a partitioned table with more than 92 partitions Q2007166 KB2007166 January 6, 2010