How to: Set Trace Definition Defaults (SQL Server Profiler)

The trace definition default is the default trace template that is used for each provider or server. You can set default trace templates for SQL Server or for Analysis Services.

To set trace definition defaults

  1. On the File menu, select Templates, and then click Edit Template.

  2. In the Trace Template Properties dialog box, on the General tab, select a server type from the Select server type list.

  3. In the Select template name list, select the name of the template that you want to use as the trace definition default.

  4. Select Use as a default template for selected server type.

  5. If necessary, click the Events Selection tab to modify the template.

  6. Click Save.

See Also

Concepts

SQL Server Profiler Templates

Other Resources

Introducing SQL Server Profiler
SQL Server Profiler Reference

Help and Information

Getting SQL Server 2005 Assistance