Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Computer Name from SQL Server Expand / Collapse
Author
Message
Posted Thursday, February 28, 2008 5:12 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, April 24, 2014 5:29 AM
Points: 64, Visits: 20
Comments posted to this topic are about the item Computer Name from SQL Server
Post #461562
Posted Wednesday, March 5, 2008 6:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 4, 2009 1:49 PM
Points: 160, Visits: 140
nice trick.

Pedro R. Lopez
http://madurosfritos.blogspot.com/
Post #464386
Posted Wednesday, March 5, 2008 2:29 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 9:41 AM
Points: 202, Visits: 125
Guys..

Instead this will work to get the active node name on the cluster as well..!

select CONVERT(VARCHAR(10), SERVERPROPERTY('ComputerNamePhysicalNetBIOS'))

-VS
"there are 10 types of people in the world...those who understand binary and those who don't..."
Post #464760
Posted Wednesday, July 18, 2012 9:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 10:13 AM
Points: 12, Visits: 91
Based on my testing, the xp_regread method will return the physical machine name while xp_getnetname returns the cluster name, not the physical machine name. Something to consider when determining what method to use!
Post #1331565
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse