I'm trying to prevent a user from updating a value in a table from b to a. Once the value becomes b, it should never revert back to a.
To accomplish this, I decided to add a trigger on the table and if they try to update from value b back to value a I don't want to allow this.
In my trigger, I used Rollback to prevent the update from happening. This trigger works well in the sense that it does not allow value a into the field however, when I do this, I get a message from SQL saying:
Msg 3609, Level 16, State 1, Line 1
The transaction ended in the trigger. The batch has been aborted.
Is this message simply informative and not hurting anything or is it causing harm. Should I be doing this differently?