---
title: "Create a Trace Template (SQL Server Profiler) | Microsoft Docs"
ms.custom: ""
ms.date: "03/01/2017"
ms.prod: "sql-non-specified"
ms.prod_service: "sql-tools"
ms.service: ""
ms.component: "sql-server-profiler"
ms.reviewer: ""
ms.suite: "sql"
ms.technology: 
  - "database-engine"
ms.tgt_pltfrm: ""
ms.topic: "article"
helpviewer_keywords: 
  - "templates [SQL Server], traces"
  - "trace templates [SQL Server]"
  - "saving trace template"
ms.assetid: 025868b0-3790-4cda-8757-5a58327bfba0
caps.latest.revision: 24
author: "stevestein"
ms.author: "sstein"
manager: "craigg"
ms.workload: "Inactive"
---
# Create a Trace Template (SQL Server Profiler)
[!INCLUDE[appliesto-ss-xxxx-xxxx-xxx-md](../../includes/appliesto-ss-xxxx-xxxx-xxx-md.md)]
  This topic describes how to create a new trace template by using [!INCLUDE[ssSqlProfiler](../../includes/sssqlprofiler-md.md)].  
  
### To create a trace template  
  
1.  On the **File** menu, point to **Templates**, and then click **New Template**.  
  
2.  In the **Trace Template Properties** dialog box, select a server type from the **Select server type**list.  
  
3.  In the **New template name** box, enter a template name.  
  
4.  Optionally, click **Base new template on existing one**, and then select a template from the list.  
  
     All events, data columns, and filters are initially set as specified in the selected template.  
  
5.  Optionally, click **Use as a default template for selected server type**.  
  
6.  On the **Events Selection** tab, add, remove, or modify events, data columns, or filters.  
  
7.  On the **Events Selection**tab, use the grid control to add or remove events and data columns from the trace file as follows:  
  
    -   To add an event, expand the appropriate event category in the **Events** column, and then select the event name.  
  
    -   When you add an event, all relevant data columns are included by default. To remove a data column for an event from a trace, clear the check box in the data column for the event.  
  
    -   To add filters, click the data column name and specify the filter criteria in the **Edit Filter** dialog box. You can also right-click the data column name, and click **Edit Column Filter** to launch the **Edit Filter** dialog box. Click **OK** to add the filter.  
  
8.  Click **Save.**  
  
## See Also  
 [Specify Events and Data Columns for a Trace File (SQL Server Profiler)](../../tools/sql-server-profiler/specify-events-and-data-columns-for-a-trace-file-sql-server-profiler.md)   
 [Derive a Template from a Running Trace (SQL Server Profiler)](../../tools/sql-server-profiler/derive-a-template-from-a-running-trace-sql-server-profiler.md)   
 [Derive a Template from a Trace File or Trace Table (SQL Server Profiler)](../../tools/sql-server-profiler/derive-a-template-from-a-trace-file-or-trace-table-sql-server-profiler.md)   
 [SQL Server Profiler Templates and Permissions](../../tools/sql-server-profiler/sql-server-profiler-templates-and-permissions.md)   
 [SQL Server Profiler](../../tools/sql-server-profiler/sql-server-profiler.md)