dbcc inputbuffer value

Hi,
I want to store DBCC inputbuffer value in a variable and then want to
comapare the value.
How ca i store the value in a variable or table inside a script?You can try this...
create table #temp (eventType varchar(100),parameters int, EventInfo
nvarchar(200))
insert into #temp exec('dbcc inputbuffer (' + @.@.spid + ')')
select * from #temp
drop table #temp
Hope this helps.
--
-Omnibuzz (The SQL GC)
http://omnibuzz-sql.blogspot.com/