Home Forums SQL Server 2008 T-SQL (SS2K8) Deadlock In SQL RE: Deadlock In SQL

  • January 7, 2013 at 4:57 pm

    #1574570

    GilaMonster (1/7/2013)

    Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.

    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