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-05-07 : 05:00:15
|
| i have a server which is configured with sql 2005 and when i schedule a backup all the databases do not get listed while selecting (all databases) while scheduling ...then i found that there are some databases with the cmpt level 70 and those databases do not get listed while scheduling backup,, is there any solution for this ... how to change the cmpt level.. from 70 to 90, is there any precautions i need to take care ....is it possible to do the above...pls help |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-05-07 : 10:31:11
|
There are plenty of precautions to take, but these mainly deal with how the stored procedures are written. If you ahve a test database you can run sp_dbcmptlevel databasename, 90 and test out how the application(s) react to the change. As far as I know, this is not a permanent setting, and can be reversed. |
 |
|
|
|
|
|
upgrade from sql 7.0 to 2005