似乎您已从较低版本升级到SQL Server 2008.兼容性，那么它不会给出此错误

设置为更高的兼容性，请使用以下代码

Seems you have upgraded to SQL Server 2008 from lower version....set the compatibility then it won''t give this error

to set to a higher compatibility use the below code

EXEC sp_dbcmptlevel ''yourDatabaseNameHere'', 100 

在 sp_dbcmptlevel
上了解更多信息.
如果它回答了您的问题，请标记为解决方案....

Read more on sp_dbcmptlevel

Mark as solution if it anwer your question....