How to save a trace to a file (SQL Server Profiler)

To save a trace to a file

1. On the File menu, click Open, and then click Trace Definition....
2. In the Trace Properties dialog box, in the Trace Name list, click the name of the trace to save to a file, and then select Capture File.
3. In the Save As dialog box, in the File name box, enter a name for the trace file.

See Also

Saving Traces