Home > Archive > MS SQL Server > March 2006 > Physical Server Name









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]

 

Author Physical Server Name
JI

2006-03-30, 1:23 pm

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,


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com