Logging via triggers is ok, but instead of triggers give you some options that werent there previously.

Bravo to anyone who at least traps for the error if it should occur. Bet that is almost always overlooked.

Andy

http://www.sqlservercentral.com/columnists/awarren/