You are here

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
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
5 + 1 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer