Search This Blog

Wednesday, April 21, 2010

SQL Queries to get Physical Node Names and Shared Drive from Cluster

Query to get the physical nodes of SQL cluster
SELECT * FROM Fn_VirtualServerNodes()

Query to get the shared drives for a clustered instance
SELECT * FROM fn_servershareddrives()

No comments: