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

http://sqlservercode.blogspot.com/

• Next in forum: updating multiple fields
• Prev in forum: Howto Format a string in a sproc ?
• Thread view: Re: Connecting Trace info to blocked users?

[Reply to this message]