Steve Jones - SSC Editor (3/12/2013)
Corruption in the clustered index is likely a call to Microsoft. This is the data, and so you can't rebuild.If I had this, I'd try to BCP out the data from the table first, see if I could recover things. Likely the corruption is in certain pages, so if this doesn't work all at once, you may be able to find the ranges around the corruption and recover most data.
This is serious, and if you aren't sure of what is wrong, call Microsoft.
I'm dealing with nonclustered indexes at the moment. Asked the question about clustered ones as a hypothetical. Dropping the two indexes without recreating (they don't get used very much) allowed the failing SP to run. Would you recommend migrating the databases on this disk to a different drive?