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.

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

xp_trace% extended stored procedures, which you need to learn to use in order to perform those tasks that are too complex for Profiler to handle. SQL Server 2000, however, has greatly simplified ...

When SQL Server Management Studio is already open, the easiest way to open SQL Profiler is to click on the Tools dropdown menu. Then select "SQL Server Profiler" from the menu.

A recently discovered vulnerability in Microsoft's SQL Server 2000 database allows users to mask their log-in names.