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:
Copy
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:
Copy
sp_dropserver ;
GO
sp_addserver , local;
GO
Restart the instance of SQL Server.
+
...