Understood but in my case the repair did not fix the problem.

BTW I found your posts very helpful, thank you

You right click the database and select generate scripts.

You right click the database in question and script it out. There is an advanced tab and in there you can have it create the indexes and keys as...

It sounds like you Index Allocation Map chains are broken. You may not have lost any data but your index/keys are corrupt. I had the same issue so...