Post reply

How to determine cluster node

  • September 23, 2004 at 1:27 pm

    #60108

    Given an active-active SQL Server cluster setup, how does one determine the names of the SQL Server cluster nodes?

    I don't want the SQL Server virtual server name returned from "select serverproperty('machinename')", but rather the NetBIOS name of the physical machines hosting the cluster.

    Thanks.

  • September 27, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • September 27, 2004 at 8:32 am

    #524525

    Point to Master in QA and execute this.

    select * from :: fn_virtualservernodes ()

    That gives you the physical names of the cluster nodes.

    -Ken

  • December 21, 2009 at 9:41 am

    #1094886

    SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

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

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