After renaming the physical server

After renaming the server, run the following:

--After renaming the physical server , run the following:

----------------------------------------------

master.dbo.master.dbo.sp_dropserver 'oldServerName'

GO

master.dbo.sp_addserver 'newServerName', 'local'

GO

--Restart the SQL instance at this point.

--------------------------------

--After restarting, run the following to confirm that the previous was successful. Is should return the new server name.

-----------------------------------------

SELECT @@SERVERNAME AS 'Server Name'

-----------------------------------------