Please could somebody suggest a way of identifying the live connections to a SQL database from within a stored procedure. I am logging user activity into a table but, if a connection is lost as a result of system error or hardware failure, I have no way of logging this. I awnt to be able to ask programmatically, 'Is this connection still live?'.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Enumerating Connections
- Thread starter StewartJ
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question