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.