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