December 29, 2018
View Compatibility level of Database
To know what is compatibility Level check this post link.
You can view the compatibility of SQL Server Database in two ways.
- From SSMS.
Open SSMS -> Right click on Database -> Click properties -> Click on Options tab.
![Compatibility Level SSMS](https://sqlag.com/wp-content/uploads/2018/12/Compatibility-Level-SSMS.jpg)
2. By running below SQL you can get the compatibility level of Database :
SELECT name, compatibility_level FROM sys.databases;
![Compatibility level SQL](https://sqlag.com/wp-content/uploads/2018/12/Compatibility-level-SQL.jpg)
Check the next post to see how to alter database compatibility level.
2,730 total views, 2 views today