InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 12:30:27 GMT20http://www.sqlservercentral.com/Forums/Topic791684-24-1.aspxYes, I created the trace with SQL Profiler and then exported the trace definition .now i wanted to sehedule the trace by SQL server Agent Job.I am able to run the same trace in SQL server Profiler with all the filters applied. it is giving errors when i try to run with Stored Procedures.Wed, 23 Sep 2009 00:07:31 GMTvijayabaskar_shttp://www.sqlservercentral.com/Forums/Topic791684-24-1.aspxDid you set up the trace in Profiler and then export the definition or are you trying to create the trace by hand?Tue, 22 Sep 2009 12:16:31 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic791684-24-1.aspxthe error is pasted here when run the SP sg 19055, Level 16, State 1, Procedure sp_trace_setfilter, Line 1Filters with the same event column ID must be grouped together.Please find code part of my Stored_procedure which is giving error.declare @intfilter int declare @bigintfilter bigint set @intfilter = 13 exec sp_trace_setfilter @TraceID, 3, 1, 0, @intfilter exec sp_trace_setfilter @TraceID, 10, 1, 6, N'%SQL Server Management Studio%' exec sp_trace_setfilter @TraceID, 10, 0, 7, N'%.Net SqlClient Data Provider%' exec sp_trace_setfilter @TraceID, 35, 1, 6, N'%MyworksDatabase%' exec sp_trace_setfilter @TraceID, 35, 0, 7, N'%TempDB%' exec sp_trace_setfilter @TraceID, 35, 0, 7, N'%Master%' Now how do i group these events?Tue, 22 Sep 2009 06:01:40 GMTvijayabaskar_s