Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

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

This topic describes how to create a Transact-SQL script from an existing trace file or table by using SQL Server Profiler.

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

  2. On the File menu, point to Export, point to Script Trace Definition, and then click For SQL Server 2005, For SQL Server 2000, or For Analysis Services 2005, depending on the server that is to be traced.

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft