• SQL Server 2008 has a system_health extended event session. I'm pretty sure it's capturing information from your deadlock called a deadlock graph. You'll need to query the files to get the information. Here's an article on how to get that done[/url]. You won't have to turn on traceflags or recreate the issue. When you have the deadlock graph, zip it up and post it here to get help interpreting it.

    "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