Re: Physical Server Name - Found it

#1

xp_regread is undocumented and also the permissions related to this xp
have been changed considerably in SQL 2005. A better way, if you're
going to shell out to the OS anyway, would be to ask cluster.exe (the
cmdline cluster administrator tool) like this:

exec master.dbo.xp_cmdshell 'cluster group VSQL01'

where VSQL01 is the name of your cluster group (typically your virtual
server name).

The regulars in microsoft.public.sqlserver.clustering might have a
better idea (cross-posted).

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

JI wrote:

Quote:

Had to read the registy:
exec master..xp_regread 'HKEY_LOCAL_Machine',
'SYSTEM\CurrentControlSet\Control\ComputerName\Com puterName\',
'ComputerName'

"JI" <jidawgs (AT) gmail (DOT) com> wrote in message
news:eqQO8KBVGHA.5588 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

I have SQL Server installed on a cluster. When I select @@servername it
gives me the virtual server name, as does serverProperty('MachineName') or
serverProperty('serverName'). When I select
serverProperty('ComputerNamePhysicalNetBios') it returns null. How can I
get the physical name?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Physical Server Name - Found it

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Re: Physical Server Name - Found it - 03-30-2006 , 04:54 PM