The SQL Profiler allows you to select the Deadlock Graph as a traced event. It captures deadlock information in XML format and displays it graphically in the tool.

Using SQL Server Profiler SQL Server Profiler is a separate application that lets you view the queries being run on the SQL Server database engine in real time as they complete.

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.

The flaw shows up in the use of SQL Profiler in Microsoft SQL Server 2000 to audit connections to SQL Server 2000 by using the Audit Login event class. When log-in names contain leading zero ...