Finding active node name from Query analyser

• Kishore-132325

  Hall of Fame

  Points: 3784

  More actions

  July 18, 2006 at 10:36 pm

  #113695

  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 19, 2006 at 2:16 am

  #650024

  I think you'd have to read from the registry, I'm not aware of any sql functions which return the underlying node name for a cluster.

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

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  July 19, 2006 at 2:26 am

  #650028

  This simplest way I can think of doing it is something like this:

  EXEC xp_cmdshell 'cluster resource "SQL Server (Instance_Name)"'

  John

• Kishore-132325

  Hall of Fame

  Points: 3784

  More actions

  July 19, 2006 at 3:30 am

  #650038

  Thanks Guys.

   

• barsuk

  SSChampion

  Points: 12280

  More actions

  July 20, 2006 at 1:43 pm

  #650510

  check if it helps: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=271442

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  July 21, 2006 at 5:11 am

  #650631

  select

  serverproperty('ComputerNamePhysicalNetBIOS')

  will give you the name of the current node, for a non clustered server it returns the machine name. This is for SQL 2005 ONLY.

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