1 of 2
Gabe
  • 151
  • 4

If you tell Profiler not to filter out its own queries, you'd probably see it calling these stored procedures:

As described by the documentation, you execute the procedures in this order:

  1. Create a trace by using sp_trace_create.
  2. Add events with sp_trace_setevent.
  3. (Optional) Set a filter with sp_trace_setfilter.
  4. Start the trace with sp_trace_setstatus.
  5. Stop the trace with sp_trace_setstatus.
  6. Close the trace with sp_trace_setstatus.

You will end up with a .trc file that you can then open in SQL Profiler.

Gabe
  • 151
  • 4