Thanks Sergey and Boris

>Make sure that SET XACT_ABORT is ON
>
>>
>>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