---
title: "Derive a Template from a Running Trace (SQL Server Profiler) | Microsoft Docs"
ms.custom: ""
ms.date: "03/01/2017"
ms.prod: sql
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]"
ms.assetid: 25a3b845-affb-4b2a-a382-198a4bdd9ad1
caps.latest.revision: 26
author: "stevestein"
ms.author: "sstein"
manager: "craigg"
---
# Derive a Template from a Running Trace (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 trace template from an existing trace while it is running by using [!INCLUDE[ssSqlProfiler](../../includes/sssqlprofiler-md.md)].  
  
### 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  
 [SQL Server Profiler Templates and Permissions](../../tools/sql-server-profiler/sql-server-profiler-templates-and-permissions.md)   
 [Create a Trace Template (SQL Server Profiler)](../../tools/sql-server-profiler/create-a-trace-template-sql-server-profiler.md)   
 [Modify a Trace Template (SQL Server Profiler)](../../tools/sql-server-profiler/modify-a-trace-template-sql-server-profiler.md)   
 [SQL Server Profiler](../../tools/sql-server-profiler/sql-server-profiler.md)