kbupdate.info ›
Daily Updated!
SQL Server 2005 articles, fixes and updates - October 2009
Daily Updated!
chronological list: 2010/9 ... 5 4 3 2 1 | 2009/12 11 10 9 8 7 6 5 4 ... 2003
alphabetical list: A B C D E F G H I K L M N O P Q R S T U V W Y
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.
- 943525 You cannot start the SQL Server Agent service of a failover cluster of SQL Server 2005 if the build of SQL Server is 3179 or a later build Q943525 KB943525 October 30, 2009
- 2001399 Error message when using ProcessAdd on dimensions:"A duplicate attribute key has been found when processing" Q2001399 KB2001399 October 29, 2009
- 2001221 SQL Server reports 701: "There is insufficient memory to run this query" when executing large batches Q2001221 KB2001221 October 28, 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
- 974648 Cumulative update package 6 for SQL Server 2005 Service Pack 3 Q974648 KB974648 October 22, 2009
- 928789 FIX: Error message in the database mail log when you try to use the sp_send_dbmail stored procedure to send an e-mail in SQL Server 2005: "Invalid XML message format received on the ExternalMailQueue" Q928789 KB928789 October 21, 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
- 976030 FIX: Error message after you perform a Process Update on a dimension used on a cube that contains a writeback partition: "Errors in the high-level relational engine. The data source view does not contain a definition for the <tablename> table or view" Q976030 KB976030 October 19, 2009
- 975860 FIX: A full backup with snapshot may cause SQL Server 2005 or SQL Server 2008 to stop responding Q975860 KB975860 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
- 975681 FIX: The database mirroring session is suspended when you add more than one log transaction file to a folder on the principle server that does not exist on the mirror server in SQL Server 2005 or in SQL Server 2008 Q975681 KB975681 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
- 975090 FIX: Deadlocks may occur when multiple concurrent query notification subscriptions are fired on same objects in SQL Server 2005 or in SQL Server 2008 Q975090 KB975090 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
- 974647 Cumulative update package 16 for SQL Server 2005 Service Pack 2 Q974647 KB974647 October 19, 2009
- 974319 FIX: Error message when you use database mirroring in SQL Server 2005 or in SQL Server 2008, and an assertion failure occurs intermittently: "SQL Server Assertion: File: <loglock.cpp>, line=823 Failed Assertion = 'result == LCK_OK'." Q974319 KB974319 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
- 974130 FIX: A memory leak may occur if you use a linked server query to retrieve a sql_variant column from a remote server in SQL Server 2005 or in SQL Server 2008 Q974130 KB974130 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
- 2001270 Things to consider when setting up database mirroring in SQL Server. Q2001270 KB2001270 October 14, 2009
- 970896 MS09-062: Description of the security update for SQL Server 2005 Service Pack 2 QFE: October 13, 2009 Q970896 KB970896 October 13, 2009
- 970895 MS09-062: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: October 13, 2009 Q970895 KB970895 October 13, 2009
- 970894 MS09-062: Description of the security update for SQL Server 2005 Service Pack 3 QFE: October 13, 2009 Q970894 KB970894 October 13, 2009
- 970892 MS09-062: Description of the security update for SQL Server 2005 Service Pack 3 GDR: October 13, 2009 Q970892 KB970892 October 13, 2009
- 957488 MS09-062: Vulnerabilities in GDI+ could allow remote code execution Q957488 KB957488 October 13, 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
- 920093 Tuning options for SQL Server 2005 and SQL Server 2008 when running in high performance workloads Q920093 KB920093 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
- 2000474 DCOM Permissions for SSIS service are Reset after applying a service pack or a cumulative update or a hotfix Q2000474 KB2000474 October 2, 2009
- 911305 SQL Server Agent jobs may fail after you change the SQL Server Agent service startup account by using the Windows Service Control Manager Q911305 KB911305 October 1, 2009