aiDeeva.com

Tag: database Compatibility

  • Script to change the database compatibility level

    Use below script to change the database compatibility level

    ALTER DATABASE DatabaseName
    SET SINGLE_USER
    GO
    EXEC sp_dbcmptlevel DatabaseName, 90;
    GO
    ALTER DATABASE DatabaseName
    SET MULTI_USER
    GO

    SQL Server Version Compatibility Level
    SQL Server 6.5 65
    SQL Server 7.0 70
    SQL Server 2000 80
    SQL Server 2005 90
    SQL Server 2008 100