The T-SQL method to find the active node that a SQL service is running on:
SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') as ActiveNode
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