DBCC INPUTBUFFER output to text file

[indoaryaan]

Hello,
I want to write the DBCC INPUTBUFFER output to a text file. I have created a temp table and the DBCC output is loaded into the temp table. The aim is to write the output to a text file to know the EventInfo of SPID. Any help would be appreciated. Thanks.........

 

[donutman]

Is this being done entirely as an SQL job? Don't you have a front-end app?
-Karl

 

[indoaryaan]

this is done as an in T-SQL code. No front end App is present. This code will be a part of a trigger.