• Please turn traceflag 1204 off. Why is 3226 on? Do you know what it does?

    Once done if you get a deadlock graph from with the output from 1222, please post that here. Traceflag 1204 is a SQL 2000 and earlier flag and the info it produces for deadlocks is near-impossible to read and missing lots of necessary info.

    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