Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In SQL Server 2005 and later versions, you can find the active node of SQL Server Failover Cluster using the following query.
1 | SELECT SERVERPROPERTY('ComputerNamePhysicalNetBios') |
About Ekrem Önsoy
In SQL Server 2005 and later versions, you can find the active node of SQL Server Failover Cluster using the following query.
1 | SELECT SERVERPROPERTY('ComputerNamePhysicalNetBios') |