SELECT IdentifyUser(blk1userid) as "blocking user", IdentifyTable(blk1objtid) as "blocking table", IdentifyDatabase(blk1objdbid) as "blocking db" FROM TABLE (MonitorSession(-1,'*',0)) AS t1 WHERE Blk1UserId > 0; *** Query completed. One row found. 3 columns returned. *** Total elapsed time was 4 seconds. blocking user blocking table blocking db --------------------------- ----------------------- ------------- user1 skewAmp1 DBaaa