daniel_

To eliminate deadlocking scenarios, you need only a canonical order in which all queries (preferably stored procedures) are touching objects in the db. Of course that order isnt always fixed in a product outside of your control, it will be hard to decipher if it hasnt been documented, and some designs may make that…