Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2012
Product Documentation
Books Online for SQL Server 2012
Database Engine
Database Engine Features and Tasks
Database Engine Instances (SQL Server)
SQL Server Profiler
SQL Server Profiler Templates and Permissions
Run SQL Server Profiler
Create a Trace (SQL Server Profiler)
Specify Events and Data Columns for a Trace File (SQL Server Profiler)
Save Trace Results to a File (SQL Server Profiler)
Save Trace Results to a Table (SQL Server Profiler)
Filter Events in a Trace (SQL Server Profiler)
View Filter Information (SQL Server Profiler)
Modify a Filter (SQL Server Profiler)
Set a Maximum File Size for a Trace File (SQL Server Profiler)
Set a Maximum Table Size for a Trace Table (SQL Server Profiler)
Start a Trace
Start a Trace Automatically after Connecting to a Server (SQL Server Profiler)
Filter Events Based on the Event Start Time (SQL Server Profiler)
Filter Events Based on the Event End Time (SQL Server Profiler)
Filter Server Process IDs (SPIDs) in a Trace (SQL Server Profiler)
Pause a Trace (SQL Server Profiler)
Stop a Trace (SQL Server Profiler)
Run a Trace After It Has Been Paused or Stopped (SQL Server Profiler)
Clear a Trace Window (SQL Server Profiler)
Close a Trace Window (SQL Server Profiler)
Set Trace Definition Defaults (SQL Server Profiler)
Set Trace Display Defaults (SQL Server Profiler)
Open a Trace File (SQL Server Profiler)
Open a Trace Table (SQL Server Profiler)
Replay a Trace Table (SQL Server Profiler)
Replay a Trace File (SQL Server Profiler)
Replay a Single Event at a Time (SQL Server Profiler)
Replay to a Breakpoint (SQL Server Profiler)
Replay to a Cursor (SQL Server Profiler)
Replay a Transact-SQL Script (SQL Server Profiler)
Create a Trace Template (SQL Server Profiler)
Modify a Trace Template (SQL Server Profiler)
Set Global Trace Options (SQL Server Profiler)
Find a Value or Data Column While Tracing (SQL Server Profiler)
Derive a Template from a Running Trace (SQL Server Profiler)
Derive a Template from a Trace File or Trace Table (SQL Server Profiler)
Create a Transact-SQL Script for Running a Trace (SQL Server Profiler)
Export a Trace Template (SQL Server Profiler)
Import a Trace Template (SQL Server Profiler)
Extract a Script from a Trace (SQL Server Profiler)
Correlate a Trace with Windows Performance Log Data (SQL Server Profiler)
Organize Columns Displayed in a Trace (SQL Server Profiler)
Start SQL Server Profiler
Save Traces and Trace Templates
Modify Trace Templates
Correlate a Trace with Windows Performance Log Data
View and Analyze Traces with SQL Server Profiler
Analyze Deadlocks with SQL Server Profiler
Analyze Queries with SHOWPLAN Results in SQL Server Profiler
Filter Traces with SQL Server Profiler
Replay Traces
SQL Server Profiler F1 Help
Expand Minimize
2 out of 3 rated this helpful - Rate this topic

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

SQL Server 2012

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.

Note 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.
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.