Skip to content

create-a-transact-sql-script-for-running-a-trace-sql-server-profiler.md

Latest commit

 

History

History
32 lines (24 loc) · 1.58 KB

create-a-transact-sql-script-for-running-a-trace-sql-server-profiler.md

File metadata and controls

32 lines (24 loc) · 1.58 KB
title Create a Transact-SQL Script for Running a Trace
titleSuffix SQL Server Profiler
description Find out how to create a Transact-SQL script from an existing trace file or table in SQL Server Profiler.
ms.service sql
ms.reviewer
ms.subservice profiler
ms.topic conceptual
ms.assetid 6b0e2519-998d-40d5-b8ba-5e6a773f91a6
author markingmyname
ms.author maghan
ms.custom seo-lt-2019
ms.date 03/01/2017

Create a Transact-SQL Script for Running a Trace (SQL Server Profiler)

[!INCLUDE SQL Server] This topic describes how to create a Transact-SQL script from an existing trace file or table by using [!INCLUDEssSqlProfiler].

To create a Transact-SQL script to run a trace

  1. Open a trace file or table. For more information, see Open a Trace File (SQL Server Profiler) or Open a Trace Table (SQL Server Profiler).

  2. On theFilemenu, point to Export, point to Script Trace Definition, and then click the version that corresponds to the server you want to trace.

  3. In the Save As dialog box, enter a name for the script file, and then click Save.

See Also

SQL Server Profiler Templates and Permissions
SQL Server Profiler