• Hmmm...that is frustrating.

    I suppose you could read the log/log backup looking for the XactIDs mentioned in the xml or run a trace to see what batches typically precede those SELECTs, but I'm not sure what else could be done if the deadlock xml is omitting that information.

    Cheers!