Change Compatibility Problem.,

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Change Compatibility Problem.,

Author

Topic

karthik_padbanaban
Constraint Violating Yak Guru

263 Posts

Posted - 2008-03-24 : 10:43:13

Hi All.,
How can I change the compatibility level in sql server 2005
to 90., It provides option only to 80., I changed multiuser to single user and I am using the server only but still it gives option only to 80., How can I change to 90 in this case,

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-03-24 : 10:48:01

[code]exec sp_dbcmptlevel 'db1', 90[/code]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

karthik_padbanaban
Constraint Violating Yak Guru

263 Posts

Posted - 2008-03-24 : 11:04:57

Sorry: I am getting this error msg while executing your above statement

Msg 15416, Level 16, State 1, Procedure sp_dbcmptlevel, Line 92
Usage: sp_dbcmptlevel [dbname [, compatibilitylevel]]

Valid values of database compatibility level are 60, 65, 70, or 80.

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-03-24 : 11:19:25

Are you really using SQL Server 2005?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-24 : 22:35:28

Double check sql version with 'select @@version'.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-24 : 23:11:31

you must post this question in 2000 forum. If not, backup database and restore in 2005 server.You can then change to 90 compatibility level.