Results 1 to 3 of 3

Thread: sql2005 upgrade queston

  1. 11-30-2006, 03:35 PM #1
    ezecastle
    ezecastle is offline Registered User
    Join Date
    Aug 2004
    Posts
    188

    sql2005 upgrade queston

    Hi guys,

    I have done an in-place upgrade of a SQL2000 server to SQL2005 Ent. The upgrade was very smooth for the most part but when I check the versions of my databases they still say 8.0 and not 9.0. I'm able to change them to be 9.0 but I'm wondering why they were not changed automatically during the upgrade process? Any ides or is this something I have to be aware of for future upgrades?

    Thanks for your time.
    Reply With Quote Reply With Quote
  2. 11-30-2006, 04:09 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Upgrading will not modify compatibility level since it doesn't know if your app supports new features or not.
    Reply With Quote Reply With Quote
  3. 11-30-2006, 04:16 PM #3
    ezecastle
    ezecastle is offline Registered User
    Join Date
    Aug 2004
    Posts
    188
    Ok sounds good. I will keep that in mind. Thanks.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules