How To Find SQL Server Database Compatibility Level

dbtut

5 years ago

In this article I will share the information of finding database compatibility level. If may want to read more about SQL Server Compatilibility Level, you can use the following link.

“What is SQL Server Database Compatibility Level and How To Change Database Compatibility Level”

You can use SSMS to learn the database compatibility level:

Right Click on database and click properties.

You can see the database compatibility level from options tab as below.

Or you can query your database compatibility level with the below script.

USE Your_Database_Name; 
GO 
SELECT compatibility_level 
FROM sys.databases WHERE name = 'Your_Database_Name'; 
GO

USE Your_Database_Name;

SELECT compatibility_level

FROM sys.databases WHERE name = 'Your_Database_Name';