Skip to content

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

Latest commit

 

History

History
33 lines (26 loc) · 1.71 KB

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

File metadata and controls

33 lines (26 loc) · 1.71 KB
title Extract a Script from a Trace (SQL Server Profiler) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql
ms.prod_service sql-tools
ms.reviewer
ms.technology profiler
ms.topic conceptual
helpviewer_keywords
scripts [SQL Server], traces
extracting script from trace [SQL Server]
ms.assetid 431126a6-ff91-4818-8763-4442152bd571
author stevestein
ms.author sstein
manager craigg

Extract a Script from a Trace (SQL Server Profiler)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] 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