Save Trace Results to a Table

This article describes how to save trace results to a database table by using SQL Server Profiler.

1. On the

menu, select

, and then connect to an instance of SQL Server.

The

dialog box appears.

If

is selected, the

dialog box fails to appear and the trace begins instead. To turn off this setting, on the

menu, select

, and clear the

check box.

2. In the

box, type a name for the trace, and then select.

3. In the

dialog box, connect to the SQL Server database that will contain

the trace table.

4. In the

dialog box, select a database from the

list.

5. In the

list, select the owner for the trace.

6. In the

list, type or select the table name for the trace results. Select.

7. In the

dialog box, select the

check

box to specify the maximum number of rows to save.

Profiler