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.

[ database_name . [ schema_name ] . | schema_name . ] table_name
SQL question
Function results
Passing a parameter as list in a Stored procedure
select based on containing only certain characters