Set Trace Definition Defaults (SQL Server Profiler)

Applies to: SQL Server Azure SQL Managed Instance

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 Generaltab, select a server type from the Select server typelist.

  3. In the Select template namelist, 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 Selectiontab to modify the template.

  6. Click Save.

See Also

SQL Server Profiler Templates
SQL Server Profiler