The attached code works beautifully, except we find that we can no longer use "SET ANSI_PADDING OFF" and must convert to "SET ANSI_PADDING ON", see error message below.

I like to understand why would this be the case?

thanks!

error message:

Msg 1934, Level 16, State 1, Procedure DDLChange_trg, Line 29

INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods.