RonKyle,

I can't really dispute your points regarding the benefits of triggers. One argument that could be made in favor of the technique I described is that it doesn't require transact-sql programming. Such an argument would have to contend that a view does not constitute programming, which I think is debatable. I've been on projects that prohibited stored procedures because the thought was that they were too difficult to teach to developers. I thought it was silly at the time, but darned if I haven't seen that stored procedures can be a difficult concept for some to grasp. I think that goes double for triggers. You would hope a DBA would write a trigger, but that doesn't always happen. Perhaps the Mary Hartman, Mary Hartman technique is something that developers can grasp better than triggers. Or (more likely) it's just a cool trick I wanted to share.

-Dan