Running DBCC Checktable on one of my tables causes several errors:
> Msg 2570, Level 16, State 3, Line 1 errors, Page (1:442), slot 1 in
> object ID 565577053, index ID 0, partition ID 72057594041270272, alloc
> unit ID 72057594046906368 (type "In-row data"). Column "XXXX" value is
> out of range for data type "decimal". Update column to a legal value.
Column XXXX is Decimal (18,4)
I've done some investigation suggested by:
1)
SELECT XXXX FROM Table
WHERE XXXX > 99999999999999.9999
OR XXXX < -99999999999999.9999
This is not returning any rows
2)
DBCC TRACEON ( 3604 )
DBCC PAGE ( Database, 1 , 442, 3 )
I found entry with XXXX = INVALID COLUMN VALUE
I found primary key values for it
And when I run:
Select XXXX from Table where ID = ValueFound
It returns -0.4500 - valid value for Decimal (18,4).
Is this value correct or is this some random value?
Do I understand it correctly - the only way to fix this is to provide correct values for given fieds?
Asked by Andrzej Błoch
(313 rep)
May 28, 2020, 04:14 PM
Last activity: Jun 3, 2025, 06:03 AM
Last activity: Jun 3, 2025, 06:03 AM