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 ...

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.

Users simply: 1) connect to an SQL Server instance, 2) select a database, 3) select a table, 4) optionally adjust profiling settings, 5) press a button, and 6) view the results.