Erwin Bierens

Sharing Knowledge

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 Product Database Engine Version Default Compatibility Level Designation Supported Compatibility Level Values SQL Server 2019 (15.