Issue- Migration

  • Hello folks,

    WE have just moved our databases from sql server 2000 to sql server 2005 about two weeks before. For that we stop our application for one day. Now they are there in SQL 2005 and working fine.

    But we just came to know that we forget to change the compatible mode from 80 to 90 for some of the databases..

    Now, We need to change our compatible mode from 80 to 90 for that databases. If we do that in our live environment then will it affect our application? Or else we need to stop application for that? I am new to sql server thus I need some guideline from u Gurus...Thanks in advance....

  • You can switch compatibility level on the fly without turning anything off. However, before you switch you should look for things that may break. There are gotchas. See sp_dbcmptlevel in BOL and http://www.sqlservercentral.com/Forums/Topic431723-146-1.aspx

    Hopefully, you checked before you converted everything else.

    You can switch back from 90 to 80 in a snap too.

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

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