Is Compatibility Level Data Persisted in SQL Server?
Information regarding the Compatibility Level of a database in SQL Server is not persisted in the SQL Server system.
According to the Microsoft documentation, the list of supported Compatibility Level values is specific to each SQL Server version.
The following table lists the supported Compatibility Level values for each SQL Server version:
| SQL Server Version | Supported Compatibility Level Values |
|---|---|
| 2012 | 80, 90, 100, 110, 120, 130 |
| 2014 | 80, 90, 100, 110, 120, 130 |
| 2016 | 90, 100, 110, 120, 130, 140 |
| 2017 | 90, 100, 110, 120, 130, 140, 150 |
| 2019 | 100, 110, 120, 130, 140, 150, 160 |
The information regarding the Compatibility Level of a SQL Server database is not stored in the Windows registry.