>I have generated a script from SQL Server 2014 to be compatible for SQL Server 2008 R2. So, I selected the option to target at SQL Server 2008 R2. I still see errors such as:
>
>Msg 102, Level 15, State 6, Line 1
>Incorrect syntax near 'CONTAINMENT'.
>Msg 102, Level 15, State 6, Line 1
>Incorrect syntax near 'FILESTREAM'.
>Msg 102, Level 15, State 6, Line 1
>Incorrect syntax near 'TARGET_RECOVERY_TIME'.
>Msg 102, Level 15, State 1, Line 1
>Incorrect syntax near 'DISABLED'.
>
>Anyone could explain that?
Can you post the exact lines that produced the errors? Most likely it's a bug in SSMS and you would need to create a Connect item. Once you do so, can you post a link here?
Thanks.
If it's not broken, fix it until it is.
My Blog