Reply to Re: Connecting Trace info to blocked users?
Posted by SQL on 10/01/46 11:27
Insert the result of sp_who2 into a table
Delete everything where BlkBy is empty
Loop thru this table and insert the DBCC inputbuffer result into
another table
Join this last table with sysprocesses