Start a Trace Automatically after Connecting to a Server (SQL Server Profiler)
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
On the Tools menu, click Options.
Select the Start tracing immediately after making a connection check box.
If Start tracing immediately after making connection is selected, the Trace Properties dialog box fails to appear and the trace begins instead. To edit trace properties, you must first turn this setting off.