syntax error on SQL Server

Question

I'm receiving this error:

Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '90'.

when i tried to compile this t-sql:

ALTER DATABASE SGCT SET compatibility_level = 90

Does anyone know why?

Answer 1

Sets certain database behaviors to be compatible with the specified version of SQL Server. You are already using 2005 and 90 is to set for 2005. If you need to do a backward COMPATIBILITY

You should try this.

ALTER DATABASE SGCT 
SET COMPATIBILITY_LEVEL = 80;
GO

Answer 2

For SQL SERVER – 2005 try to use:

EXEC sp_dbcmptlevel AdventureWorks, 80;
GO

More details