Posted by Erland Sommarskog on 07/22/05 01:58

Stephanie (stuttle@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, esquel@sommarskog.se

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

[Back to original message]