@@Servername and Serverproperty('servername') do not match

• Aneyshia

  SSC Veteran

  Points: 270

  More actions

  January 25, 2012 at 8:00 am

  #146511

  I used the script listed below to rename a 2005 SQL Server. However serverproperty('servername') still reports the old name. Has anyone else encountered this problem? If so what did you do to fix it. I have searched all of the forums I know to search and cannot find a solution. Thanks in advance for your feedback.

  sp_dropserver 'currentname'

  GO

  sp_addserver 'NewServerName', Local

  GO

• Robert Murphy UK1

  Default port

  Points: 1485

  More actions

  January 25, 2012 at 8:16 am

  #1438252

  Did you restart the instance?

  Robert Murphy, Microsoft MCITP (Database Administrator 2008) and MCAD Certified

• Aneyshia

  SSC Veteran

  Points: 270

  More actions

  January 25, 2012 at 8:17 am

  #1438257

  Sure did. 🙂

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736430

  More actions

  January 25, 2012 at 8:27 am

  #1438267

  This help? http://www.sqlservercentral.com/Forums/Topic556439-146-1.aspx