Export (0) Print
Expand All
Expand Minimize

How to derive a template from a running trace (SQL Profiler)

SQL Server 2000

How to derive a template from a running trace (SQL Profiler)

  New Information - SQL Server 2000 SP3.

To derive a template from a running trace

  1. On the File menu, point to New, and then click Trace.

  2. In the Connect to SQL Server dialog box, select the server to be traced and connection method.

    Security Note  When possible, use Windows Authentication.

  3. In the Trace Properties dialog box, do the following:
    • In the Trace name box, type the name of the new trace.

    • In the Template name list, select a template.
  4. Modify the template by adding or deleting events, columns, or filters, and then start the trace by clicking Run.

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

  6. Type a name and save the template file.

See Also

Monitoring with SQL Profiler

Show:
© 2014 Microsoft