• Without a traceflag, there's nothing written into the SQL errorlog.

    The deadlock error is sev 16, not enough to be logged. You can set up an agent alert for it or, since you're on SQL 2008 you can poll the system health extended events session and get the entire deadlock graph.

    The system health session is much like the default trace, it's a circular file so any deadlocks caught aren't kept forever.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass