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 |
|
arunsqladmin
Yak Posting Veteran
74 Posts |
 Posted - 2008-08-26 : 05:29:07
|
| i have a server which is installed with sql 2005,now it has been restored with backupsets of sql 7.0, but the compatibility of few databases which was restored still remains as 70,can i directly change the cmptlevel to 90 or are there any other steps i need to take care |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-26 : 09:56:18
|
| Before you do that, you have to make sure your apps are not using any features supported in SQL 7.0 and not in SQL 2005. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
upgradation from sql 7.0 to 2005