Post reply

what are the comands need to excute after changing the compatability level?

  • July 13, 2010 at 11:22 pm

    #143998

    i have to change the database compatibility level to 90 from 80.

    what are the comands need to excute after changing the compatability level?

  • July 13, 2010 at 11:48 pm

    #1192547

    There aren't any commands that you need to run after it.

    You could run update stats and a backup, but they aren't required.

    Tara Kizer
    Microsoft MVP for Windows Server System - SQL Server
    Ramblings of a DBA (My SQL Server Blog)[/url]
    Subscribe to my blog

  • July 13, 2010 at 11:54 pm

    #1192550

    thanks Tara.

  • July 13, 2010 at 11:55 pm

    #1192551

    Nothing particularly required.

    You would need to ensure that all of your code is SQL 2005 compliant but there is no single command for that. You should run the upgrade advisor from SQL 2005 setup to determine if the database is good to go.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • July 14, 2010 at 11:52 am

    #1193019

    Hi

    Just change the compatibility mode. Nothing else is required.

    Best Regards,

    SQLBuddy

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

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