How to replay to the cursor (SQL Profiler)

How to replay to the cursor (SQL Profiler)

To replay to the cursor

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 window, click an event.
   
   
5. On the Replay menu, click Run To Cursor.
   
   
6. In the Connect to SQL Server dialog box, select the server to connect to and a connection method.
   
   
7. In the Replay SQL Server dialog box, alter any necessary settings and then click Start.

See Also

Monitoring with SQL Profiler