Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL log COMPATIBILITY_LEVEL Expand / Collapse
Author
Message
Posted Monday, December 14, 2009 11:39 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, March 30, 2013 6:06 AM
Points: 532, Visits: 224
Hi Experts,

I have recently installed Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) on Windows Server 2008

I am getting the following SQL log frequently

Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServerTempDB
Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServer

I have verified the COMPATIBILITY_LEVEL which is already set to 100 to these databases

Any solutions or suggestions?

Thanks in advance for your efforts in this matter

Jagadeesan

Post #834315
Posted Tuesday, December 15, 2009 1:14 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 8:54 AM
Points: 1,153, Visits: 4,620
jagadeesanpv (12/14/2009)
Hi Experts,

I have recently installed Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) on Windows Server 2008

I am getting the following SQL log frequently

Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServerTempDB
Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServer

I have verified the COMPATIBILITY_LEVEL which is already set to 100 to these databases

Any solutions or suggestions?

Thanks in advance for your efforts in this matter

Jagadeesan




Hi,
See the MS link this was known bug

Setting database option Compatibility_Level to 100 for ReportServer


Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #834331
Posted Friday, September 14, 2012 5:12 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 17, 2013 3:27 PM
Points: 481, Visits: 782
Rather than put forth a new question I thought I would bump someones else s old post to the front of the line - a cosmopolitan SQL Server 2008 problem that been languishing unsolved for almost three years now.

Having thousands of these report sever compatibility entries ("Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServer") clutter up the event logs is annoying to no end.

Any new workarounds for this?
Post #1359734
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse