Posted by tomas.zalesak on 05/10/07 12:52

> 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'

CREATE TABLE #Inputbuffer(
EventType NVARCHAR(30) NULL,
Parameters INT NULL,
EventInfo NVARCHAR(255) NULL
)
GO

INSERT #Inputbuffer
EXEC('DBCC INPUTBUFFER(<YourSpid>)')
GO

SELECT * FROM #Inputbuffer

--
Tom
http://kbupdate.info/ | http://suppline.com/

• Next in forum: Re: Last Day Of Previous Month...with a twist
• Prev in forum: Re: Loading data from xml http stream
• Thread view: Re: DBCC INPUTBUFFER results into table

[Reply to this message]