October 21, 2008 - SQL Authority with Pinal Dave

SQL SERVER – Fix : Error : Incorrect syntax near. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel

October 21, 2008

I have seen developers confused many times when they receive the following error message. Incorrect syntax near. Let us learn.