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.