Cannot drop tables

• dok71

  SSC Enthusiast

  Points: 153

  More actions

  October 9, 2002 at 4:45 am

  #58126

  I need some help with an old SQL 6.5 database that I have inherited.

  There are 5 tables that are consuming quite a bit of space and are obsolete.

  When I go to drop these tables I get the following error

  "Error 1117 : Extent Chain for object 503138475 is not correctly linked"

  I have tried a dbcc dbreindex and a dbcc showcontig but to no avail.

  Anyone got any ideas

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  October 9, 2002 at 9:09 am

  #438170

  I think you need to run DBCC CHECKTABLE against those tables to see whether you receive any error message.