Month: December 2018

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.            2. By running below SQL you can get the compatibility level

SQL Server Compatibility level will be used to decide how SQL will use it features. By setting compatibility level will make sure that SQL will follow that particular compatibility level version. It is a database property and will only affects the features for that particular database. For example with SQL 2014 or higher the new