How To: Change Instance Name Of SQL Server – Nick Berardi's Coder Journal

• How To: Change Instance Name Of SQL Server – Nick Berardi's Coder Journal – sp_dropserver 'old_name'<br />
  go<br />
  sp_addserver 'new_name','local'<br />
  go

Tagged as: rename, servername, sp_dropserver, sqlserver