How to create an SQL Script for a running trace (SQL Profiler)
To create an SQL Script for running a trace
- Create and run a new trace, or create or open a trace template.
- On the File menu, point to Script Trace, and then click For SQL Server 2000 or For SQL Server 7.0, depending on the server that is to be traced.