I have a database with a corrupt table and no matter what I do (dbcc's and rebuilding indexes), there are row fetch errors still occurring daily. My solution now is just to drop the table and recreate it.
Is it as simple as copying the data out of the original table, dropping the original table, and recreating the original table? What about the pointers to other pages? Referential integrety? Please give me a good reference for this subject or let me know. Thank you?