Post reply

REG compatability levels of a database

  • March 11, 2013 at 1:18 am

    #290857

    Recently i got new job. when i checked the production databases. some databases are in compatibility level 80 . some in 90 and some are in 100... i know that when they moved databases from previous versions to the new 2008r2 they have to change the compatibility level as-well . but they are in production for more than a year.. my question is can i change them to 100. does it any way going to affect the production.

  • March 11, 2013 at 3:11 am

    #1595415

    Maybe, maybe not.

    Does the app depend on some behaviour in a lower compat mode? Will the app break if you change the compat mode?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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