Can anyone please tell me whether there are any ways we can check whether a connection that was opened to a SQL Server database is closed. Is there a tool we can use?.
Thx
HaklHi,
You can use the SqlConnection.State property to get the information
of the current ConnectionState.
Regards,|||Otherwise, if you want a "tool" (as in: control fro mthe outside), have alook at the tools that come with SQL Server.
There is a tracer that can give you a dump of everything happening - so you can see what commands SQL Server retrieves, and whether connections are closed.
No comments:
Post a Comment