Post reply

get the node name, not the virtual node name

  • February 24, 2012 at 4:44 am

    #265221

    Hi All

    Is there anyway to get the actual host name in T-SQL (or another way) on a cluster?

    SERVERPROPERTY('MachineName') or ('ServerName') get the virtual instance name not the node name.

    I got nodes N1,N2,N3,N4 and instances SQL1,SQL2 I want to run a query which tells me that SQL2 is running on N2 or SQL1 is running on N4 for example.

    Thanks

    Ant

  • February 24, 2012 at 4:46 am

    #1451312

    Answered my own question I missed this one

    SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

Viewing 2 posts - 1 through 1 (of 1 total)

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