all groups > sql server clustering > december 2006 >
You're in the

sql server clustering

group:

Getting Cluster Metadata


Re: Getting Cluster Metadata Edwin vMierlo
12/22/2006 12:00:00 AM
sql server clustering: Vijay,

a good start is to look at the Cluster API
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/mscs/mscs/server_cluster_api_reference.asp

rgds,
Edwin.


[quoted text, click to view]

Getting Cluster Metadata Vijay Ram S
12/22/2006 12:44:01 AM
Hi

Is there any TSQL query/function/procedure that would return the metadata
about the SQLServer cluster?? I need to write a program to get the
information about the SQLServer application cluster. I need to get
information like participating nodes in the application cluster.

Any information regarding this will be useful. Usage of other programming
languages is also fine. Is this possible through programming??!!!

thanks
Vijay
RE: Getting Cluster Metadata Linchi Shea
12/26/2006 11:40:00 AM
As part of the API that Edwin mentioned, Microsoft exposes a Cluster
Automation Server interface that simplifies cluster scripting. In addition,
SQL Server has such system functions as fn_servershareddrives and
fn_virtualservernodes. The latter gives you the participating nodes.

Linchi

[quoted text, click to view]
AddThis Social Bookmark Button