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

The topic describes the SA0084 analysis rule.


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.

How to fix

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.

Effort To Fix
13 minutes per issue.

Maintenance Rules, Code Smells

Additional Information

There is no additional info for this rule.

See Also

Other Resources