Geting error to drop a table

• su_kumar11

  SSCommitted

  Points: 1675

  More actions

  November 13, 2008 at 11:37 pm

  #196352

  When I drop a table I get following error :

  Could not find the index entry for RID '16b72b4231100' in index page (1:17424), index ID 0, database 'Avon'.

  Please give me solution.

  Thanks,

  Sunil

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  November 14, 2008 at 2:59 am

  #898459

  Run DBCC CHECKTABLE to get more info about whatis wrong.

  Since you want to drop the table anyway you can also use the option REPAIR_ALLOW_DATA_LOSS

  [font="Verdana"]Markus Bohse[/font]