You need to modify the Manufacturing.ManProc1 and Manufacturing.ManProc2 stored procedures to minimize the risk of deadlocks when the stored procedures execute