I could not reliably determine the server's network name using @@servername. I executed a SELECT @@servername and the values returned were different to the SERVERPROPRTY(ServerName). I was under the impression these values are the same , could explain to me the basic difference? Answer: As a first step , this is the text straight from the MSDN site - Although the @@SERVERNAME function and the SERVERNAME property of SERVERPROPERTY function may return strings with similar formats, the information can be different. The SERVERNAME property automatically reports changes in the network name of the computer. @@SERVERNAME returns the value from sys.sysservers.... Read more →