• as we could see you are creating a trace with filters:

    #exec sp_trace_setfilter @TraceID, 10, 0, 7, N'SQL Profiler'

    #set @bigintfilter = 1000

    #exec sp_trace_setfilter @TraceID, 13, 0, 4, @bigintfilter

    #set @intfilter = 100

    #exec sp_trace_setfilter @TraceID, 22, 0, 4, @intfilter

    which means:

    you want

    >>ApplicationName not like N'SQL Profiler'

    >>Duration greater then or equal to 1000( milliseconds)

    >> ObjectID greater then then or equal to 100

    (http://technet.microsoft.com/en-us/library/ms174404.aspx

    http://www.sqlservercentral.com/Forums/Topic279642-5-1.aspx)

    could be this condition is not matching on your statements....

    HTH.

    Thanx.

    Vinay

    Thanx.
    Vinay

    http://rdbmsexperts.com/Blogs/
    http://vinay-thakur.spaces.live.com/
    http://twitter.com/ThakurVinay