3

What is the T-SQL query to obtain the name and state (Primary or Secondary) of a Windows Server Failover Cluster node?

edit

• t-sql
• sql

asked 2022-04-26 11:00:00 +0000

ladyg
21 ●1 ●2

edit retag flag offensive close merge delete

add a comment

0

answered 2022-06-20 10:00:00 +0000

nofretete
31 ●3 ●5

SELECT nodeName, statedesc FROM sys.dmhadrclustermembers;

edit flag offensive delete link more

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss