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.

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

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.