SQL Server 2005 Service Pack 2 has been released. You can find more information from the service pack 2 page.
This service pack extends the functionality of SQL Server in many ways. The What's New document highlights the major changes in the Database Engine, Analysis Services, Integration Services and others. The service pack also has performance and manageability enhancements that will be of interest to lot of developers and database administrators.
Please download the latest service pack and test your database applications with it to see the benefits.