Perhaps a bit deeper than just a database option, I'd like to see some table options that would give NoSQL a run for their money when it comes to ETL...

2008 is now a decade old.  Now would be a good time to do an upgrade.

Fair enough.  What is the WAITFOR DELAY for?  It's waiting for zero seconds.

Also, was the @Operation thing in the code I posted what you were looking for?

BTW... I believe that you'll find that capturing the query and saving it in the audit table will become a HUGE distraction not to mention a pretty good drag on...

Here's what I typically preset triggers with.

--=====================================================================================================================
--      Presets
--=====================================================================================================================
--===== Exit early if no changes where actually made to the base table.
     -- *****...

Shifting gears back to the subject at hand...

One of the things we use custom schemas for is to identify the expendability and life expectancy of a table.