Changing @@servername without a reboot

• Lowell

  SSC Guru

  Points: 323741

  More actions

  December 1, 2006 at 6:06 am

  #675112

  you should not have to do a reboot, I believe simply stopping and starting the SQL service is all that is required. when the service starts, all the @@variables and SET options are loaded fresh.

  I tested this to be sure:

   sp_dropserver DAISY

   sp_addserver WONDERFUL, 'LOCAL'

  [stopped and started the service]

  select @@SERVERNAME returned WONDERFUL

   sp_dropserver WONDERFUL

   sp_addserver DAISY, 'LOCAL'

  [stopped and started the service]

  select @@SERVERNAME returned DAISY

  it's a lot easier to stop and start teh service for a few seconds than a reboot.

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• Eric Peterson

  Hall of Fame

  Points: 3192

  More actions

  December 1, 2006 at 9:54 am

  #675190

  Thanks

  The reboot of the service or the server is what I am trying to avoid.    lol

  Looks like I am going to have a window this weekend as my systems group is applying some new patches, and wants to take all apps down for a few minutes. 

  Thanks again

  Eric

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 1, 2006 at 1:03 pm

  #675258

  Most of the configurations are dynamic in SQL2005 but this server name change is not dynamic...

  May be in next release

   

  MohammedU
  Microsoft SQL Server MVP