How to Update SQL Server 2000 Name?

• dan9001

  SSChasing Mays

  Points: 600

  More actions

  October 29, 2004 at 11:10 am

  #85704

  select @@servername returns "Server1". 

  But, the actual name of the server has been changed to "Server2".  How do I change the SQL2K database to "Server2" so that

  select @@servername returns "Server2"?

   

   

• Wesley Brown

  SSChampion

  Points: 12045

  More actions

  October 29, 2004 at 12:17 pm

  #528428

  sp_addserver 'newservername', 'local'

  Look it up in BOL

  Wes

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738907

  More actions

  October 29, 2004 at 1:51 pm

  #528441

  don't forget to drop the old server with sp_dropserver