2570

Product

Name

Event ID

2570

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

DBCC_COLUMN_VALUE_OUT_OF_RANGE

Message

Text

Page P_ID, slot S_ID in object ID O_ID, index ID I_ID, partition ID PN_ID, alloc unit ID A_ID

(type TYPE). Column COLUMN_NAME value is out of range for data type “DATATYPE”.

Update column to a legal value.

The column value that’s contained in the specified column is outside the range of possible

values for the column data type. If you have invalid data in a table column, you might

encounter problems, depending on the type of operations performed against the invalid data.

However, it’s also possible that no problem will appear, and the invalid data won’t be

discovered until you execute a

or

command.

Some symptoms you may notice due to the presence of invalid data include (but aren’t limited

to):

Access violations or other exceptions when executing queries against the affected

column.

Incorrect results returned by queries executed against the affected column.

Errors or problems when statistics are being built against the affected column.

Error messages like the following one:

ﾉ

Expand table

DBCC CHECKDB
DBCC CHECKTABLE