declare @rc int declare @traceid int declare @maxfilesize bigint set @maxfilesize = 50 exec @rc=sp_trace_create @traceid=@traceid output, @options=0, @tracefile=N'C:\temp\trace_file', @maxfilesize=@maxfilesize, @stoptime=NULL if @rc > 0 print 'sp_trace_code failed with error code ' + rtrim(cast(@rc as char)) else print 'traceid for the trace is ' + rtrim(cast(@traceid as char)) declare @on bit set @on = 1 -- Trace DatabaseID for SQL:BatchCompleted events exec sp_trace_setevent @TraceID,@eventid=12,@columnid=1,@on=@on -- Trace DatabaseID for SQL:BatchCompleted events exec sp_trace_setevent @TraceID,@eventid=12,@columnid=3,@on=@on -- Trace ApplicationName for SQL:BatchCompleted events exec sp_trace_setevent @TraceID,@eventid=12,@columnid=10,@on=@on -- Trace LoginName for SQL:BatchCompleted events exec sp_trace_setevent @TraceID,@eventid=12,@columnid=11,@on=@on -- Trace StartTime for SQL:BatchCompleted events exec sp_trace_setevent @TraceID,@eventid=12,@columnid=14,@on=@on -- Trace Reads for SQL:BatchCompleted events exec sp_trace_setevent @TraceID,@eventid=12,@columnid=16,@on=@on -- Trace Writes for SQL:BatchCompleted events exec sp_trace_setevent @TraceID,@eventid=12,@columnid=17,@on=@on -- Trace CPU for SQL:BatchCompleted events exec sp_trace_setevent @TraceID,@eventid=12,@columnid=18,@on=@on exec sp_trace_setstatus @TraceID, 1