Skip to content

Latest commit

 

History

History
32 lines (22 loc) · 1.67 KB

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

File metadata and controls

32 lines (22 loc) · 1.67 KB
title titleSuffix description author ms.author ms.date ms.service ms.subservice ms.topic ms.collection
Extract a Script from a Trace
SQL Server Profiler
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.
rwestMSFT
randolphwest
03/14/2017
sql
profiler
how-to
data-tools

Extract a Script from a Trace (SQL Server Profiler)

[!INCLUDE SQL Server Azure SQL Managed Instance]

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