rebuild indexes on replicated db

Ive rebuild the Indexes on a Replicated db weekly. However, it makes the Log
Reader Agent blow up with "cannot exec sp_replcmds" error. It doesnt restart
until done manually. Any ideas on how to fix?
SQL2K SP3
TIA, ChrisR
Stop the log reader. Run dbcc reindex. After rebuilding the indexes, restart
the log reader agent.
The problem is that the rebuilding of the indexes is a logged operation and
this interferes with the log reader.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"ChrisR" <bla@.noemail.com> wrote in message
news:%23sUKEPM0EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Ive rebuild the Indexes on a Replicated db weekly. However, it makes the
> Log
> Reader Agent blow up with "cannot exec sp_replcmds" error. It doesnt
> restart
> until done manually. Any ideas on how to fix?
> --
> SQL2K SP3
> TIA, ChrisR
>