How to set an EndTime filter for a trace (SQL Profiler)

How to Install SQL Server 2000

How To

How to set an EndTime filter for a trace (SQL Profiler)

To set an EndTime filter for a 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 connect to and a connection method.

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

    • In the Template name list, select a trace template.

    • Optionally, specify a save destination for the trace results.
  4. Click the Filters tab, and then in the Trace event criteria box, expand EndTime.

  5. Expand Greater or Less than, and then enter a time value in the field that appears beneath the criterion.

See Also

Monitoring with SQL Profiler