Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server syntax error Expand / Collapse
Author
Message
Posted Wednesday, July 1, 2009 7:33 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, October 23, 2014 2:26 PM
Points: 752, Visits: 1,071
I'm receiving this error:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '90'.

when i trie to compile this t-sql:

ALTER DATABASE SGCT SET compatibility_level = 90


Does anyone know why?

thank you,

Pedro
Post #745375
Posted Wednesday, July 1, 2009 7:38 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:51 PM
Points: 527, Visits: 1,018
If this is SQL Server 2005 Try this:

USE [master]
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'Database_Name', @new_cmptlevel=90
GO
Post #745383
Posted Wednesday, July 1, 2009 7:39 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, May 9, 2013 8:07 AM
Points: 1,220, Visits: 2,614
The only thing that I can think of that would cause it may be a case sensativity issue. Try this and see if it works.


ALTER DATABASE [SGCT] SET COMPATIBILITY_LEVEL = 90


Ken Simmons
http://twitter.com/KenSimmons
Post #745386
Posted Wednesday, July 1, 2009 7:41 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, May 9, 2013 8:07 AM
Points: 1,220, Visits: 2,614
Kenneth Langner Jr. (7/1/2009)
If this is SQL Server 2005 Try this:

USE [master]
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'Database_Name', @new_cmptlevel=90
GO


That's right. I have been working with 2008 for too long.


Ken Simmons
http://twitter.com/KenSimmons
Post #745392
Posted Wednesday, July 1, 2009 8:43 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, October 23, 2014 2:26 PM
Points: 752, Visits: 1,071
this :

EXEC dbo.sp_dbcmptlevel @dbname=N'Database_Name', @new_cmptlevel=90


resolved the question.

thank you
Post #745465
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse