@jim

I haven't looked at this in quite a while. I believe the issue you are encountering is resolved with a little extra code as Adam mentioned earlier in the thread. He has a proc that handles this quite nicely that most people use. It is called sp_whoisactive.

I might tune this code up a little bit to handle that, feel free to tune it for your implementation.

Tune into my blog to check for updates on this.