Microsoft SQL Server 2008: SP2 now available for download

Microsoft has announced the availability of SQL Server 2008 Service Pack 2. Both the Service Pack and Feature Pack updates are now ready for download on the Microsoft Download Center.

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.

Key improvements in Microsoft SQL Server 2008 Service Pack 2:

- Reporting Services in SharePoint Integrated Mode:
SQL Server 2008 SP2 provides updates for Reporting Services integration with SharePoint products. SQL Server 2008 SP2 report servers can integrate with SharePoint 2010 products. SQL Server 2008 SP2 also provides a new add-in to support the integration of SQL Server 2008 R2 report servers with SharePoint 2007 products. This now enables SharePoint Server 2007 to be used with SQL Server 2008 R2 Report Server.

- SQL Server 2008 R2 Application and Multi-Server Management Compatibility with SQL Server 2008:

i) SQL Server 2008 Instance Management:
With SP2 applied, 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. SQL Server 2008 SP2 enables organizations to extend the value of the Utility Control Point to instances of SQL Server 2008 SP2 without having to upgrade those servers to SQL Server 2008 R2.

ii) Data-tier Application (DAC) Support:
Instances of the SQL Server 2008 Database Engine support all DAC operations delivered in SQL Server 2008 R2 after SP2 has been applied. 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.

Download: SQL Server 2008 SP2 | SQL Server 2008 SP2 Express | SQL Server 2008 SP2 Feature Packs

Additional useful links: SQL Server 2008 SP1 CU’s Released | Knowledge Base Article For Microsoft SQL Server 2008 SP2 | Overview of SQL Server Utility | Designing and Implementing Data-tier Applications | What’s New (Reporting Services)

About these ads

2 responses to this post.

  1. how are you!This was a really impressive blog!
    I come from china, I was fortunate to discover your Topics in bing
    Also I learn much in your blog really thank your very much i will come every day

    Reply

  2. Is there anymore information you can give on this subject. It answers a lot of my questions but there is still more info I need. I will drop you an email if I can find it. Never mind I will just use the contact form. Hopefully you can help me further.

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 48 other followers

%d bloggers like this: