How To Find SQL Server Database Compatibility Level


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.


Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *