Returns a list of failover clustered instance nodes on which an instance of SQL Server can run. This information is useful in failover clustering environments.
|Applies to: SQL Server (SQL Server 2008 through current version).|
If the current server is a clustered server, fn_virtualservernodes returns a list of failover clustered instance nodes on which this instance of SQL Server has been defined.
If the current server instance is not a clustered server, fn_virtualservernodes returns an empty rowset.
The user must have VIEW SERVER STATE permission for the instance of SQL Server.
The following example uses
fn_virtualservernodes to query on a clustered server instance:
SELECT * FROM fn_virtualservernodes();
Here is the result set.