Post reply

Database Compatibility Level

  • August 10, 2010 at 2:53 am

    #225268

    Hello,

    I wondered if anyone out there could share some wisdom in regards to DB compatibility levels.

    I have a few databases on level 80 on SQL 2005, and I think it would be more consistent to change them to 90. Is there any specific issues I need to look out for before doing this, and is it a reversable action should things not run smoothly afterwards (meaning problems are noticed a few days later). I would of course take a backup beforehand, but that will only be useful if things go wrong right after the change.

    Thank you.

    Regards,

    D.

  • August 10, 2010 at 3:18 am

    #1204575

    Duran (8/10/2010)

    Hello,

    I wondered if anyone out there could share some wisdom in regards to DB compatibility levels.

    I have a few databases on level 80 on SQL 2005, and I think it would be more consistent to change them to 90. Is there any specific issues I need to look out for before doing this, and is it a reversable action should things not run smoothly afterwards (meaning problems are noticed a few days later). I would of course take a backup beforehand, but that will only be useful if things go wrong right after the change.

    Thank you.

    Regards,

    D.

    Click following link

    ALTER DATABASE Compatibility Level

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • August 10, 2010 at 3:57 am

    #1204593

    That's perfect, thank you.

    Regards,

    D.

  • August 10, 2010 at 4:08 am

    #1204597

    Duran (8/10/2010)

    That's perfect, thank you.

    Regards,

    D.

    Ur welcome.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

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

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