Export (0) Print
Expand All
Expand Minimize

How to derive a template from a trace file or trace table (SQL Profiler)

SQL Server 2000

How to derive a template from a trace file or trace table (SQL Profiler)

  New Information - SQL Server 2000 SP3.

To derive a template from a trace file or trace table

  1. On the File menu, point to Open, and then click either 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 which you want to connect 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 a trace table to open.

  4. On the File menu, point to Save As, and then click Trace Template.

  5. Type a name and save the template file.

See Also

Monitoring with SQL Profiler

Show:
© 2014 Microsoft