>Hi
>
>I'm creating some stored procedures which are inserting a set of records into various tables in my database.
>
>I want to wrap each set of inserts in a transaction so only a complete set get added.
>
>How do I make sure that any errors are picked up and stop the transaction being committed.
>
>Thanks

Take a look at my blog post showing an example of a procedure that utilizes transactions and TRY/CATCH:
How to insert information into multiple related tables and return ID using SQLDataSource