Login or Sign Up to become a member!

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

From Wiki

So you would like to find out which node of your active-passive cluster is active, how can you do that? You can use the SERVERPROPERTY function, you would use it with 'ComputerNamePhysicalNetBIOS' as property name.
This will return the NetBIOS name of the local computer on which the instance of SQL Server is currently running. For a clustered instance of SQL Server on a failover cluster, this value changes as the instance of SQL Server fails over to other nodes in the failover cluster. On a stand-alone instance of SQL Server, this value remains constant and returns the same value as the MachineName property.

If the instance of SQL Server is in a failover cluster and you want to obtain the name of the failover clustered instance, use the MachineName property.

Here is what the code looks like:

Contributed by: --SQLDenis 17:57, 22 April 2009 (GMT)

Part of SQL Server Admin Hacks