CREATE UNIQUE NONCLUSTERED INDEX [ix_mmreqes_web_user] ON [dbo].[mmreqes] ( [web_user] ASC ) WHERE ([web_user]<>'') WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]Then I Generate Script of the database (in order to create a new one with the same structure).
Msg 1934, Level 16, State 1, Line 1 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.What is wrong with my Index script that it causes the error?