I was curious if there is a way to programmatically detect if a user stops
a database transaction mid-process. I am looking to disconnect any connections
where a process has been orphaned by a user. It seems that if the user has
the opportunity to stop a process before it is complete (or before code can
close the connection) it will leave an open connection on the database until
the spid is manually killed.