Microsoft SQL Server 2008 Service Pack 2 (SP2) is now available for download

Download Microsoft SQL Server 2008 Service Pack 2 (SP2)
Microsoft SQL Server 2008 Service Pack are cumulative updates may be used to upgrade any edition of SQL Server 2008. This Service Pack contains an updates for SQL Server Utility, Data-Tier Application (DAC), as well as integration capability for Microsoft Reporting Services with the Microsoft SharePoint 2010 Technologies. Service Pack 2 introduces support for a maximum of 15,000 partitions in a database, and includes SQL Server 2008 SP1 Cumulative Update 1 to 8. Moreover, Microsoft SQL Server 2008 Service Pack 1 is not a prerequisite for installing SQL Server 2008 Service Pack 2.

What’s New in Microsoft SQL Server 2008 Service Pack 2
Microsoft SQL Server 2008 SP2 contains the following new features:
  • SQL Server Utility. After you apply SP2, an instance of the SQL Server 2008 Database Engine can be enrolled with a utility control point as a managed instance of SQL Server.
  • Data-tier Application (DAC) Support. After you apply SP2, instances of the SQL Server 2008 Database Engine support all DAC operations. You can deploy, upgrade, register, extract, and delete DACs. SP2 does not upgrade the SQL Server 2008 client tools to support DACs. You must use the SQL Server 2008 R2 client tools, such as SQL Server Management Studio, to perform DAC operations. A data-tier application is an entity that contains all of the database objects and instance objects used by an application. A DAC provides a single unit for authoring, deploying, and managing the data-tier objects
  • Reporting Services in SharePoint Integrated Mode. SP2 provides updates for Reporting Services SharePoint integration. SQL Server 2008 SP2 report servers can integrate with SharePoint 2010 products. SQL Server 2008 SP2 also provides a new add-in for SharePoint 2007 products. The new add-in supports the integration of SharePoint 2007 products with SQL Server 2008 R2 report servers.
  • 15K Partitioning Improvement. SP2 introduces support for a maximum of 15,000 partitions in tables and indexes in the Enterprise, Developer, and Evaluation Editions of Microsoft SQL Server 2008 SP2.

For more information about Microsoft SQL Server 2008 Service Pack 2, please visit Microsoft SQL Server 2008 Service Pack 2- Release Notes page.

Note: The Microsoft SQL Server 2008 SP2 applies to the SQL Server 2008 release only. This service pack can not be applied on top of SQL Server 2008 R2.

How to download Microsoft SQL Server 2008 Service Pack 2
The links in this section correspond to files available for Microsoft SQL Server 2008 SP2. Download the files appropriate for you.

Source: Microsoft SQL Server 2008 Service Pack 2
at
Labels:

No comments:

Post a Comment