Known Issue In Cumulative Updates For SQL Server 2005 SP2, SP3, SQL Server 2008 RTM, SP1 In Analysis Services Partition Processing Engine

  • Article

Dear SQL Server Customers,

We have learned of degraded customer experience with …

· SQL Server 2005 Service Pack 2 (SP2) Cumulative Update 12, 13, 14, 15 and 16.

· SQL Server 2005 Service Pack 3 (SP3) Cumulative Update 3, 4 and 5.

· The release version of SQL Server 2008 Cumulative Update 3, 4, 5, 6 and 7.

· SQL Server 2008 Service Pack 1 (SP1) release version, Cumulative Update 1, 2, 3 and 4.

Build number ranges below.

 

Customers using SQL Server 2005 or 2008 Analysis Services may see the symptom as described in KB 975783. This KB article provides details of available workarounds and information about hotfix packages which rectify the issue as they become available. For SQL Server 2008 RTM and SQL Server 2008 SP1 we anticipate releasing the fix next week. For SQL Server 2005 SP3 customers, the fix is available in CU6 – KB 974648. Customers of SQL Server 2005 SP2, a hotfix solution will be available in the next Cumulative Update.

Affected Build Range

Customers with ...

· SQL Server 2005 Service Pack 2 (SP2) Build 9.00.3315 to 9.00.3355

· SQL Server 2005 Service Pack 3 (SP3) Build 9.00.4220 to 9.00.4265

· The release version of SQL Server 2008 Build 10.00.1787 to 10.00.1822

· SQL Server 2008 Service Pack 1 (SP1) Build 10.00.2531, 10.00.2710 to 10.00.2742

 

Resolution:

SQL Server release

Affected Cumulative Update (version of SQL Server)

Resolution

SQL Server 2005 SP2

9.00.3315 to 9.00.3355

Please refer to the work around published in KB 975783.

SQL Server 2005 SP3

9.00.4220 to 9.00.4265

Apply SQL Server 2005 SP3 Cumulative update package 6.

The release version of SQL Server 2008

10.00.1787 to 10.00.1822

Please refer to the work around published in KB 975783. A hotfix solution shall be available next week.

SQL Server 2008 SP1

10.00.2531, 10.00.2710 to 10.00.2742

Please refer to the work around published in KB 975783. A hotfix solution shall be available next week.

Abhishek Sinha

Program Manager

SQL Server Sustained Engineering