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

The topic describes the SA0093 analysis rule.

Message

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

Description

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.

How to fix

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

Scope

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

Parameters

Rule has no parameters.

Remarks

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

Effort To Fix
1 hour per issue.
Categories

Maintenance Rules, Bugs

Additional Information
See Also

Other Resources