Oh wow I was just looking at some of your code on another post 🙂 it makes it much easier to read thanks.
I do have some niggly questions like why does the LockMode U appear in the graph for the delete and vice versa? I assume its just the way the graph is rendered but it bugs me :s
The other question is what importance does the Input Buffer have, I think I was following this as a red herring. The proc mentioned in the Input Buffer actually ends up being proc_MSS_ProcessCommitted how does this relate to the deadlock? This proc is also mentioned in the <frame procname for both processes and am confused as to its relevance in the graphs.
I will also look at the execution plans for the two procs in questions, I no doubt will have more questions ..grr...
Many thanks 🙂