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.

Details
Product: SQL Server
Event ID: 2570
Source: MSSQLServer
Version: 9.0
Component: SQLEngine
Symbolic Name: DBCC_COLUMN_VALUE_OUT_OF_RANGE
Message: 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.
   
Explanation

The column value that is contained in the specified column is outside the range of possible values for the column data type.

   
User Action

The error is not repairable. Update the column to a value within the range for the data type of the column and run the command again.

Related:

Leave a Reply