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.
Sunday, May 24, 2009
Finding Cluster Nodes or Cluster Name
Labels:
Interview Questions,
MSSQL,
SQL Information,
SQL Queries
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment