December 14, 2009 at 11:39 pm
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
December 15, 2009 at 1:14 am
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
https://www.sqlserverblogforum.com/
September 14, 2012 at 5:12 pm
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?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply