Between a 'begin transaction' and 'commit transaction', will the database lock all tables involved until the commit transaction is executed?
I've seen various posts about locking single tables, but the proc I'm using touches a few dozen tables. If the 'transaction' doesn't lock all of the tables, what is the best route to make sure the transaction goes through completely without any changes made apart from what the transaction calls for?
I've seen various posts about locking single tables, but the proc I'm using touches a few dozen tables. If the 'transaction' doesn't lock all of the tables, what is the best route to make sure the transaction goes through completely without any changes made apart from what the transaction calls for?