Corrupt Table, Cant Delete, Truncate ...
Posted on 2006-07-06
I have a SQL Server 2000 Table that seems to be corrupt.
I first noticed this when attempting to Delete all records from the table. The operation ran for 8 min without completing. I then tried:
Delete using EM Console
All of these operations will run for several minutes without completing. I have a current backup of that table that works fine, but I need to get rid of the current one first. I have never encountered this issue before. Can someone lend a hand.