Computer Name from SQL Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Federico Zajur » Computer Name from SQL Server

Computer Name from SQL Server

Rate Topic

Display Mode

Topic Options

Author

Message

Federico Zajur

Posted Thursday, February 28, 2008 5:12 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, February 28, 2008 5:12 AM
Points: 64, Visits: 19

Comments posted to this topic are about the item Computer Name from SQL Server

Post #461562

Pedro R. Lopez

Posted Wednesday, March 05, 2008 6:47 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 04, 2009 1:49 PM
Points: 160, Visits: 140

nice trick.

Pedro R. Lopez
http://madurosfritos.blogspot.com/

Post #464386

ViYes

Posted Wednesday, March 05, 2008 2:29 PM

SSC Veteran

Group: General Forum Members
Last Login: Monday, May 20, 2013 2:39 PM
Points: 202, Visits: 111

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

MO_SQLGuy

Posted Wednesday, July 18, 2012 9:32 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:56 PM
Points: 11, Visits: 48

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 »

Permissions