Enter the SQL Profiler. This monitoring tool is designed to trace any activity that occurs on a SQL Server database server.

SQL Server Profiler has always been a great tool for tracing activity “under the hood” on a SQL Server and assessing its performance. One feature that helps us quickly set up a trace on our ...

Second, SQL Server 2000’s Profiler introduces template files, which replace both the Create Trace Wizard and the storage of trace definitions in the Registry.