Returns the list of nodes on which the virtual server can run. Such information is useful in failover clustering environments.
If the current server instance is not a clustered server, fn_virtualservernodes returns an empty rowset.
If the current server is a clustered server, fn_virtualservernodes returns the list of nodes on which this virtual server has been defined.
Here is a query on a clustered server instance.
SELECT * FROM ::fn_virtualservernodes()
Here is the result set:
NodeName -------- ntmachine1 ntmachine2