Posted by laurenq uantrell on 10/01/93 11:27

Whew. That's a hefty amount of code, which seems much more complex
than:
"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"

Thanks for that.
Is there a way to force some blocking so that I can test it?

• Next in forum: Re: Connecting Trace info to blocked users?
• Prev in forum: Re: search on concatenated fields in sql server
• Thread view: Re: Connecting Trace info to blocked users?

[Reply to this message]