SQL Server 2005 articles, fixes and updates - December 2009

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

• 956213 Error message when you try to generate a Report Builder model from a data source in SharePoint Server 2007 or in Windows SharePoint Services 3.0: "Server was unable to process request. ---> The operation has timed out" Q956213 KB956213 December 29, 2009
• 977100 FIX: An insert operation for a temporary table that has a foreign key constraint fails when the execution plan for the INSERT statement contains a merge join operation in SQL Server 2005 Q977100 KB977100 December 24, 2009
• 977350 FIX: Assertion failures occur in SQL Server 2005 when a Distributed Transaction Coordinator (DTC) transaction is rolled back while that transaction is being commited by the DTC Q977350 KB977350 December 22, 2009
• 977376 FIX: Even though the Distribution Agent successfully reapplies a batch of failed commands, you still receive error message 20046 that indicates that the Distribution Agent failed in a SQL Server 2005 or SQL Server 2008 transactional replication Q977376 KB977376 December 21, 2009
• 977255 FIX: The leading spaces in a text box or spaces in a multiline text block are truncated when you export a SQL Server 2005 Reporting Services report to a PDF file Q977255 KB977255 December 21, 2009
• 977247 FIX: An access violation occurs when you run a query on a table that has a partitioned nonclustered index in SQL Server 2005 Q977247 KB977247 December 21, 2009
• 977007 FIX: MDX queries in a calculation script fail with an internal exception and cause SQL Server 2005 Analysis Services to crash when they are used to generate complex calculations that has some function calls to an external DLL assembly Q977007 KB977007 December 21, 2009
• 976952 Cumulative update package 17 for SQL Server 2005 Service Pack 2 Q976952 KB976952 December 21, 2009
• 976951 Cumulative update package 7 for SQL Server 2005 Service Pack 3 Q976951 KB976951 December 21, 2009
• 976754 FIX: An assertion failure occurs when you query the sys.dm_broker_activated_tasks DMV in SQL Server 2005 or in SQL Server 2008 Q976754 KB976754 December 21, 2009
• 976412 FIX: An MDX query resets to a blank query when you click the Data tab in Business Intelligence Development Studio 2005 Report Designer Q976412 KB976412 December 21, 2009
• 2008286 Error message when you use Database Mail after applying service pack: “System.IndexOutOfRangeException: timeout” Q2008286 KB2008286 December 18, 2009
• 978145 FIX: Error message when you concurrently process objects in SQL Server Analysis Services after you install a cumulative update: "While attempting to acquire one or more locks, the transaction was canceled" Q978145 KB978145 December 17, 2009
• 2009225 You receive a “Connections to SQL server files (.mdf) require SQL Server Express 2005 to function properly.” exception when adding a new SQL Server database in App_Data folder. Q2009225 KB2009225 December 15, 2009
• 917409 How to configure SQL Server 2008 Analysis Services and SQL Server 2005 Analysis Services to use Kerberos authentication Q917409 KB917409 December 11, 2009
• 974412 DST time zone update for SQL Server 2005 Notification Services and for SQL Server 2000 Notification Services Q974412 KB974412 December 10, 2009
• 2009037 You are not able to install Full Text search resource on a SQL Server 2005 SP3 cluster Q2009037 KB2009037 December 8, 2009
• 960922 Mere Query timeout can lead to fullscale SQLCLR AppDomain unload in some conditions. Q960922 KB960922 December 3, 2009