tommyh (10/1/2010)
Running the code under 2000 all i get is
(1 row(s) affected)
under 2005 and 2008 i get
Server: Msg 3609, Level 16, State 1, Line 1
The transaction ended in the trigger. The batch has been aborted.
(1 row(s) affected)
Server: Msg 3609, Level 16, State 1, Line 2
The transaction ended in the trigger. The batch has been aborted.
The effect is as you say the same the rollback performed.
/T
Thanks for this observation, in time I wrote the question I missed this. You are right the messages are more clear.