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