@@SERVERNAME Returns Old Name or NULL
By Ginger Daniel | Intermediate , Miscellaneous , SQL Administration , SQL Server
— by Ginger Keys Recently a client of mine moved their production SQL Server Cluster to a new physical environment. When the time came to ‘go-live’ with the new environment, the client wanted the new SQL cluster name and IP address (SQLCLUSTERTEMP) to be renamed to the original, legacy name and IP address (SQLCLUSTER). […]
Continue reading