Setting Default Database

• Carl Rimmer

  SSCarpal Tunnel

  Points: 4068

  More actions

  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

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  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]

• Carl Rimmer

  SSCarpal Tunnel

  Points: 4068

  More actions

  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