1

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: https://support.microsoft.com/en-us/help/923247/troubleshooting-dbcc-error-2570-in-sql-server-2005-and-later-versions

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?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.