Nested transactions
66790May 3 2005 — edited May 9 2005how do I prevent individual stored procedures from handling their own transaction control.
The example is a main Stored proc calling several other stored programs. Does the main stored proc have the control for the final rollback and or commit?
Is it as simple as not putting in commits and rollbacks in exception blocks in the nested procs?
Please help.