SQL Server's Profiler is also a fairly capable tool. It could be a lot better, but it provides the basic functionality you need, and it's a vast improvement over the SQL Trace facility in releases of SQL Server prior to 7.0. It presents a graphical interface wherein you specify the events for which you'd like to watch on the server. You can trace virtually anything that happens on the server—from T-SQL batches to stored procedures to sort warnings and error log entries.
To start a new trace using Profiler, follow these steps:
Click File|New|Trace in the Profiler GUI to bring up the Trace Properties dialog.
Specify the trace attributes you want, selecting the elements that make the most sense in your particular ...