Steps required after renaming a server?

• smv929

  SSCrazy

  Points: 2889

  More actions

  April 9, 2004 at 10:05 am

  #84869

  I thought I saw a thread related to this topic a few weeks ago but can't find it. What are the steps you have to take in SQLServer 2000 before/after you rename a server?

  
  smv929

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736642

  More actions

  April 9, 2004 at 10:17 am

  #502320

  rename in windows

  sp_dropserver <old servername)

  sp_addserver <new windows name>, local