I have an instance of SQL Server 2014 running replication. I have selected the option to copy nonclustered indexes on all tables:
When this was first enabled, all existing nonclustered indexes were replicated, but since then no new nonclustered indexes have been replicated.
Have I missed a config somewhere? Or is it necessary to manually replicate new nonclustered indexes each time they are created?
replicate_ddl option (for publishing schema changes) is already enabled on the publication subscription: (Publication Properties -> Subscription Options)
schema_option value on all tables is
0x00000000080350DF which breaks down to (if I am not mistaken):
Which indicates that the option to
Generate corresponding nonclustered indexes (0x40) is enabled