How to known that Sqlconnection is working

Hello all,
Actually i want to known, is their any method or property in SqlConnection class which will return some value, so that through which we become confirm that connection has established.

Thanks in advance!Look at the State property of the connection object|||very thanks to you , i think this is what i am looking for.

how to know if trigger is disabled?

Is there a functoin or property that you can look at to tell if a trigger
has been disabled? Something in the schema?
Like:
Print IsTriggerDisabled(tblCustomers.MyTrigger)
KeithHi
For more information please read this article and that will answer your
question:
http://sqljunkies.com/Article/F5783...39BCC3096B.scuk
thanks and regards
Chandra
"Keith G Hicks" wrote:

> Is there a functoin or property that you can look at to tell if a trigger
> has been disabled? Something in the schema?
> Like:
> Print IsTriggerDisabled(tblCustomers.MyTrigger)
> Keith
>
>|||Cool. Thank you. :)
- keith

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..

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..