Enhanced SQL Server 2008 SP2 Released By Microsoft


Microsoft has released an update for SQL Server 2008 with some improvements around reporting and management features.

SQL Server 2008 Service Pack 2 (SP2) includes updates for Reporting Services integration with SharePoint products. SQL Server 2008 SP2 report servers can integrate with SharePoint 2010 products and the pack also provides an add-in to provide similar integration with SharePoint 2007.

“This now enables SharePoint Server 2007 to be used with SQL Server 2008 R2 Report Server,” according to the Microsoft SQL Server Team blog.

Data Tier Operations

In addition, an instance of the SQL Server 2008 Database Engine can be enrolled with a SQL Server 2008 R2 Utility Control Point as a managed instance of SQL Server, Microsoft said. Instances of SQL Server 2008 Database Engine in SP2 support all Data Access Component (DAC) data-tier application operations.

“You can deploy, upgrade, register, extract, and delete DACs,” Microsoft said. “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,” the company added.

SQL Server 2008 SP2 can be downloaded from the Microsoft website.


Brian Prince eWEEK USA 2014. Ziff Davis Enterprise Inc. All Rights Reserved

Share
Published by
Brian Prince eWEEK USA 2014. Ziff Davis Enterprise Inc. All Rights Reserved
Tags: SQL Server

Recent Posts

Craig Wright Sentenced For Contempt Of Court

Suspended prison sentence for Craig Wright for “flagrant breach” of court order, after his false…

3 days ago

El Salvador To Sell Or Discontinue Bitcoin Wallet, After IMF Deal

Cash-strapped south American country agrees to sell or discontinue its national Bitcoin wallet after signing…

3 days ago

UK’s ICO Labels Google ‘Irresponsible’ For Tracking Change

Google's change will allow advertisers to track customers' digital “fingerprints”, but UK data protection watchdog…

3 days ago

EU Publishes iOS Interoperability Plans

European Commission publishes preliminary instructions to Apple on how to open up iOS to rivals,…

4 days ago

Momeni Convicted In Bob Lee Murder

San Francisco jury finds Nima Momeni guilty of second-degree murder of Cash App founder Bob…

4 days ago