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
Read more on
sp_dbcmptlevel
Mark as solution if it anwer your question....