<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
I have a trigger that in some cases will execute a roolback. I know that the rollback is successful but an error message is generated:<br />
<br />
Msg 3609, Level 16, State 1, Line 1<br />
The transaction ended in the trigger. The batch has been aborted.<br />
<br />
Is there any way to turn this off as it is causing me problems.<br />
<br />
Thanks.
</div>
</div>


Hi All,

I have a trigger that in some cases will execute a roolback. I know that the rollback is successful but an error message is generated:

Msg 3609, Level 16, State 1, Line 1
The transaction ended in the trigger. The batch has been aborted.

Is there any way to turn this off as it is causing me problems.

Thanks.

Turn off error message

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.