>
Triggers should be used as a last resort. >
>I started to reply, and then saw this - why do you say that?
It's easy to drop the trigger or disable it and then you will have no audit. If you know that updates can only be done using this particular SP and you can encapsulate the logic in there - use that instead of triggers.
There are some other concerns in regards to triggers, but I think the above is enough for a quick answer.
If it's not broken, fix it until it is.
My Blog