April 6, 2009 at 4:17 pm
Hai
Can we change master db compativity level from 90 to 80
April 6, 2009 at 4:49 pm
No, and why would you want to. The master contains information specific to the operation of a 2005 server.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
April 6, 2009 at 7:02 pm
Joseph (4/6/2009)
HaiCan 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
thanks Steve... could you tell me the reason for cannot changing back to 80.
April 6, 2009 at 9:34 pm
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
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
April 7, 2009 at 7:33 am
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
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.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
April 7, 2009 at 9:27 am
Thanks Steve..thanks much...
April 7, 2009 at 9:31 am
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
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
April 7, 2009 at 9:38 am
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