Obtaining the server name

[StevenK]

If I am working on a SQL server database am I able to obtain the name of the server I am currently on by using the SQL command 'SELECT [srvname] FROM [sysservers] WHERE [srvid] = 0' if I am connected to the 'master' database ?
Would this always give me the server name ?
Thanks in advance.
Steve

 

[cdukes]

Rather than relying on being in master and selecting from system tables etc

you could use

select @@SERVERNAME

Hope this helps,


Chris Dukes

 

[StevenK]

Thanks again Chris - this has allowed me to get the server name as required.
Steve