Operational Defect Database
BugZero found this defect 249 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 2606680
Fixes the following error 2570 that you encounter when you run DBCC CHECKDB against a database, which is caused by using negative parameters in the RANDOM function against a column that uses dynamic data masking (DDM): Msg 2570, Level 16, State 3, Line <LineNumber> Page (<PageID>), slot <SlotID> in object ID <ObjectID>, index ID <IndexID>, partition ID <PartitionID>, alloc unit ID <UnitID> (type "<Type>"). Column "<ColumnName>" value is out of range for data type "<DataType>". Update column to a legal value.
Last update date:
9/14/2023
Affected products:
SQL Server 2022 on Linux
SQL Server 2022 on Windows
Affected releases:
build lower than 16.0.4075.1
Fixed releases:
16.0.4075.1
Description:
Fixes the following error 2570 that you encounter when you run DBCC CHECKDB against a database, which is caused by using negative parameters in the RANDOM function against a column that uses dynamic data masking (DDM): Msg 2570, Level 16, State 3, Line <LineNumber> Page (<PageID>), slot <SlotID> in object ID <ObjectID>, index ID <IndexID>, partition ID <PartitionID>, alloc unit ID <UnitID> (type "<Type>"). Column "<ColumnName>" value is out of range for data type "<DataType>". Update column to a legal value.
