I will Google for more explanation of the requirments. Thank you.
>Check requirements for creating Filtered indexes. The problem is not with the script you posted but with the setiing for the current session. SET ANSI_PADDING in particular
>
>
>>I added the following index to the database:
>>
>>
>>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).
>>
>>But when I run the newly generated script against a newly created database, I get this error:
>>
>>
>>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?
>>
>>By the way, if I Generate the Script without this index and then add this index to the newly created database, no error.
>>
>>TIA.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham