SQL Server Clustering
Find active node with T-SQL |
|
Don't want to use the Cluster manager to find the active node then use the commands below to find the active node. Both return the same info.
SELECT ServerProperty('ComputerNamePhysicalNetBIOS')
GO
SELECT * FROM sys.dm_os_cluster_nodes
WHERE is_current_owner = 1
SELECT ServerProperty('ComputerNamePhysicalNetBIOS')
GO
SELECT * FROM sys.dm_os_cluster_nodes
WHERE is_current_owner = 1