Microsoft has released a second service pack for Sql Server 2005. Service Pack 2 makes the server compatible with Windows Vista and extends the data-mining possibilities of Sql Server. Although Microsoft calls it a service pack, by installing SP2 Sql Server really gets a number of new features.

Many of the new possibilities have to do with the integration with Windows Vista and Office 2007 as a result of which functionality is added on the business intelligence area.

Sharepoint Server 2007 can now be integrated with Sql Server to deliver reports and the functionality of Sql Server Analysis Services is directly accessible from within Excel and Visio 2007.

More information about Sql Server Service Pack 2 can be found here:

http://technet.microsoft.com/en-us/library/bb283536(SQL.90).aspx
and
http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/WhatsNewSQL2005SP2.htm