As always with triggers, the biggest issue is to make the sure the triggers are coded properly, i.e. they deal with sets and not a row at a time, and that they are as efficient as possible, even if that sacrifices some clarity.

In particular, under no circumstances do any table meta-data lookup at run time. Don't lookup the type, name or number of columns. The trigger code should be static.

However, that static code can be dynamically generated, so that when the table schema changes it can be regenerated, but the trigger itself should not be dynamic.