Table Corrupt: Object id wrong; tables: alloc page %ld extent id=%ld l page#=%ld objid in ext=%ld (name = %.*s) objid in page=%ld (name = %.*s) objid in sysindexes=%ld (name = %.*s)
The DBCC CHECKALLOC statement detected one of the following errors:
Note Occasionally DBCC CHECKALLOC reports this error when no real error condition exists. Run DBCC CHECKALLOC in single-user mode if you suspect that the 2525 error message is incorrect.
Compare objid in ext to objid in page, and then carry out one of the following procedures, depending on whether the object IDs matched.
Caution If you drop an object before you correct the 2525 error condition, the drop operation could cause pages belonging to another object to be deallocated, causing error 1108.
If the object IDs don't match, restore the database from a known clean backup.
If the object IDs match, the pointer to a distribution page for a particular index is probably invalid.
To correct the problem:
use database_name go select indid, name, object_name(id) from sysindexes where id = objid_in_sysindexes and distribution = l_page_# go
If this query does not return any rows, contact your primary support provider.