How to replay a single event at a time (SQL Profiler)

How to replay a single event at a time (SQL Profiler)

To replay a single event at a time

1. On the File menu, point to Open, and then click Trace File or Trace Table.
   
   
2. If you choose to replay an event from a trace table, you must enter the connection information. In the Connect to SQL Server dialog box, select the server to connect to and a connection method, and specify the database in which the table is saved in the Source Table dialog box.
   
   
3. Select the trace file to open, unless you have already selected the trace table.
   
   
4. On the Replay menu, click Step.
   
   
5. In the Connect to SQL Server dialog box, select the server to connect to and a connection method.
   
   
6. In the Replay SQL Server dialog box, alter any necessary settings, and then click Start.
   
   
7. On the Replay menu, click Step.
   
   
8. Repeat Step 6 until you have replayed all the necessary event steps.

See Also

Monitoring with SQL Profiler