Cluster and Non-Cluster Indexes

How are cluster and non-cluster indexes data moved with SQL Server 2000
Transaction Replication? I have one database that I am using to replication
to another server.
I would like to execute the dbcc reindex job on the subscriber database to
reindex all of the indexes, would this be replicated to the subscriber
database.
Thanks,
No, it isn't - it is logged though and this does affect the log reader
agent's performance.
You can replicate these commands to the subscriber using sp_addscriptexec if
all of your subscribers are deployed via unc.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:8F9EC263-95CD-42D3-9C82-D5BB1DE169EC@.microsoft.com...
> How are cluster and non-cluster indexes data moved with SQL Server 2000
> Transaction Replication? I have one database that I am using to
replication
> to another server.
> I would like to execute the dbcc reindex job on the subscriber database to
> reindex all of the indexes, would this be replicated to the subscriber
> database.
> Thanks,
>
>