Subject Question about transactions
Author slsolutions2002

I have a stored procedure that is triggered by adding a record to a
table. The stored procedure adds/updates several support records in
other tables when a record is added.updated in the main table. My
question is this: Do I need to start an explicit transaction or will
the default transaction insure that nothing gets posted if there is
an error adding/updating one of the support records.