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

title	Extract a Script from a Trace
titleSuffix	SQL Server Profiler
description	Learn how to extract Transact-SQL events from a trace file or table in SQL Server Profiler and save them as a Transact-SQL script file.
ms.prod	sql
ms.prod_service	sql-tools
ms.reviewer
ms.technology	profiler
ms.topic	conceptual
ms.assetid	431126a6-ff91-4818-8763-4442152bd571
author	markingmyname
ms.author	maghan
ms.custom	seo-lt-2019
ms.date	03/14/2017

Extract a Script from a Trace (SQL Server Profiler)

[!INCLUDE SQL Server]

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