In Adventure works please answer the following and provide screen shots in a word or excel document.
Cause a deadlock using updates on Person. Person and Human Resources. Employee. You will have to run different queries in sequence within two transactions using at least two query windows within Management Studio to do this. Hint: If you BEGIN TRANSACTION within a query window, the transaction stays open until you COMMIT, ROLLBACK, or kill the connection.