Home Forums SQL Server 7,2000 Replication How to fix corrupted index on subscriber table RE: How to fix corrupted index on subscriber table

  • August 5, 2005 at 1:55 am

    #579925

    why don't you try a DBCC IndexDefrag insted of a dbcc dbreindex. it can be done without taking the db or table off-line.

    I would shutdown the replication agent.

    Run DBCC IndexDefrag <check BOL for the exact syntax >

    Re-start the replication agent.

    good luck,

    Don't count what you do, do what counts.

    SQL Draggon