Mar 18, 2014

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 SET COMPATIBILITY_LEVEL option of ALTER DATABASE.


In general cause of this error is syntax sql query we are using is according to newer version of sql server while compatibility level of the current database is lower.

It is very easy to resolve this problem. You have to set the compatibility level of the current database to higher version. For example:

ALTER DATABASE ExactHelp
SET COMPATIBILITY_LEVEL = 100

Or

EXEC sp_dbcmptlevel ExactHelp,100
GO

It will resolve the issue:

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 SET COMPATIBILITY_LEVEL option of ALTER DATABASE.

No comments:

Post a Comment