How to replay to a breakpoint (SQL Profiler)

How to replay to a breakpoint (SQL Profiler)

To replay to a breakpoint

1. On the File menu, point to Open, and then click Trace File or Trace Table.
   
   
2. If you choose to replay 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. In the trace windows, click a trace event.
   
   
5. On the Replay menu, click Toggle Break-Point.
   
   
6. On the Replay menu, click Start.
   
   
7. In the Connect to SQL Server dialog box, select the server to connect to and a connection method.
   
   
8. In the Replay SQL Server dialog box, alter any necessary settings, and then click Start.

See Also

Monitoring with SQL Profiler