Thanks Jeff.

Primary function of these audit columns is to help load data from oltp to data warehouse using insert/update audit columns using ssis. Thought about cdc, but they find this technically not feasible for these many tables or more work involved. Hence preferred triggers.

thanks!