Hi Nelson,

No problem and I hope you found the trigger useful.

Yes, the trigger executes as Auditor, a user that has the minimum level of permissions required to insert to the audit table.

You can of course change this to suit your needs. One addendum to the article is adding "GRANT SHOWPLAN TO db_auditor;" if you wish to view execution plans that include the triggering action.

Many thanks for your interest, Andy.