Renaming an SQL Server
Have you ever renamed an SQL server via the built in Windows GUI and then afterwards found that the SQL server hostname hasn’t changed when running “select @@servername“
Search no more, there is an easy fix to this problem!
sp_dropserver ;
GO
sp_addserver , local;
GO
Then reboot the SQL Server service