You need to provide a group of users from the IT and Manufacturing departments the minimum administrative rights…
You need to modify the Manufacturing.ManProc1 and Manufacturing.ManProc2 stored procedures to minimize the risk of deadlocks when the stored procedures execute