Standard Edition

10.0.4000.0

SP2

There are no DML triggers. I have scripted out everything as well as checking the included objects, in multiple ways.

I cannot figure this out. I recompiled both procedures and there is absolutely no reason (that I can find) that the Update procedure should get any kind of lock on the TableB table.