I have a VB.Net application that calls a couple of stored procedures that update a couple of tables before updating the final table. I have a trigger which checks a couple of conditions when updating the final table. If they don't meet, it rolls back the transaction. I want to be able to roll back all transactions. Can I:
Have a begin transaction and end transaction within my .net application which would surround the stored procedure calls and the update on the main table (even though the main table has a begin and end transaction of its own in the trigger). I want to be able to rollback all changes.