SQL log COMPATIBILITY_LEVEL

  • 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

  • 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/

  • 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