Finding active node name from Query analyser

• Kishore-132325

  Hall of Fame

  Points: 3784

  More actions

  July 18, 2006 at 10:36 pm

  #153094

  Hi,

  I have 2 nodes, node1 and node2 on Cluster Mycluster.

  How can I find on which node the cluster is active. I can find from Cluster Admin, but I want to find it from SQL Server. Is there some sp or fn available, which when queried gives the active node name.

  Thanks,

  Kishore

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  July 20, 2006 at 9:03 am

  #650417

  please don't multiple post.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/

• Linda Johanning

  SSCertifiable

  Points: 6727

  More actions

  July 20, 2006 at 10:18 am

  #650448

  All I do is run sp_who2 and search for one of the two node names.