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.
| Author |
Topic |
|
tcarnahan
Starting Member
23 Posts |
 Posted - 2011-08-31 : 12:35:40
|
| I am running a prototype of our production environment in Development and have been asked to scout out the problems we would have doing a conversion from SS2K to SS2K8.I ran the SS "Best Practices" wizard and the "Upgrade Advisor". Then I went to change the compatibility from 2000 to 2008. In the Object Explorer, I selected the database, right-clicked and selected Properties, then selected Options. In the Compatibility List Box, only SS2k and SS7 were listed! Does anyone have an idea how I would get SS2K8 to be one of the options?Thanks ahead of time for any help you can offer!-- Tom |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-31 : 12:45:02
|
| In the query editor:ALTER DATABASE databaseNameHere SET COMPATIBILITY_LEVEL = 100; |
 |
|
|
manju3606
Yak Posting Veteran
78 Posts |
Posted - 2011-08-31 : 12:45:54
|
| Run sp_dbcmptlevel 100. Then check compatibility list box you will get ss2k8 in listManju |
|
|
|
tcarnahan
Starting Member
23 Posts |
Posted - 2011-09-01 : 08:24:46
|
quote:
Originally posted by russell
In the query editor:ALTER DATABASE databaseNameHere SET COMPATIBILITY_LEVEL = 100;
I tried this and got an error. |
|
|
|
tcarnahan
Starting Member
23 Posts |
Posted - 2011-09-01 : 08:27:16
|
quote:
Originally posted by manju3606
Run sp_dbcmptlevel 100. Then check compatibility list box you will get ss2k8 in listManju
I also tried this and it told me that only compatibility levels 70 and 80 were available.When I went into the object browser, selected the database, right clicked and selected Properties\Options, the Compatibility Level drop-down only offers SQL 2000 and SQL 7. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-09-01 : 10:28:56
|
| You doing this on the SQL 2000 box, or the new SQL 2008 box? It needs to be at the SQL 2008 end.List of other things you should consider during the upgrade here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230&SearchTerms=sql2008,hint |
|
|
|
tcarnahan
Starting Member
23 Posts |
Posted - 2011-09-01 : 10:46:27
|
quote:
Originally posted by Kristen
You doing this on the SQL 2000 box, or the new SQL 2008 box? It needs to be at the SQL 2008 end.List of other things you should consider during the upgrade here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230&SearchTerms=sql2008,hint
I did a check of @@Version and I think they installed SSMS2008, but the database engine is 2000. Thanks for your help! |
|
|
|
|
|
|
|
|
Convert from SS2K to SS2K8 -- Having problem chang