SQL Server 2008 SP2 contains the following features:
· All hotfixes released up to Microsoft SQL Server 2008 SP1 CU 8.
· Updates to the Reporting Services Add-in for Microsoft SharePoint Products 2007 allowing customer to connect to SQL Server 2008 R2 Report Servers.
· Support for SQL Server 2008 R2 version of Management Studio to perform operations for data-tier applications (DAC) in SQL Server 2008 instances that have SP2 installed. For more information please visit http://msdn.microsoft.com/en-us/library/ee240739.aspx.
· Support for SQL Server 2008 R2 Utility Explorer and SQL Server Utility viewpoints in (SSMS) provide administrators a holistic view of resource health through an instance of SQL Server that serves as a utility control point (UCP). For more information please visit http://msdn.microsoft.com/en-us/library/ee210557.aspx.