When doing a COMMIT in a trigger, the result is an error message wich is wrong.The error message says "The transaction ended in the trigger. The batch has been aborted.", wich is not true because the transaction does the job and no rollback has been applied.This error isvisible in all edition/version of SQL Server since almost 2008 and perhaps 2005.In fact I think this has nothing to do with an error and we can say that no error message must be throw to the client application in such a case. Only a simple warning will be acceptable.
Operating System Language
Steps to Reproduce