You are here

SQL Server - Cluster Queries

Clustered State

SELECT SERVERPROPERTY('IsClustered') [is_clustered?]

Active Node

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') [active_node_name]

Get Passive Node

	SELECT NodeName  AS 'Passive_Node'
	FROM sys.dm_os_cluster_nodes
	WHERE NodeName NOT IN (
		SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')
	)
Categories: 
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
15 + 4 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer