Computer Name from SQL Server

• Federico Zajur

  SSC Journeyman

  Points: 84

  More actions

  February 28, 2008 at 5:12 am

  #187158

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

• Pedro R. Lopez

  SSC Eights!

  Points: 902

  More actions

  March 5, 2008 at 6:47 am

  #785446

  nice trick.

  Pedro R. Lopez
  http://madurosfritos.blogspot.com/[/url]

• ViYes

  SSC Veteran

  Points: 232

  More actions

  March 5, 2008 at 2:29 pm

  #785771

  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..."

• MO_SQLGuy

  SSC Veteran

  Points: 223

  More actions

  July 18, 2012 at 9:32 am

  #1514296

  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!

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 10, 2016 at 9:21 am

  #1877846

  Thanks for the script.