Subject: Server Rename SQL Instance Rename
–For Default Instance
sp_dropserver <old_name>;
GO
sp_addserver <new_name>, 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 <old_name\instancename>;
GO
sp_addserver <new_name\instancename>, local;
GO
–Restart the instance of SQL Server