Post reply

Steps needed to consider while changing the sql server 2005 database instance compatability level from 80 to 90

  • October 13, 2008 at 4:02 am

    #125205

    I need to make list of all the possible challenges and changed that are needed to be done before converting database compatability level from 80 to 90.databse is on sql server 2005.

    Can any one help me out in this.

    thanxs in advance.....................

  • October 13, 2008 at 4:38 am

    #884058

    The sp_dbcmptlevel stored procedure affects behaviors only for the specified database, not for the entire server. sp_dbcmptlevel provides only partial backward compatibility with earlier versions of SQL Server. A database containing an indexed view cannot be changed to a compatibility level lower than 80.

    The best practice to change the compatibility level of database is in following three steps.

    Set the database to single user access mode by using

    ALTER DATABASE SET SINGLE_USER

    Change the compatibility level of the database.

    Put the database in multiuser access mode by using

    ALTER DATABASE SET MULTI_USER

  • October 13, 2008 at 11:36 pm

    #884411

    thanks, but could you be please provide me list of some more areas which i need to look or which might get affected by converting compatability lebel from 80 to 90 of sql server database instance.

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

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