Discover how to limit the size of the trace file in SQL Server Profiler and how to specify whether the file rolls over when it reaches maximum size. [!INCLUDE SQL Server] Use the following procedure ...

Learn how to use SQL Server Profiler to export a trace template as a template file so you can use the template with another instance of SQL Server Profiler. This topic describes how to export an ...

Then I would select a Profiler template to use and select events that I wish to trace such as Logins, Logouts, Stored Procedures starting, finishing, T-SQL Batches starting etc.

With SQL Server Profiler, you can filter the data capture, called a trace, so it only includes the required information.

Then select "SQL Server Profiler" from the menu. When the application opens, connect to the SQL Server instance that is having the problem. The properties of a new trace will open automatically.

It will even trace Stored Procedure and Trigger code if your application uses it. But it also can be used to find out what the management tools are doing under the hood, like SQL Server Management ...

That changed a bit with the release of 7.0: The client (which reads trace data) was renamed SQL Profiler, and the name SQL Trace was deemphasized. Now with SQL Server 2000, SQL Trace is back.