how to know if sqlserver is clustered

hi,

can u tell me how to find out sql server is clustered or not using sql dmo (c++)

Is there any method or property that i can use to find out if sql server is failover cluster

Use the Cluster Server APIs for this:

http://msdn2.microsoft.com/en-us/library/aa373104.aspx

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Check out the IsClustered property under Server.Information - here's a code sample:

Dim srvMgmtServer As Server
srvMgmtServer = New Server("MyServer")
Dim srvConn As ServerConnection
srvConn = srvMgmtServer.ConnectionContext
srvConn.LoginSecure = True

If srvMgmtServer.Information.IsClustered = True Then
' Do something here
End If

Hope that helps.

|||yes we have it in server properties i got the required information..