How to detect orphaned connections?
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I know about sp_who and sp-who2 procedures, but how can I detect orphaned connections/processes? You will agree that LastBatch information should be ignored in most cases. I am trying to make a services which logs some statistical data about connecting to sql server and killing orphaned connections would be a nice feature. I use Sql Server 2005 Express.