mmm sp_whoisactive is quite nice, but my last version of sp_who3 ( the one posted here is one year old) has some more useful options