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?

What is the SQL-Server Version u r working on ??

Mohit S
– Mohit S

2015-08-25 08:27:45 +00:00
Commented Aug 25, 2015 at 8:27 — Mohit S
– Mohit S, Commented Aug 25, 2015 at 8:27
I am Working On SQL Server 2005

Jason Clark
– Jason Clark

2015-08-25 08:29:21 +00:00
Commented Aug 25, 2015 at 8:29 — Jason Clark
– Jason Clark, Commented Aug 25, 2015 at 8:29

Roman Marusyk · Accepted Answer · 2015-08-25 08:31:38Z

3

For SQL SERVER – 2005 try to use:

EXEC sp_dbcmptlevel AdventureWorks, 80;
GO

More details

answered Aug 25, 2015 at 8:31

Roman Marusyk

24.8k27 gold badges83 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mohit S · Accepted Answer · 2015-08-25 08:33:27Z

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

answered Aug 25, 2015 at 8:33

Mohit S

14.1k6 gold badges36 silver badges73 bronze badges

Collectives™ on Stack Overflow

syntax error on SQL Server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related