Found It

You have to search the registry:

exec master..xp_regread  'HKEY_LOCAL_Machine'
,
 'SYSTEM\CurrentContr
 olSet\Control\Comput
 erName\ComputerName\
',
'ComputerName'

"JI" <jidawgs@gmail.com> wrote in message
news:OU$OnXCVGHA.196@TK2MSFTNGP10.phx.gbl...
>I have SQL Server installed on a cluster. When I select @@servername it
> gives me the virtual server name, as does  serverProperty('Mach
ineName') or
>  serverProperty('serv
erName'). When I select
>  serverProperty('Comp
 uterNamePhysicalNetB
ios') it returns null. How can I
> get
> the physical name? Actually it is a sql 2k box so that is why the
>  computerNamePhysical
NetBios returns null.
>
> thanks,
>

Answered in your m.p.s.programming thread.

--
*mike hodgson*
http://sqlnerd.blogspot.com



JI wrote:

>You have to search the registry:
>
>exec master..xp_regread  'HKEY_LOCAL_Machine'
,
> 'SYSTEM\CurrentContr
 olSet\Control\Comput
 erName\ComputerName\
',
>'ComputerName'
>
>"JI" <jidawgs@gmail.com> wrote in message
>news:OU$OnXCVGHA.196@TK2MSFTNGP10.phx.gbl...
>
> 
>
>
>
>