Microsoft Releases SQL Server 2008 Service Pack 2

Microsoft has released the second service pack for its SQL Server 2008 client, in order streamline it with the SQL Server 2008 R2.

According to the software giant, the new service pack will allow users to integrate reporting services with SharePoint products.

“Service Pack 2 for SQL Server 2008 includes new compatibility features with SQL Server 2008 R2, product improvements based on requests from the SQL Server community, and hotfix solutions provided in SQL Server 2008 SP1 Cumulative Update 1 to 8,” the company wrote on the TechNet blog.

The update will allow users to integrate SQL Server 2008 Database Engine with SQL Server 2008 R2 Utility Control Point, to be used as a managed instance. Users will be able to derive the most out of the database client without updating it to Server 2008 R2.

The SP2 will also allow users to support the Data-tier Application (DAC) operations that are used in SQL Server 2008 R2.