Post reply

ALTER DATABASE

  • November 13, 2009 at 9:44 am

    #385789

    Does anyone have any idea why the following two command run on Reporting Services service startup AND at 12 intervals, daily?

    ALTER DATABASE [ReportServer] SET COMPATIBILITY_LEVEL = 100

    ALTER DATABASE [ReportServerTempDB] SET COMPATIBILITY_LEVEL = 100

  • November 13, 2009 at 11:50 am

    #1079168

    I was unaware of that.. Reporting services is doing it? If so my guess would be that it is so important for it to be at the SQL 2008 compat level that it wants to be sure..

    CEWII

  • November 14, 2009 at 1:17 pm

    #1079395

    Elliott W (11/13/2009)

    I was unaware of that.. Reporting services is doing it? If so my guess would be that it is so important for it to be at the SQL 2008 compat level that it wants to be sure..

    CEWII

    There is no reason for such task because if the upgrade is performed per the Microsoft provided guide most upgrades works as expected without issues.

    Kind regards,
    Gift Peddie

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply