Modifying Templates

Administering SQL Server

Administering SQL Server

Modifying Templates

You can modify templates saved in the file on the local computer running SQL Profiler and templates derived from files. You may need to derive a template from a trace file if you cannot remember the original template that was used to create the trace, or if you want to run the same trace at a later date. Template properties, such as event classes and data columns, are modified in the same way in which the properties were originally set. Event classes and data columns can be added or removed, and filters can be changed. After the template is modified, saving it with the same name overwrites the original template. For more information, see Creating and Managing Traces and Templates.

When working with existing traces, you can view the properties, but you cannot modify them.

Warning  Saving a trace file with the same name overwrites the original trace file, causing any of the originally captured events or data columns that were removed or filtered to be lost.

To derive a template from a trace file or trace table