Add a new database option:SET ObjectLockOrderConsistent ONWhen this option is on the locks requested by any TSQL statements are always requested in object_id sorted order.This will eliminate deadlocks - if all queries ask for resources in the same order. I imagine it is too hard. I imagine that the query engine would need an overhaul, but if you could do it it would be fantastic. It would be the end of deadlocks - a major headache. Just dreaming...