Changing DB "Compatibility Level"?

Discussion in 'Databases' started by imgodot, Jun 11, 2012.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. imgodot

    imgodot

    Is there any way to change the compatibility level for an SQL 2008 database to be compatible with SQL 2000.

    We have a legacy DB we want to move to SQL 2008 before we cleanup all the non-ansii SPs, etc.

    Thanks.
     
    imgodot, Jun 11, 2012
    #1
  2. JorgeR

    JorgeR DiscountASP.NET Staff

    ALTER DATABASE <dbname>
    SET COMPATIBILITY_LEVEL = 80;
    GO
     
    JorgeR, Jun 11, 2012
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page