Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
SQL Server 2
Downgrading 1
DMV 1
CLUSTER 1
Cluster_Nodes 1
.NET 3.5 1
Script 1
Tip 1

Archive · View All
March 2010 2
April 2010 2

BruMedishetty's blog

Finding Node Names in a Failover Cluster

Mar 29 2010 11:27AM by Bru Medishetty   

I was recently asked by a friend, how to find the names of the nodes that are participating in a failover cluster. The Dynamic Management View sys.dm_os_cluster_nodes will give this information. The following script will return the list of Node names in the cluster.

Note that the query was run on a 3 Node cluster, so the result set displays the 3 Nodes in the cluster. If the same command is run on a stand alone machine, it would not return any node name indicating it is not a cluster.

For my additional blogs visit www.LearnSQLwithBru.com

-- Bru Medishetty

Tags: Cluster_Nodes, CLUSTER, DMV,


Bru Medishetty
261 · 1% · 168
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]