Compatibility level

Question

Post reply

Compatibility level

durga.misra

Valued Member

Points: 58
More actions
April 18, 2009 at 1:32 am

#155580

How can i change compatibility level from 80 to 90

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

ALTER DATABASE <database_name >

SET COMPATIBILITY_LEVEL 90

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

durga.misra Valued Member Points: 58 More actions · Answer 2

Thanks for reply

but i am getting error

Incorrect syntax near '90'.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Sorry, left out an =

ALTER DATABASE <database_name >

SET COMPATIBILITY_LEVEL = 90

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

durga.misra Valued Member Points: 58 More actions · Answer 4

still i am getting this error

Incorrect syntax near '='.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Works fine for me.

Exactly what command are you typing? (note that the <Database name> is just a placeholder for the name of the DB that you're changing.)

What does SELECT @@Version return?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

durga.misra Valued Member Points: 58 More actions · Answer 6

i am using this...

ALTER DATABASE build_system

SET COMPATIBILITY_LEVEL = 90

and

SELECT @@Version return

pls help me....

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

You've got SQL 2000 there, not 2005. Compatibility level 90 is SQL 2005. The highest level that you can set a SQL 2000 server to is compatibility level 80.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

maechismo_8514 SSCoach Points: 17510 More actions · Answer 8

durga.misra (4/18/2009)
i am using this...
ALTER DATABASE build_system
SET COMPATIBILITY_LEVEL = 90
and
SELECT @@Version return
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
pls help me....

What compatibility level you want to change to ? and What are trying to accomplish here?

ab5sr SSCarpal Tunnel Points: 4056 More actions · Answer 9

I'd add some service packs as well while you figure this out 🙂