September 7, 2005 at 3:32 pm
Is it possible to create a trace in Profiler using the GUI and then script the trace or do I have to create the sp_trace_create commands manually? I'm looking for the best way to create a scheduled Profiler trace.
Thanks, Dave
September 8, 2005 at 3:21 am
When I want to schedule tracing I use profiler GUI to choose events, filters... and then script the trace, run the script to create server-side trace and setup SQL Server Agent Jobs with sp_trace_setstatus procedure to Start/Stop the trace.
September 8, 2005 at 10:40 am
How do you script the trace? I think I am doing something wrong. I build the trace, start it and then select File - Script Trace - SQL Server 2000. However this generates a script where sp_trace_setevent is listed for every event and all events are ON, which is not how my trace was configured. I expected to only see the events I selected.
Dave
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply