For some reasons, we moved one default SQL instance from one server box to another server box.
As a result, the srvname in the master..sysservers keeps unchanged.
When running SELECT @@SERVERNAME, we got the name of the old server, rather than the new one.
How to change it?
Any input will be greatly appreciated.