Error 2506

Severity Level 16

Message Text

Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=%ld row#=%d); check adjust table in this row

Explanation

This error occurs when SQL Server detects an inconsistency in the storage of the variable columns of a row and a page. This can happen after a fast bcp operation that involves many variable-length columns.

Action

Follow these steps:

Note The select into/bulkcopy option is set to true for the database.

1. Save the index/trigger/constraint definitions for the problem table. You will need to re-create them later.
2. Select the data from the problem table into a new one:

   select * into new_table from problem_table

3. Drop the problem table:

   drop table problem_table

4. Rename the new table, giving it the problem table's name:

   sp_rename new_table, problem_table

5. If applicable, re-create the indexes and triggers.

If the problem persists, contact your primary support provider.