Rename SQL Server Instance

• For a renamed computer that hosts a default instance of SQL Server, run the following procedures:

  
  

  sp_dropserver  GO sp_addserver , local GO 

  Restart the instance of SQL Server.

• For a renamed computer that hosts a named instance of SQL Server, run the following procedures:

  
  

  sp_dropserver  GO sp_addserver , local GO 

  Restart the instance of SQL Server.

  Then:

  SELECT @@SERVERNAME AS 'Server Name'

  From:

  http://msdn.microsoft.com/en-us/library/ms143799.aspx