June 21, 2008 at 6:07 am
Hello folks,
Is it necessary to restart SQL Server after changing the master databases compatibility mode to 90?
Thanks,
Joanna
June 21, 2008 at 6:43 am
why is the master db not compability mode 90 anyhow?
Gethyn Elliswww.gethynellis.com
June 21, 2008 at 8:52 am
No, you don't need to cycle SQL Server.
Ellis, when you perform an upgrade from SQL Server 2000 to 2005, and there are custom objects in the master database - the upgrade will set the compatibility mode of the master database to 80.
Jeff
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
June 21, 2008 at 8:57 am
thanks jeff
Gethyn Elliswww.gethynellis.com
June 21, 2008 at 8:59 am
I don't think so its needed! Why your master database in older compatibility level?? Have you upgraded SQL Server to SQL 2005??
Regards..Vidhya Sagar
SQL-Articles
June 21, 2008 at 7:48 pm
Yes exactly - it is because we upgraded from 2000 to 2005.
Thanks all for your help.
Joanna
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply