Triggers are ok I guess, I find them a bit overkill for logging executed statements, it's far more elegant to develop your own logging.
The trouble I find with triggers is that, sometimes people forget they are there or maybe the table has to be reloaded in a distaster recovery scenario which means you then log a load of data you don't actually need.
It is in my opinion far better to design a standard for logging data updates by creating templates for stored procedures / views ect that already contain the logging components.