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

• 2001399 Error message when using ProcessAdd on dimensions:"A duplicate attribute key has been found when processing" Q2001399 KB2001399 October 29, 2009
• 2003659 Large number of partitions may impact performance of object dependency check in partition processing batches Q2003659 KB2003659 October 26, 2009
• 975134 FIX: Capitalization and accent changes on a column of user-defined data type are not propagated in SQL Server 2005 merge replication or in SQL Server 2008 merge replication Q975134 KB975134 October 23, 2009
• 974785 FIX: An API cursor plan that is created by a plan guide is not reused when the cursor is active in SQL Server 2005 and in SQL Server 2008 Q974785 KB974785 October 23, 2009
• 972926 FIX: The connection to a Microsoft SQL Server 2005 Reporting Services catalog database encounters an error, and the connection is not reset Q972926 KB972926 October 23, 2009
• 976419 You cannot connect to an instance of SQL Server Analysis Services from an application in Windows 7 or in Windows Server 2008 R2 after you install Office Live Add-in 1.4 or Windows Live ID Sign-in Assistant 6.5 Q976419 KB976419 October 22, 2009
• 975159 FIX: For SQL Server Compact Edition (CE) Subscribers, only schema without data is replicated for newly added articles to an existing Merge Publication using “ExchangeType.Upload” Q975159 KB975159 October 22, 2009
• 2003609 Schema changes are repeatedly enumerated by merge agent during synchronization operation of merge replication in SQL Server Q2003609 KB2003609 October 19, 2009
• 976041 FIX: You receive an incorrect result when you run a query that uses a parallel execution plan in SQL Server 2005 or in SQL Server 2008 Q976041 KB976041 October 19, 2009
• 975748 FIX: You cannot process an object when you change or delete another unrelated object at the same time in the same database in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services Q975748 KB975748 October 19, 2009
• 975417 FIX: A SELECT statement returns an incorrect result set if a linked server is being used in SQL Server 2005 or in SQL Server 2008 Q975417 KB975417 October 19, 2009
• 975230 FIX: You receive an incorrect result when you run a query that uses a ranking function on a partitioned table in SQL Server 2005 Q975230 KB975230 October 19, 2009
• 975089 FIX: The restore operation takes a long time when you restore a database that has query notification enabled in SQL Server 2005 or in SQL Server 2008 Q975089 KB975089 October 19, 2009
• 974777 FIX: Database restore operation may fail during the recovery phase when the database uses query notification in SQL Server 2005 or in SQL Server 2008 Q974777 KB974777 October 19, 2009
• 974296 FIX: A deadlock occurs when you perform an operation that cleans up the security cache in SQL Server 2005 Q974296 KB974296 October 19, 2009
• 974067 FIX: You use the COUNT function on a column that is returned by a subquery that returns no rows in SQL Server 2005 or in SQL Server 2008, and an incorrect result is returned Q974067 KB974067 October 19, 2009
• 973643 FIX: The synchronization of a merge publication that uses Web synchronization takes a very long time to finish after the initial synchronization in SQL Server 2005 or in SQL Server 2008 Q973643 KB973643 October 19, 2009
• 2003580 You may get "The group or resource is not in the correct state to perform the requested operation" when rebuilding system databases on a SQL Server 2005 virtual server Q2003580 KB2003580 October 9, 2009
• 2003582 You cannot add a table article to an Oracle publication if its primary key is partitioned Q2003582 KB2003582 October 8, 2009
• 2003047 Database mirroring wizard could fail on servers where FIPS is enabled Q2003047 KB2003047 October 7, 2009
• 2003021 'Command Line' and 'HTML' action types are not available in the Cube Browser of SQL Server Management Studio Q2003021 KB2003021 October 2, 2009