I am having a problem with replicating a table, and I finally tracked it down to a consistency error on the source table, but I am stumped as to what is causing the consistency error.
I ran DBCC Checkdb and found the following error on the table
Msg 2570, Level 16, State 3, Line 1 Page (1:5217772), slot 16 in object ID 1038014829, index ID 1, partition ID 349502316544000, alloc unit ID 349502316544000 (type "In-row data"). Column "MHGPTX" value is out of range for data type "varchar". Update column to a legal value.
I used DBCC PAGE to what row within the table was causing the problem, and tracked down the offending row.
Slot 16 Column 6 Offset 0x28 Length 150
MHGPTX = [Error converting to string (length 150 bytes)]
This is where I got stuck, the data in the field looks fine, the data is well under the max size for the column, I can query the row, etc.
I found a few references online to similiar problems, where the problem was resolved by updating the row using the same data, so I tried that, but with no change.
Any advice would be greatly appreciated