The new Service Pack (SP2) for SQL 2005 is now available. The new features enables to take advantage of the enhancements within Windows Vista and the 2007 Office system. The following components have new or improved features:
Analysis Services (e.g. support for Microsoft Office 2007 business intelligence features),
Database Engine (e.g. added logon triggers and a common criteria compliance enabled Option for sp_configure to support Common Criteria in the SQL Server 2005 Enterprise Edition),
Integration Services (e.g. troubleshoot a package’s interaction with external data sources by enabling logging and selecting the package’s Diagnostic event for logging),
Replication (e.g. merge replication now provides a stored procedure that regenerates the triggers),
Reporting Services (e.g. you can integrate a report server instance with Windows SharePoint Services 3.0 or Microsoft Office 2007 SharePoint Server) download the SP2 for SQL 2005