Click or drag to resize

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

The topic describes the SA0084 analysis rule.

Message

Data purity check is not enabled for the current database

Description

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.

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

There is no additional info for this rule.

See Also

Other Resources