|
Home > Archive > MS SQL Server > March 2006 > Found It
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| 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,
>
| |
| Mike Hodgson 2006-03-30, 8:23 pm |
| 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...
>
>
>
>
>
>
|
|
|
|
|