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


Applies To: SQL Server 2016

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.

System_CAPS_ICON_note.jpg Note

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.

SQL Server Profiler

Community Additions