• I capture the following event and filter in the trace file.

    EXEC sp_trace_setevent @TraceID, 12,1, @on --SQL-BatchCompleted,TextData

    EXEC sp_trace_setevent @TraceID, 12,6, @on --SQL-BatchCompleted,NTUserName

    EXEC sp_trace_setevent @TraceID, 12,8, @on --SQL-BatchCompleted,HostName

    EXEC sp_trace_setevent @TraceID, 12,10, @on --SQL-BatchCompleted,ApplicationName

    EXEC sp_trace_setevent @TraceID, 12,11, @on --SQL-BatchCompleted,LoginName

    EXEC sp_trace_setevent @TraceID, 12,12, @on --SQL-BatchCompleted,SPID

    EXEC sp_trace_setevent @TraceID, 12,14, @on --SQL-BatchCompleted,StartTime

    EXEC sp_trace_setevent @TraceID, 12,15, @on --SQL-BatchCompleted,EndTime

    EXEC sp_trace_setevent @TraceID, 12,35, @on --SQL-BatchCompleted,DatabaseName

    EXEC sp_trace_setevent @TraceID, 13,1, @on --SQL-BatchString,TextData

    EXEC sp_trace_setevent @TraceID, 13,6, @on --SQL-BatchString,NTUserName

    EXEC sp_trace_setevent @TraceID, 13,8, @on --SQL-BatchString,HostName

    EXEC sp_trace_setevent @TraceID, 13,10, @on --SQL-BatchString,ApplicationName

    EXEC sp_trace_setevent @TraceID, 13,11, @on --SQL-BatchString,LoginName

    EXEC sp_trace_setevent @TraceID, 13,12, @on --SQL-BatchString,SPID

    EXEC sp_trace_setevent @TraceID, 13,14, @on --SQL-BatchString,StartTime

    EXEC sp_trace_setevent @TraceID, 13,15, @on --SQL-BatchString,EndTime

    EXEC sp_trace_setevent @TraceID, 13,35, @on --SQL-BatchString,DatabaseName

    EXEC sp_trace_setfilter @TraceID, 35, 0, 0, N'dbname'