SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Federico Zajur / Computer Name from SQL Server / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 14:56:07 GMT20RE: Computer Name from SQL Serverhttp://www.sqlservercentral.com/Forums/Topic461562-1212-1.aspxBased 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!Wed, 18 Jul 2012 09:32:49 GMTMO_SQLGuyRE: Computer Name from SQL Serverhttp://www.sqlservercentral.com/Forums/Topic461562-1212-1.aspxGuys..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..."Wed, 05 Mar 2008 14:29:16 GMTViYesRE: Computer Name from SQL Serverhttp://www.sqlservercentral.com/Forums/Topic461562-1212-1.aspxnice trick.Wed, 05 Mar 2008 06:47:01 GMTPedro R. LopezComputer Name from SQL Serverhttp://www.sqlservercentral.com/Forums/Topic461562-1212-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Computer+Name/62077/">Computer Name from SQL Server</A>[/B]Thu, 28 Feb 2008 05:12:41 GMTFederico Zajur