extract-a-script-from-a-trace-sql-server-profiler.md

title	Extract a Script from a Trace (SQL Server Profiler) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	article
helpviewer_keywords	scripts [SQL Server], traces extracting script from trace [SQL Server]
ms.assetid	431126a6-ff91-4818-8763-4442152bd571
caps.latest.revision	20
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

Extract a Script from a Trace (SQL Server Profiler)

This topic describes how to extract [!INCLUDEtsql] events from a trace file or table and save them as a [!INCLUDEtsql] script file by using [!INCLUDEssSqlProfiler].

To extract a Transact-SQL script from a trace file or table

1. Open a trace file or table that contains [!INCLUDEtsql] events that you want to save to a [!INCLUDEtsql] script file. For more information, see Open a Trace File (SQL Server Profiler) or Open a Trace Table (SQL Server Profiler).

2. On the File menu, point to Export, point to Extract SQL Server Events, and then click Extract Transact-SQL Events.

3. In the Save As dialog box, type a name for the [!INCLUDEtsql] file, and click Save.

See Also

SQL Server Profiler