 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / August 2008Alter database compatibility_level
I copied this command straight from the books on line and executed it in sql 2005 9.0.3068 ALTER DATABASE AdventureWorks SET COMPATIBILITY_LEVEL = 90; GO And I get this message… Msg 102, Level 15, State 1, Line 2 Incorrect syntax near '90'. Any body else get this error? What is the correct syntax? The manual shows: ALTER DATABASE database_name SET COMPATIBILITY_LEVEL = { 80 | 90 | 100 } Hi Use sp_dbcmptlevel EXEC dbo.sp_dbcmptlevel @dbname=N'SQLH2Repository', @new_cmptlevel=90 vinu http://oneplace4sql.blogspot.com/ >I copied this command straight from the books on line and executed it in >sql [quoted text clipped - 11 lines] > ALTER DATABASE database_name > SET COMPATIBILITY_LEVEL = { 80 | 90 | 100 } You were reading books online for 2008. Prior to that, you need to use sp_dbcmptlevel, as suggested by vinu.  SignatureTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi >I copied this command straight from the books on line and executed it in sql > 2005 9.0.3068 [quoted text clipped - 10 lines] > ALTER DATABASE database_name > SET COMPATIBILITY_LEVEL = { 80 | 90 | 100 } Like, totally embarrassed... > You were reading books online for 2008. Prior to that, you need to use sp_dbcmptlevel, as suggested > by vinu. [quoted text clipped - 13 lines] > > ALTER DATABASE database_name > > SET COMPATIBILITY_LEVEL = { 80 | 90 | 100 } Happens to all of us. I for instance did the very same thing the other day, and it was just compatibility level I tried (on 2005 using ALTER DATABASE). :-) SignatureTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi > Like, totally embarrassed... > [quoted text clipped - 16 lines] >> > ALTER DATABASE database_name >> > SET COMPATIBILITY_LEVEL = { 80 | 90 | 100 } |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.