>That SP doesn't seem to do much good.

Yup. You'll notice that my script indicates the number of open transactions on the connnection too.

It could be that SysProcesses isn't actually showing active connections, but in all my experimentation it does a pretty good job of fooling me into thinking that it does.