Post reply

Computer Name from SQL Server

  • February 28, 2008 at 5:12 am

    #187158

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

  • March 5, 2008 at 6:47 am

    #785446

    nice trick.

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

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

  • 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!

  • May 10, 2016 at 9:21 am

    #1877846

    Thanks for the script.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply