How to change compatibility level of a SQL Database

Get Compatibility level of databases

First start checking your version of SQL, start a new query.

    SELECT SERVERPROPERTY('ProductVersion');

Run Query

Now start a new query to check the compatibility level of the databases.

    SELECT name, compatibility_level FROM sys.databases;

Run Query

Set Compatibility level

Create a new query.

    ALTER DATABASE databasename
    SET COMPATIBILITY_LEVEL = 120

Run Query

Compatibility Levels

/