How to determine cluster node

• Bruce Pettus

  Old Hand

  Points: 374

  More actions

  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

• Ken Davis

  SSCarpal Tunnel

  Points: 4329

  More actions

  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

• Steve-3_5_7_9

  SSChampion

  Points: 10832

  More actions

  December 21, 2009 at 9:41 am

  #1094886

  SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')