Microsoft SQL Server 2008 Service Pack 2 (SP2) is now available for download.
You can download your preferred version from link here.
The major enhancements are as following:
- 15K partitioning Improvement.
- Reporting Services in SharePoint Integrated Mode.
- SQL Server 2008 R2 Application and Multi-Server Management Compatibility with SQL Server 2008.
- SQL Server 2008 Instance Management.
- Data-tier Application (DAC) Support.
Reference: Pinal Dave (https://blog.sqlauthority.com)
Does this sp apply to R2 or just normal sql 2008 ?
I am not sure. I just downloaded and ran it on my local box.
By the way I have 2005 and 2008 Instance on my local computer.
I applied SP 4 on SQL Server 2005 it went fine without anything.
I am trying to install sp 2 on sql server 2008 RTM, but I am getting an error below.
TITLE: SQL Server 2008 Service Pack 2
There are validation errors on this page. Click OK to close this dialog box. Review errors at the bottom Setup page, then provide valid parameters or click Help for more information.
Salman, you got this error because this package does not apply on R2 edition. Certainly, your SQL Server is 2008 R2, isn’t it?
Walter I received this error a little bit similar to the one above but this is for SP1
SQL Server 2008 Service Pack 1 There are validation errors on this page. Click OK to close this dialog box. Re
same with me .i apply both sp1 and sp2 but no same
me too, i have the same error