In my opinion
SELECT SERVERPROPERTY('ServerName')
and
select @@servername
must works equally.
>I found this... and it works.
>select SERVERPROPERTY('ServerName')
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst