Groups | Blog | Home
all groups > sql server replication > july 2006 >

sql server replication : Index not replicated to the device


justin.k.tang NO[at]SPAM gmail.com
7/13/2006 6:16:28 PM
Hi,

I have a table published on the publisher. But when I add an index to
the table it's not replicated to the device. I have checked the
snapshot folder and the newly added index is in the .dri file. Any
ideas?

Cheers,
Justin
Paul Ibison
7/14/2006 12:00:00 AM
If you are adding indexes on the publisher and want them to get propagated
to the subscriber, you'll need to use sp_addscriptexec. I don't understand
why you are seeing an index file in the snapshot folder - presumably you
have recreated a snapshot file? If you were to reinitialize then it would
get applied.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

justin.k.tang NO[at]SPAM gmail.com
7/19/2006 9:02:55 PM
Thx, Paul. It works.
AddThis Social Bookmark Button