I upgraded sql2k to sql2k5. After upgradation I found that the databases are having compatibility level sql server 2000(80) in Management studio.But it should be '90'? So why this happened and how can I change it to compatibility 90.
The upgrade doesn't move these since you might need them in 80 mode. If you want to change to 90, then just change the option for the database in SSMS (database, properties).
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply