Error 2504 Server Table Corrupt

I have a table which I am unable to drop, remove indexes from, and when I select the database from the EM and click on Recalculate get the following error:

When attempting to do a Recalculate from the EM I get: Error 2541 (SQL Server) Table Corrupt object id does not match between extent in allocation page a d sysindexes; check the following extent; alloc pg# 589050 extent# 589096 object id on extent=0 object name=0 object id in sysindexes=1420532094 (object name=MifDEtailOct)

When attempting to remove an index from the table I get: Error 2504 (SQL Server) Table Corrupt index id in alloc page does not match the index id in sysindexes (alloc page#=721664; extentid=721704; index id in alloc=5;index id in sysindexes = 4

When attempting to drop the table from the EM it disappears then when I do a refresh it's back again.

I run a checkdb on the database once a week, but that hasn't resolved the problem.

I also ran the sp_fixindex as outlined in the faq with no relief.

This initially happened on one table and now I'm getting the same error on a second table. I have removed the data from both tables, but can't seem to get rid of them.

These tables originally has a couple of million records in them so they were rather large before I moved the data to a new table.

Truncate also didn't work when I was attempting to clear the table. I had to create an sp to delete a few hundred thousand records at a time.

I would appreciate any suggestions.

Rick Poland
rpolan1@tandy.com