Index corruption on table update

• Marco Figueiredo

  SSC Rookie

  Points: 26

  More actions

  May 20, 2004 at 8:30 am

  #87487

  I'm having problems with a non-clustered index.

  When I update a table based on a join query (between itself and another one), the non-clustered index of this updated table gets corrupted and no more updates are allowed. Have anyone seen this problem? Does it have a known solution?

  Thanks.

   

• Sureshkumar Ramakrishnan

  Ten Centuries

  Points: 1200

  More actions

  May 21, 2004 at 4:38 am

  #507247

  Recommend you to do DBCC UPDATEUSAGE on the indexes of the Table .This will ensure that all corrupt/discrepant indexes are fixed.

  Hope this will resolve your problem

  ---

  Kindest Regards,

  Sureshkumar Ramakrishnan