Server Name Change

• kcdunn

  Old Hand

  Points: 331

  More actions

  January 16, 2003 at 10:14 am

  #58227

  Server Name was change and we need to change the SQL Server installation to reflect the new name. How can we accomplish this?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736544

  More actions

  January 16, 2003 at 10:33 am

  #446534

  sp_dropserver (old name)

  go

  sp_addserver (new name), local

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  http://www.dkranch.net

• kcdunn

  Old Hand

  Points: 331

  More actions

  January 16, 2003 at 10:46 am

  #446542

  Thank you that worked.