MS released Cumulative update package 7 for SQL Server 2005 Service Pack 2
On April 17th Microsoft released cumulative update package 7 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 |
| 50002304 | 948450 | FIX: CPU utilization of a CPU in a single node increases to 100 percent when you use SQL Server 2005 on a multiprocessor computer that uses NUMA architecture |
| 50002405 | 950992 | FIX: Error message when you run an MDX query that uses the TopCount function in SQL Server 2005 Analysis Services: "File system error: The record ID is incorrect. Physical file: . Logical file:" |
| 50002435 | 950993 | FIX: The SQL Server 2005 Analysis Services service stops intermittently when you run an MDX query |
| 50002441 | 950968 | FIX: Error message when you restore a database backup in SQL Server 2005 Analysis Services: "An error occurred when instantiating a metadata object from the file". *** NOTE - follow link to article at the end of this page |
| 50002456 | 949631 | FIX: Error message when you try to create a currency conversion against an Oracle data source in SQL Server 2005 Analysis Services: "The following statement executed when creating named query: SELECT 'Reporting Currency'" |
| 50002475 | 951075 | FIX: An access violation may occur when you configure SQL Server 2005 Analysis Services to use query logging |
| 50002502 | A calculated member in SQL Server 2005 Analysis Services returns an incorrect result if the calculated member is created by using the Aggregate function or the Sum function that uses another calculated member that is created by using the Aggregate function or the Sum function on a parent/child dimension | |
| 50002522 | An access violation occurs in the PFStoreIterator::MoveByPageAndSlot function when you run an MDX query whose slice contains a calculated member in SQL Server 2005 Analysis Services | |
| 50002525 | When you use the Process Incremental option to process a partition in SQL Server 2005 Analysis Services, the existing aggregation may be lost | |
| 50002559 | 951001 | FIX: An incorrect value is returned when you run an MDX query on a cube in SQL Server 2005 Analysis Services |
| 50002561 | When you run MDX queries in SQL Server 2005 Analysis Services that has a build that is later than 3200, internal errors and dump files may be generated | |
| 50002586 | When you run an MDX query that contains a member in the WHERE clause and when the member uses the AGGREGATE function on a named set, the query may return an incorrect result in SQL Server 2005 Analysis Services | |
| 50002587 | 951073 | FIX: A minidump file is generated in the SQL Server 2005 Analysis Services log folder when you run the ALTER XMLA command while an MDX query is running |
| 50002596 | When SQL Server 2005 Analysis Services resolves a named set that is not at the top level, Analysis Services may return incorrect results, or an access violation may occur | |
| 50002631 | An access violation occurs when you use the USE_WEIGHTED_ALLOCATION allocation method to perform cell writeback operations in SQL Server 2005 Analysis Services | |
Please also read related post: Changes introduced in CU#7 may impact Analysis Services backup and sync operations.
Tags: news, cumulative update, partition