Master compatibility level - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Master compatibility level

Author

Topic

CanadaDBA

583 Posts

Posted - 2008-05-28 : 09:14:16

I installed SQL 2K5 (not upgrade from 2K) and just found that Master DB comp. level is 80. All other system DBs are 90.

1. How can I change master's to 90? Does the following work?


EXEC SP_DBCMPTLEVEL Master, 90;
go

2. Changing this, is there any possibility to impact my production?

Canada DBA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-28 : 12:44:36

Yikes. I'd open a case with Microsoft on this as this is most likely a bug and therefore a free call to them. I wouldn't make this change in a production environment without MS' involvement.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

CanadaDBA

583 Posts

Posted - 2008-05-28 : 15:55:32

AS an FYI, the SQL version is 9.0.3054.

Canada DBA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-28 : 18:48:07

Did you post your question on multiple forums? I see that someone who I don't believe frequents this site posted your issue to the private MVP newsgroup. No replies to the post yet.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

CanadaDBA

583 Posts

Posted - 2008-06-18 : 09:08:31

Yes, I posted the issue on SQL-Server-Performance as well and their moderator told me he posted the issue there. I haven't hear from him too.

I asked the application vendor's oponion about compatibility level and they say it doesn't matter with their application and there would be no impact. Is it suggested to fix it during business hours?

Canada DBA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-18 : 12:45:45

The MVP post didn't get answered.

I'd contact MS if I were you.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources