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

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

The rule checks the compatibility mode 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 mode, you can test the impact and consider updating it.

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

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