Cumulative Update Package 9 for SQL Server 2005 SP2
CU9 for SQL Server 2005 Service Pack 2 has just been released, which I should have guessed as the grounds have also been made for Cumulative Update Package 10 as well.
It seems that you may need CU9 to correct a bug caused from installing Cumulative Update Package 7. What's the problem? Apparently you may get an error message after installing CU7, when you explicitly define a slice at a partition and then process the partition by using a query that returns no records. To read more about the problem that may arise from CU7, that was fixed in CU9, please check the Knowledge Base Article detailing the error message that can come when you process a partition. Another problem that's fixed is for an MDX query that's run against a Parent - Child dimension that has the HideMemberIf property set to ParentIsBlankSelfOrMissing.
You can read further about Cumulative Update Package 9 for SQL Server 2005 SP 2 and then also request a download of CU9.
Still, I have to ask, now that SQL Server 2008 has RTM-ed, when is SP3 going to be released?...