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