Start a Trace Automatically after Connecting to a Server (SQL Server Profiler)

APPLIES TO: YesSQL Server NoAzure SQL Database NoAzure Synapse Analytics (SQL DW) NoParallel Data Warehouse

This topic describes how to start traces automatically after connecting to an instance of SQL Server by using SQL Server Profiler.

To start a trace automatically after connecting to a server with SQL Server Profiler

  1. On the Tools menu, click Options.

  2. Select the Start tracing immediately after making a connection check box.


If Start tracing immediately after making connectionis selected, the Trace Propertiesdialog box fails to appear and the trace begins instead. To edit trace properties, you must first turn this setting off.

See Also

SQL Server Profiler