Error 2507

Severity Level 16

Message Text

Table Corrupt: Offset table is incorrect (page#=%ld row#=%d offset in offset table is=%d correct offset  is=%d)

Explanation

SQL Server detects an error in the internal structure that contains the data.

Action

Run dbcc checkdb and DBCC newalloc to make sure there are not more serious problems in the database. This problem can usually be resolved by selecting into (SELECT INTO) from this table into another table. As a precaution, dump your database before following the steps below:

1. Use the object number reported by DBCC checkalloc or DBCC newalloc to determine which table is involved. For example:

   select object_name(object id)

2. Check that the select into/bulkcopy option is set to true for the database.
3. Copy the table into a new table:

   select * into newname from problem table

4. Run dbcc checktable(newname) to ensure there are no problems with the new table.
5. Drop the old table:

   drop table problem table

6. Rename the new table using the old table name:

   sp_rename newname,oldname

This error has sometimes been traced to problems with the disk I/O system. If you persistently run into this problem, run diagnostics on the system and contact your primary support provider.