How to replay a single event at a time (SQL Profiler)
To replay a single event at a time
- On the File menu, point to Open, and then click Trace File or Trace Table.
- 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.
- Select the trace file to open, unless you have already selected the trace table.
- On the Replay menu, click Step.
- In the Connect to SQL Server dialog box, select the server to connect to and a connection method.
- In the Replay SQL Server dialog box, alter any necessary settings, and then click Start.
- On the Replay menu, click Step.
- Repeat Step 6 until you have replayed all the necessary event steps.