Modifying Traces

You can modify trace definitions saved in the registry on the local computer running SQL Server Profiler, trace definitions imported from files, and trace definitions created using extended stored procedures stored on the computer running Microsoft® SQL Server™. Trace definition properties, such as event classes and data columns to be monitored, 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 similarly changed. Once the trace definition is modified, saving the trace definition with the same trace or queue name overwrites the original trace definition. For more information, see Creating Traces.

When working with existing trace files and trace tables containing captured event data, only certain properties of the trace can be modified:

• Additional event classes and data columns cannot be added. Only existing event classes and data columns captured in the trace can be removed.
• Existing trace event filter criteria only can be modified.

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

To import a trace definition

To modify a trace

To add or remove events from a trace

To modify data columns