While runing stored procedures, it failed. The error message is:
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
What would cause this error?
The database is not changed since last time.
No 'ANSI_PADDING' setting while creating stored procedures.