Trigger Trivia Posted on SSC
A short article but interesting I think, with some good comments already. I think in general triggers are under used, except in the cases where they are abused of course. Here's the article: http://www.sqlservercentral.com/articles/T-SQL/61483/