HelloAll, I am trying to create a trace for user error messages using audit user error messages event class.I could create .trc file. But , unfortunately I am unable to get sql query which caused the error. This is how I created the trace file 1) DECLARE @TraceIdOut int Exec sp_trace_create @traceid= @TraceIdOut OUTPUT ,@options = 2 ,@tracefile =N'carseerrors' PRINT @TraceIdOut 2) Set the trace event to monitor Parse error messages Exec sp_trace_setevent @traceid = 2,@eventid = 162,@columnid =1, @on = @On 3) Set the trace event status to start. EXEC sp_trace_setstatus @traceid = 2, @status = 1 I am getting only one column ..that is column which shows the user error.. for example "incorrect syntax near 'abcd' ". I also want the sql query which caused the error. I could give only one columnid number while setting the trace event. Please help me in getting the sql query which caused this error.