Skip to content

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

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 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.
author rwestMSFT
ms.author randolphwest
ms.date 03/14/2017
ms.service sql
ms.subservice profiler
ms.topic how-to
ms.collection
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