Cumulative Update Package 7 for SQL Server 2005 Service Pack 2
Microsoft has recently announced the release of Cumulative Update Package 7 for SQL Server 2005 Service Pack 2. CU 7 comes 2 months after its predecessor (just like they promised) and yet again, the groundwork is already built for Cumulative Update Package 8. You can read more about Cumulative Update Package 7 and also download CU 7 upon request from Microsoft Support.
You should be aware though, that the Microsoft PSS SQL Support team has announced that installing Cumulative Update Package 7 can impact your SSAS backup and sync operations. This is due to the fact that the fix includes changes to the locking levels used by backup and sync operations. This can be solved mostly by scheduling this sort of operations at a time that will not overlap with processing of objects in your Analysis Services project. Still, I would recommend you read the article for further information on the subject.
In the most exciting news, I would also like to assure you that Microsoft will indeed release SQL Server 2005 SP3! This announcement comes following customer feedback. Still, SQL Server 2005 Service Pack 3 should only be expected after the release to manufacturing of SQL Server 2008.
So till then, look at what's offered in Cumulative Update Package 7 for SQL Server 2005 Service Pack 2.