Why does SQL Server @@SERVERNAME return my old machine name?
This is well known and documented, see Rename a Computer that Hosts a Stand-Alone Instance of SQL Server: When you change the name of the computer that is running SQL Server, the new name is recognized during SQL Server startup. You do not have to run Setup again to reset the computer name. Instead, use … Read more