---
title: Derive a Template from a Trace File or Trace Table
titleSuffix: SQL Server Profiler
description: Discover how to use SQL Server Profiler to create a trace template from an existing trace file or from a trace table stored in a database.
ms.prod: sql
ms.prod_service: sql-tools
ms.reviewer: ""
ms.technology: profiler
ms.topic: conceptual
ms.assetid: 305817b7-4d23-49fb-9e6c-4d34359877bf
author: markingmyname
ms.author: maghan
ms.custom: seo-lt-2019
ms.date: 03/01/2017
---

# Derive a Template from a Trace File or Trace Table (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 file or table by using [!INCLUDE[ssSqlProfiler](../../includes/sssqlprofiler-md.md)].  
  
### To derive a template from a trace file or trace table  
  
1.  Open the trace file or trace table on which you want to base your template. For more information, see [Open a Trace File (SQL Server Profiler)](../../tools/sql-server-profiler/open-a-trace-file-sql-server-profiler.md) or [Open a Trace Table (SQL Server Profiler)](../../tools/sql-server-profiler/open-a-trace-table-sql-server-profiler.md).  
  
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.  
  
## See Also  
 [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)   
 [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)   
 [SQL Server Profiler](../../tools/sql-server-profiler/sql-server-profiler.md)