How do I get the PHYSICAL name of a server?

Cheers,
Jaybee.

Or (2005 only),
SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

Hi again Satya, thanks, that worked !!!
Jaybee

This is probably an ANSI standard function:
select host_name()
Since you're asking about the physical name, I have to wonder which one you would like to see returned for a SQL Server instance running under VM Ware or the likes?

select hostname() returns the name of the client, not the server.

Thanks Thomas - should have thought of that myself.
In addition to what Satya said - SERVERPROPERTY('MachineName') works in SQL 2000, but not in SQL 7.0.

[quote user="satya"]
I believe serverproperty is introduced iN SQL 2000/
[/quote]
Yeah it was, but it changed quite significantly from 2000 to 2005 (e.g the ComputerNetBiosName value).

Hi,
I used to use the following command which tells in which node the instance is currently running.
Exec master..xp_cmdshell 'net user'
gk