While you are at it, you may also be interested in beta_lockinfo. Or may be you are not. But since I wrote it, I had to plug it. :--) The one thing I don't like with sp_whoisactive is that it has too many parameters. Hey, beta_lockinfo only has four parameters or whatever it is - and I find that I don't even know them myself.

http://www.sommarskog.se/sqlutil/beta_lockinfo.html[/url]