Computer Name from SQL Server

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

  • nice trick.

    Pedro R. Lopez[/url]

  • Guys..

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

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


    "there are 10 types of people in the world...those who understand binary and those who don't..."

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

  • 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