The T-SQL method to find the active node that a SQL service is running on:
SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') as ActiveNode
The T-SQL method to find the active node that a SQL service is running on:
SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') as ActiveNode