SQL Server · 2016-03-19

Finding Active Node in SQL Server Cluster

The T-SQL method to find the active node that a SQL service is running on:

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') as ActiveNode