Hi,

I am creating a new SQL Server database, using a script generated from another database. When I executed the script, it runs, but in one place I get error:

CREATE INDEX 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 filtered indexes and/or query 
notifications and/or XML data type methods and/or spatial index operations.

So I started looking through the script and see that there is SET ANSI_PADDING ON before every Create Table and then it is set to OFF. What is the purpose of this ON/OFF? And is there a way to find the place in the script (which is quite long) which causes the above error?

TIA.

UPDATE. I think I know what triggered the error. I added a Filtered index to one of the tables on which the script was generated. Apparently it is ok to add a filtered index in SSMS but when the script does it, the SET ANSI_PADDING conflicts.