Returns the list of nodes on which the virtual server can run. Such information is useful in failover clustering environments.

Syntax

fn_virtualservernodes()

Tables Returned

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.

Examples

Here is a query on a clustered server instance.

SELECT *
FROM ::fn_virtualservernodes()

Here is the result set:

NodeName
--------
ntmachine1
ntmachine2

See Also