I did run into one problem with the trigger scripts. Since the quotename function is used the argument is of type sysname which is nvarchar(128). If you have a field longer than this it nulls out the entire field and since the bigAudit table does not allow any null values in any column the trigger fails. I have changed the 1 trigger that I ran into by just including the quotes myself. So for any column that might have data longer than 128 I changed the insert/delete/update sections of the trigger from:
QUOTENAME(i.[Column Name],'''')
to
(''''+i.[Column Name]+'''')
Before making this change I would get this error:
Msg 515, Level 16, State 2, Procedure trgAuditscripts, Line 35
Cannot insert the value NULL into column 'RollForwardSQL', table 'Audit.dbo.BigAudit'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Just wanted to post this in case anyone else was having problems.