On Feb 12, 1:22 pm, "Hilary Cotter" <hilary.cot...@gmail.com> wrote:
> Indexes created on the publisher will not be replicated to the subscriber.
> You will have to manually create them there, or use sp_addscriptexec to
> replicated them to subscriptions deployed via unc copies.
>
> --
> Hilary Cotter
>
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com
>
> <kulkarni.ni...@gmail.com> wrote in message
>
> news:1171302395.531464.125040@l53g2000cwa.googlegroups.com...
>
>
>
> > Hi,
>
> > currently, we have some tables which are part of transactional
> > replication now we want to build indexes on those tables but my
> > concern is after building indexes on publication side will changes get
> > replicated to subscription side or not? and also what is the best way
> > to build indexes on such tables?
>
> > Thanks

<kulkarni.ninad@gmail.com> wrote in message
news:1171302395.531464.125040@l53g2000cwa.googlegroups.com...
>
> Hi,
>
> currently, we have some tables which are part of transactional
> replication now we want to build indexes on those tables but my
> concern is after building indexes on publication side will changes get
> replicated to subscription side or not? and also what is the best way
> to build indexes on such tables?
>
> Thanks
>