SA0093 : The compatibility level of the database is lower than the SQL Server version default compatibility level

The compatibility level of the database is lower than the SQL Server version default compatibility level

The rule checks the compatibility level of the current database and compares it to the current level of the hosting SQL Server instance.

If you are not sure why this database is running in a lower compatibility level, you can test the impact and consider updating it.

If the you are running a database at a lower compatibility level than the SQL Server instance, this may cause certain features of SQL Server to be unavailable or to function unpredictably, or to perform poorly.

Consider increasing the compatibility level of the current database to the compatibility level of the SQL Server instance.

The rule has a ContextOnly scope and is applied only on current server and database schema.

Rule has no parameters.

The rule requires Analysis Context. If context is missing, the rule will be skipped during analysis.

Maintenance Rules, Bugs

ALTER DATABASE Compatibility Level

Other Resources