Finding Active Node in SQL Server Cluster Writer #1, 2016-03-19 The T-SQL method to find the active node that a SQL service is running on: SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') as ActiveNode SQL Server failover clusteringsql server