• John Bates (5/27/2008)


    At first glance, I tend to disagree. I don't always know which features will be used in the long-term on a new SQL Server. So I install AS,IS and RS. Then I install the latest Service Pack. (If I install RS later, I will have to reapply the Service Pack to fully patch that new module)

    And by having it already installed, it is ready to use if/when we decide to use that feature.

    Of course I agree with stopping the services related to an unused product.

    This is just my practice.

    This practice is flawed. Best Practice dictates that you should install only what you need. If you aren't sure, then someone who is should be performing the installation.

    As for the guy saying "If you had googled first" I would submit that little relevant information would be returned. This is a case of an experienced DBA using his knowledge along with a little bit of testing to resolve an error that is generally not documented.

    Well done. Nice article. And now a google search WILL return relevant information for DBAs who run into the same issue.