Just upgraded (server in place) from Standard Edition SS2K to SS2K5 and table sysdatabases shows cmptlevel for master is 80. TempDB, MSdb and Model are at 90. How does this get changed and why is it 80 I can change user databases from 80 to 90. Thanks......
When (how) does Compatibility level for master change to 90?
Javier_Mexico
When server is upgraded to SS2K5, the master database retains its existing compatibility level, in this case it is 80 since the upgrade occurred from from SS2K. The compatibility level of master database cannot be modified. (For details see BOL topic on sp_dbcmptlevel).
Billzz
< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Thank you for your time and the info. I just ran the sp_dbcmptlevel and changed the MASTER database compatibility level to 90 (select name, cmptlevel from sysdatabases) since this is now SS2K5 and restarted the server.
What are the behavior effects of SS2K5 of switching the MASTER's compatibility level back and forth On the Optimizer On the Storage Engine Shouldn't this be locked down Thanks again for your time.
If MASTER was not changed when would it be changed I am confused.