Microsoft SQL Server forum - Verifying Connection to 3rd Party Application

Author

Verifying Connection to 3rd Party Application

Stephanie

2005-07-21, 8:24 pm

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

2005-07-21, 8:24 pm

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/techin.../2000/books.asp

Sponsored Links