Data Purity Checks
The Data Purity setting in SQL Server is an option for the DBCC CHECKDB command. Adding the DATA_PURITY option causes the CHECKDB command to check for column values that are invalid or out of range1. Any database created in SQL Server 2005 or later will include the DATA_PURITY check by default.
DBCC CHECKDB WITH DATA_PURITY.
For databases upgraded from earlier versions of SQL Server, column-value checks aren't 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.
How to Enabled CHECKDB with Data Purity
USE [WhippetWorks]; GO DBCC CHECKDB WITH DATA_PURITY;
DBCC CHECKDB (Transact-SQL) | Microsoft Learn
Troubleshooting DBCC error 2570 in SQL Server 2005 and later versions | Microsoft Learn