SQL Server Performance Forum – Threads Archive
MASTER compatibility level after upgradeI finished a SQL2000 to SQL2005 (in the same server) upgrade, but I noticed that my MASTER database is still in SQL2000 compatibilty level.
MSDB, MODEL and TEMPDB are in SQL2005 level. Is there any special reason to upgrade process didn’t set MASTER level?
Is there any problem if I change this? Thanks.
http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.
Yep, that’s by design !
You’ll have to use e.g.
— generate upgrade db_level to ss2005 (90)
select ‘Exec sp_dbcmptlevel @dbname = ”’ + name + ”’ , @new_cmptlevel = 90 ‘ + char(13) + ‘Go’
where compatibility_level <> 90
order by name to alter to sql2005 level. (only then will you sqlserver management studio provide reports. (for e.g. fileusage,…))