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?
The replicate_ddl
option (for publishing schema changes) is already enabled on the publication subscription: (Publication Properties -> Subscription Options)
The 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