Is this on a cluster? When you say "server property" what are you selecting exactly?
@@servername will give the local machine name, except in a failover cluster, where it will give you the virtual server name
serverproperty('computernamephysicalnetbios') should give you the local machine name. In a failover cluster this is the machine name of the active node
Joie Andrew
"Since 1982"