I have a rather complicated module which performs multiple updates and inserts to multiple back-end tables (on SQL Server), and it's an "all or nothing" kind of process. Can someone please show me a way to wrap all of my SQL update statements so that if something would of failed, it will rollback all of my changes to all of the tables?

Thanks in advance for your input.