SA0084 : Data purity check is not enabled for the current database

Data purity check is not enabled for the current database

The rule checks if data purity check is enabled for the current database.

For databases created in SQL Server 2005 and later, column-value integrity checks are enabled by default and do not require the DATA_PURITY option.

For databases upgraded from earlier versions of SQL Server, column-value checks are not enabled by default until DBCC CHECKDB WITH DATA_PURITY has been run error free on the database. After this, DBCC CHECKDB checks column-value integrity by default.

See DBCC CHECKDB command documentation for more details.

Execute `DBCC CHECKDB WITH DATA_PURITY` on the current database.

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, Code Smells

There is no additional info for this rule.

Other Resources