Post reply

Setting Default Database

  • January 17, 2005 at 5:12 am

    #87272

    I am looking to set the default database locations on our sql servers to make it easier to roll out new databases through scripts.

    Do you need to stop and start the SQLSERVERSERVICE for this change to take effect?

    Thanks in advance

    Carl

  • January 17, 2005 at 5:37 am

    #537643

    AFAIK, this information is stored in the registry, so it takes effect immediately. There should be no need to restart the server.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • January 17, 2005 at 5:49 am

    #537645

    Cheers Frank,

    I have read that it sets a registry setting but wasn't sure whether a top and restart was necessary.

     

    Carl

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply