• Awesome... thx for your help.

    Indeed i just wanted to get an output and make sure that the SETEVENTS that were set when the trace was created are in fact being filtered.

    I.e

    DECLARE @on BIT

    SELECT @on = 1

    exec sp_trace_setevent 2, 14, 6, @on

    exec sp_trace_setevent 2, 14, 7, @on

    exec sp_trace_setevent 2, 14, 8, @on

    exec sp_trace_setevent 2, 14, 9, @on

    exec sp_trace_setevent 2, 14, 10, @on

    exec sp_trace_setevent 2, 15, 6, @on

    exec sp_trace_setevent 2, 15, 7, @on