Export (0) Print
Expand All
Expand Minimize

How to replay to the cursor (SQL Profiler)

SQL Server 2000

How to replay to the cursor (SQL Profiler)

  New Information - SQL Server 2000 SP3.

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.

    Security Note  When possible, use Windows Authentication.

  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.

    Security Note  When possible, use Windows Authentication.

  7. In the Replay SQL Server dialog box, alter any necessary settings and then click Start.

See Also

Monitoring with SQL Profiler

Show:
© 2014 Microsoft