December 26, 2010 at 11:22 pm
after you perform an in-place upgrade of a SQL Server 2000 server to SQL Server 2005 server, the compatibility level of MASTER database?
December 27, 2010 at 12:09 am
Per Books On Line for SQL 2008 (http://msdn.microsoft.com/en-us/library/bb933942(v=SQL.105).aspx),
The tempdb, model, msdb and Resource databases are all set to the new compatibility level (100 for SQL 2008).
The master database however, remains on the previous compatibility level; unless it was less than 80 (SQL 2000). If less than 80, it is reset to 80.
I believe the behaviour should not be any different for SQL2005. Please note that you can always change the compatibility level to one of the supported values after the upgrade.
I found the following forum entry that describes a similar experience: http://social.msdn.microsoft.com/forums/en-us/sqldatabaseengine/thread/00FB3CB7-526C-4F7B-9277-AEBEAD30FED3
Hope that resolves your query.
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply