Skip to content

set-trace-definition-defaults-sql-server-profiler.md

Latest commit

 

History

History
41 lines (28 loc) · 1.62 KB

set-trace-definition-defaults-sql-server-profiler.md

File metadata and controls

41 lines (28 loc) · 1.62 KB
title Set Trace Definition Defaults
titleSuffix SQL Server Profiler
description Discover how to use SQL Server Profiler to set up the templates that SQL Server and Analysis Services use by default for each provider or server.
ms.prod sql
ms.prod_service sql-tools
ms.reviewer
ms.technology profiler
ms.topic conceptual
ms.assetid ab9fc570-797d-411e-814f-1c46d2d5feae
author markingmyname
ms.author maghan
ms.custom seo-lt-2019
ms.date 03/14/2017

Set Trace Definition Defaults (SQL Server Profiler)

[!INCLUDE SQL Server]

The trace definition default is the default trace template that is used for each provider or server. You can set default trace templates for [!INCLUDEssNoVersion] or for [!INCLUDEssASnoversion].

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