Rename SQL Server hostname

To rename a computer that hosts a stand-alone instance of SQL Server

• 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.
+

Açar sözlər: