Post reply

changing master db compativity level from 90 to 80

  • April 6, 2009 at 4:17 pm

    #136402

    Hai

    Can we change master db compativity level from 90 to 80

  • April 6, 2009 at 4:49 pm

    #972986

    No, and why would you want to. The master contains information specific to the operation of a 2005 server.

  • April 6, 2009 at 7:02 pm

    #973022

    Joseph (4/6/2009)

    Hai

    Can we change master db compativity level from 90 to 80

    Absolutely not. Why you want to try this anyway?

  • April 6, 2009 at 9:05 pm

    #973046

    thanks Steve... could you tell me the reason for cannot changing back to 80.

  • April 6, 2009 at 9:34 pm

    #973055

    Joseph (4/6/2009)

    thanks Steve... could you tell me the reason for cannot changing back to 80.

    Can you explain why you think you need to do this?

    FWIW - I would think it is possible, since it will be in 80 compatibility mode after an upgrade where you have user objects in the master database.

    Again, why do you think you need this? There really is no reason for this to be done on the master database.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • April 7, 2009 at 7:33 am

    #973339

    hi,

    it is becuase in case if we have to change back to 80. lets say if we have any user objects in the master db.

  • April 7, 2009 at 9:15 am

    #973493

    The master database controls the function of the server. It is not designed to emulate a SQL 2000 server, and all the structures in there will not necessarily work. It's by design.

    Note, you should not have used objects in master. If you do, you'll need to rewrite them to work with 2005.

  • April 7, 2009 at 9:27 am

    #973510

    Thanks Steve..thanks much...

  • April 7, 2009 at 9:31 am

    #973516

    The only reason the master database is not set to 90 compatibility during an upgrade is specifically when there are user objects in that database.

    In that case, the upgrade leaves the compatibility set to 80 so your user objects will still work. It is your responsibility at that point to make sure all user objects in the master database are compatible with 90 functionality.

    I am still wondering what you mean by going back to 80 - why would you need to go back? If your user objects don't work in 90 compatibility you need to fix them, not modify the compatibility level to get around fixing the problems.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • April 7, 2009 at 9:38 am

    #973527

    Thanks Jeff...it seems the picture is much clearer now...thanks again

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply