Verifying Connection to 3rd Party Application

[Stephanie]

Is there a way that SQL can automatically look at each users'
connection and make sure it is still connected through the third party
application? The problem is that when a connection to this application
is not terminated properly, the SQL server is not notified of the
disconnect and the user cannot log back into the application until all
the processes are completed and the original session terminated.

Thank you.

[Erland Sommarskog]

Stephanie (st*****@centene.com) writes:

Is there a way that SQL can automatically look at each users'
connection and make sure it is still connected through the third party
application? The problem is that when a connection to this application
is not terminated properly, the SQL server is not notified of the
disconnect and the user cannot log back into the application until all
the processes are completed and the original session terminated.

No, there is no way you tell from SQL Server what is going on on
the other end.

Note that if the application closes down completely, all connections
should be closed. But if the application is poorly implemented, it
may leak connections.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp