Microsoft SQL Server 2005 Service Pack 2 (SP2) enables SQL Server 2005 customers to take advantage of the enhancements within Windows Vista and the 2007 Office system. Specific enhancements include, but are not limited to:
•Enhanced BI Capabilities
•Performance and Manageability Enhancements
Review what's new in SQL Server 2005 Service Pack 2 for information on new or improved features in Analysis Services, Database Engine, Integration Services, Reporting Services, and Shared Tools.