• Since this is a post to a 2008 forum, you should know that you're already capturing deadlock information in the system_health extended events session that is running on your servers, right now. You no longer have to go the route of setting traceflags and digging through the error log. You can read about it in more detail here.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning