What is the Active Node of SQL Server Failover Cluster?

Ekrem Önsoy

5 years ago

In SQL Server 2005 and later versions, you can find the active node of SQL Server Failover Cluster using the following query.

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBios')

1	SELECT SERVERPROPERTY('ComputerNamePhysicalNetBios')