I'm doubtful about the 'transaction' part of the article... the insert/update/delete statements AND the trigger are all part of the same transaction, so they'll be both rolled back in case a ROLLBACK TRAN is used inside the trigger.

No mention about the importance of keeping trigger code very focused (check the updated column(s), use the 'IF @@ROWCOUNT = 0 RETURN' statement, so on).

Triggers are extremely helpful in many different contexts, but many times they are just poorly written, hurting performance especially on pre-2000 versions...

Lorenzo