How to create a trace (SQL Profiler)

To create a trace

On the File menu, point to New, and then click Trace.
In the SQL Server list, select the server to be traced, and then select a connection.
In the Trace name box, type a name for the trace, and then do the following:
- In the Trace SQL Server list, select a server for the trace to run on.
- In the Template name list, select a trace template on which the trace will be based.
Do one of the following:
- click Save to file to capture the trace to a file in another location.
- click Save to table to capture the trace to a database table.
Optionally, select the Enable trace stop time check box to specify a stop date and time.
To complete other trace properties, click the Events, Data Columns, or Filters tabs and set the options on these tabs.
Click Run when ready to start the trace.