To know what is compatibility Level check this post link.
You can view the compatibility of SQL Server Database in two ways.
Open SSMS -> Right click on Database -> Click properties -> Click on Options tab.
2. By running below SQL you can get the compatibility level of Database :
SELECT name, compatibility_level FROM sys.databases;
Check the next post to see how to alter database compatibility level.
2,689 total views, 2 views today
The attribute value in Dimension table are going to change slowly over time and they…
Changing Database compatibility level will be required when you upgrade your database from one…
SQL Server Compatibility level will be used to decide how SQL will use it features.…
A view is a virtual table. View will not store any data physically. The data…
Below is the error which I was getting today while deploying the SSIS pacakge for…
Query store is a new powerful feature introduced in SQL 2016 which stores the query…