SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL Server 2005 SP2 CTP Available for Download

The Community Technology Preview (CTP) version SQL Server 2005 SP2 has been released by Microsoft. You can find the download here:


There appear to be some changes on the database engine side that may raise a few eyebrows:
  • SP2 Maintenance Plans cannot be read by earlier versions of the SQL Server 2005 tools.
  • Some performance counters aren't visible in Performance Monitor.
There are changes on Analysis Services and Reporting Services as well.

Technorati Tags: | | | | |

K. Brian Kelley - Databases, Infrastructure, and Security

IT Security, MySQL, Perl, SQL Server, and Windows technologies.


Posted by Rustom on 5 January 2007
Do you know when Microsoft will be officially releasing SP2 for SQL?
Posted by K. Brian Kelley on 6 January 2007
The only information I've seen is 1Q 2007, so by March.

Posted by sangeethashekar on 19 January 2007
Please check out http://blogs.msdn.com/sqlprogrammability/ for a series of articles on the Plan Cache and improvements made to the plan cache in SQL Server 2005 SP2. The articles also have a number of examples and queries on plan cache related DMVs that you may find useful.
Leave a Comment

Please register or log in to leave a comment.