How to: Derive a Template from a Running Trace (SQL Server Profiler)

This topic describes how to create a trace template from an existing trace while it is running by using SQL Server Profiler.

To derive a template from a running trace

  1. If necessary, switch to the window that contains the trace.

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

  3. Type a name or select one from the list. Click OK.

Note

If you select an existing template file, you are asked if you want to overwrite the file. You can only select a user-defined template. Predefined system trace templates cannot be overwritten.

See Also

Tasks

How to: Create a Trace Template (SQL Server Profiler)
How to: Modify a Trace Template (SQL Server Profiler)

Other Resources

Using SQL Server Profiler
Introducing SQL Server Profiler
SQL Server Profiler Reference

Help and Information

Getting SQL Server 2005 Assistance