Finding Cluster Nodes or Cluster Name | SansSQL

Sunday, May 24, 2009

Finding Cluster Nodes or Cluster Name

Here is a Query to find the Cluster Nodes or Cluster Name using SQL server 2005.

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

This helps in  finding which node the instance is currently running.

No comments:

Post a Comment

Ads