Home Forums SQL Server 2008 SQL Server 2008 - General TryCatch RE: TryCatch
Stephanie Giovannini
SSCertifiable
Points: 7422
More actions
May 28, 2015 at 2:30 pm
#1801406
SET XACT_ABORT ON
Add that line before you begin the transaction. With that setting, you may not even need a try/catch. The transaction will roll back on error.