Click or drag to resize

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

The topic describes the SA0093 analysis rule.

Message

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

Description

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.

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.

Categories

Maintenance Rules

Additional Information
See Also

Other Resources