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

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

  New Information - SQL Server 2000 SP3.

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.

   Security Note  When possible, use Windows Authentication.

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.

   Security Note  When possible, use Windows Authentication.

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