Finding Active Node in SQL Server Cluster

Writer #1,

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

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') as ActiveNode
SQL Server

Leave a Reply

Your email address will not be published. Required fields are marked *