How to drop corrupt table in sql server 2000

• su_kumar11

  SSCommitted

  Points: 1675

  More actions

  November 14, 2008 at 10:08 pm

  #94339

  Hi,

  Can anyone tell how to drop a coorupt table in sql server 2000?

  Thanks

  Sunil

• John H Marsh

  SSChampion

  Points: 11671

  More actions

  November 15, 2008 at 3:35 am

  #898964

  Hello,

  Did you already run a DBCC CHECKTABLE on the corrupt table?

  Are there any dependencies on the table that need to be dropped first?

  Assuming not, then what error do you get when you execute the Drop Table command?

  Regards,

  John Marsh

  www.sql.lu
  SQL Server Luxembourg User Group