Considering that the auditing needs to be the last, how can I be sure it´ll
ran lastly ?
IMHO, auditing should be done in after- triggers, when that the data in the records being inserted, updated or deleted can't be changed but you can still write to the separate auditing tables.
--
Mike Nolan