MS released Cumulative update package 10 for SQL Server 2005 Service Pack 2
On October 20th Microsoft released cumulative update package 10 for SQL Server 2005 Service Pack 2.
List of fixes related to SQL Server Analysis Services 2005 SP2:
SQL Bug Number | KB Article Number | Description |
| 50003132 | 955374 | FIX: Error message when you run an MDX query in SQL Server 2005 Analysis Services after you install cumulative update 7 for SQL Server 2005 Service Pack 2: "The SQL Server Analysis Services (<InstanceName>) service terminated unexpectedly" |
| 50003142 | 956387 | FIX: Error message when you query the attribute members of a parent/child dimension in SQL Server 2005 Analysis Services: "Either you do not have permission to access the specified member, or the specified member does not exist" |
| 50003418 | 957399 | FIX: When you specify cell permissions for a role in SQL Server 2005 Analysis Services Service Pack 2, the execution time for MDX queries is much longer than in SQL Server 2005 Analysis Services Service Pack 1 |
| 50003151 | 958500 | FIX: MDX queries that use the EXCEPT function in the WHERE clause run much slower after you install a hotfix or a cumulative update whose version is later than the version of Cumulative Update 4 for SQL Server 2005 SP2 |
| 50003398 | 958549 | FIX: You may be unable to cancel the execution of an MDX query that uses the NonEmpty function on a large set in SQL Server 2005 Analysis Services |
Note: Microsoft is expecting to release SQL Server 2005 SP3 some time before the year end of 2008. The SP3 will contain the rollup of all CU's up until and including CU#9 from SQL Server 2005 SP2 and many of customer reported issues including watson reported issues. So this CU10 will not be included in SP3. Keep this in mind if you are planning to deploy SP3.
Tags: news, cumulative update