September 27, 2001 at 10:33 pm
How do I drop a corrupt table from my database. I am using SQL Server 7.0 and Enterprise Manager doesnt allow to delete it. I've run dbcc checktable and received sql errors 7930 and 2511.
September 28, 2001 at 9:32 am
You may want to run a SP_RESETSTATUS to change it to a fine status, then DROP DATABASE. You can also place it in "emergency mode" if that fails.
Brian Knight
http://www.sqlservercentral.com/columnists/bknight
Brian Knight
Free SQL Server Training Webinars
September 28, 2001 at 9:55 am
you my also run a dbcc with dataloss and it should bring the tables back to a useable state. I think 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply