Microsoft just released SQL server sp3 for 2005. Just when you thought it was time to move to 2008 it still is, but if you are still running 2005 look into this pack enhancements.

The purpose of a service pack is to provide a tested intermediate-level upgrade that contains fixes to bugs encountered since the last version release. Service packs don’t typically add new features to the product, although they might provide enhanced behavior to features that were new in the most recent version but weren’t completely ready by the release to manufacturing date. However, Microsoft doesn’t always abide by this definition of service pack, and there have been SQL Server service packs that have added new features, new columns to existing metadata objects, or even entirely new metadata views or functions

Also if you’ve previously applied hotfixes or recent Cumulative Updates (CUs) for Sql Server 2005 SP2 (CU12 or CU11). The most succinct explanation of the relationship between SQL Server 2005 SP3 and the various CUs, including SQL Server 2005 SP3 CU1, which will be released in a week, can be found on Aaron Bertrand’s blog. You can find a list of bugs that have been fixed in SQL Server 2005 SP3 at http://support.microsoft.com/?kbid=955706.