[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 Microsoft SQL Server Cluster
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

How many nodes exist in a SQL Server cluster

 

Applies to:  SQL Server 2005.

 

The following script uses fn_virtualservernodes to query on a clustered server instance and determine how many nodes exist in the SQL Server cluster

SELECT * FROM ::FN_VIRTUALSERVERNODES()





 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.