SQL Server Performance Forum – Threads Archive

MASTER compatibility level after upgrade

I 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.
Esio Nunes

---

http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
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’
from master.sys.databases
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,…))

---

]]>