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.
|This Microsoft SQL Server 2000 system function is included for backward compatibility. We recommend that you use sys.dm_os_cluster_nodes instead.|
The following example uses fn_virtualservernodes to query on a clustered server instance:
SELECT * FROM fn_virtualservernodes()
This is the result set: