How to: Replay a Single Event at a Time (SQL Server Profiler)

This topic describes how to replay one event at a time in a replay trace file or table by using SQL Server Profiler.

To replay a single event at a time

1. Open the trace file or trace table you want to replay. For more information, see How to: Open a Trace File (SQL Server Profiler) or How to: Open a Trace Table (SQL Server Profiler).

   Make sure that the trace file or table you open contains the event classes necessary for replay. For more information, see Replay Requirements.

2. On the Replay menu, click Step, and connect to the server instance where you want to replay the trace.

3. In the Replay Configuration dialog box, verify the settings, and then click OK. For more information about specifying settings on the Replay Configuration dialog box, see How to: Replay a Trace File (SQL Server Profiler) or How to: Replay a Trace Table (SQL Server Profiler).

4. To replay the first event, click OK in the Replay Configuration dialog box.

5. To replay subsequent events, on the Replay menu, click Step, or press F10. Repeat clicking Step or pressing F10 for each event.

See Also

Concepts

Replaying Traces

Other Resources

SQL Server Profiler Reference

Help and Information

Getting SQL Server 2005 Assistance