>I will check it. Thank you. >>IIRC, SSMS has setting for scripting to generate SET commands. It's disabled by default >> >>>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 >>>>
Take a look at this article explaining the problem in details: