Index Problem

• pkrieg

  Mr or Mrs. 500

  Points: 538

  More actions

  December 21, 2004 at 10:50 pm

  #102320

  I have a table that appears to have a corrupt index.  How can I recreate the indexes on this one table.

  Thanks,

  Phil Krieg

   

   

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  December 22, 2004 at 1:16 am

  #534712

  Have a look at DBCC CHECKTABLE in BOL.

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• Dave-175556

  SSC Eights!

  Points: 896

  More actions

  December 22, 2004 at 9:56 am

  #534797

  Check "DBCC DBREINDEX(Table_Name)" in BOL

• pkrieg

  Mr or Mrs. 500

  Points: 538

  More actions

  December 22, 2004 at 10:40 am

  #534801

  Thanks everyone for your help. 

  I can take it from here.

  Phil Krieg