All content (copyright) respective authorsvmonpara's code bookmark tagged with clusterhttp://www.codaddict.com/vmonpara/clustervmonpara's code bookmark tagged with clusterGet all nodes from SQL Server clusterSELECT * FROM sys.dm_os_cluster_nodeshttp://www.codaddict.com/vmonpara/SQL ServervmonparaWed, 19 Dec 2007 10:17:09 GMTGet active node from SQL Server clusterSELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') ActiveNodehttp://www.codaddict.com/vmonpara/SQL ServervmonparaWed, 19 Dec 2007 10:13:48 GMT