• Hi Wayne,

    >>I dont see a list of any new features included in the service pack<<

    On the download page for the SP2 CTP, there's a link to an overview of all new features, conveniently labeled "review the What's New document". Clicking this link takes you to http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/WhatsNewSQL2005SP2.htm. As you can see, there are LOTS of new features.

    >>Most importantly, I had only about 20 minutes of down-time.<<

    That's way to much for many shops. And way more than necessary. Instead of stopping all SQL Server services and then some in order to avoid a reboot, why not leave SQL Server running during the install process and accept a reboot when the installation is finished? Or are you trying to tell me that rebooting your system would have taken more than 20 minutes?


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/