knaren1975
asked on
Capturing deadlocks in Sqlserver 2005 and 2008 version
Hi
is there any way to capture deadlocks in sqlserver 2005/2008 without using sql server profiler?
Thx
Naren
is there any way to capture deadlocks in sqlserver 2005/2008 without using sql server profiler?
Thx
Naren
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://www.mssqltips.com/sqlservertip/2003/simple-process-to-track-and-log-sql-server-stored-procedure-use/
Or you could roll your own based on this approach to just trap and log the deadlocks.