eitanblumin.com
How to Update @@SERVERNAME to Actual Machine Name?
If, for whatever reason, the Windows Computer Name is changed after SQL Server is already installed, then @@SERVERNAME and the information in sys.servers would not automatically reflect the change …