SQL Server 2005 delete corrupt table We are having a database in which one table name dbo.ONOA is corrupt. We need to delete this table. Please let me is there any way to force delete the table?
Have you used DBCC CHECKTABLE to see what the problem is? Check the REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD options to potentially repair the table. Database must be set in single user mode.