dma-669038 (6/14/2010)
Very nice article Jason. I must try the code, it looks neat. I would also recommend to anyone Adam Machanic's sp_whoisactive, we use that extensively. Thanks.
For reference, the URL for that is: http://tinyurl.com/WhoIsActive
Seems the author of this article uses it too, since he has copied my XML technique (with no attribution, and not as well as I've done, I won't hesitate to add :-P)
--
Adam Machanic
whoisactive