Posted by Tom on 05/09/07 23:04

Does anyone know if there is a simple way to get the results of a DBCC
INPUTBUFFER() request into a table? I have a process for monitoring
activity that will give me the results of sp_who2 into a temp table,
and want to scroll through the active connections and get the input
buffers into another table for review:

Insert into #TmpWho
exec sp_who2 'active'

Something like that with the dbcc command.

I am using SQL 2000 SP4.

Thanks,

Tom

• Next in forum: Re: Narrowed Down Search
• Prev in forum: How Import XML file in a table with trigger.
• Thread view: DBCC INPUTBUFFER results into table

[Reply to this message]