[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 844
  • Last Modified:

Non clustered index not passing through merge replication

Hi,

Trying to deploy a new non clustered index to a table which is published via merge replication. I have the table properties of the article set as copy nonclustered indexes = true, however regardless of where I deploy it (publisher or subscriber) it does not propgate to the other db.

I have tried a variety of deployments and re running snapshot agent but unless I reinitialise the index doesnt move on.

Any ideas?

Jay
0
slam69
Asked:
slam69
  • 2
  • 2
1 Solution
 
rbrideCommented:
Does the publication have the "replicate schema changes" property set?
0
 
slam69Author Commented:
Apologies I should have put that in teh question but yes it does
0
 
AnujSQL Server DBACommented:
Is that a filtered publication? Filtered publication needs re-initializing the subscription.
0
 
slam69Author Commented:
Nope direct merge no filtration... Keep em coming :)
0
 
AnujSQL Server DBACommented:
as per my knowledge Indexes do net get replicated in merge replication, Only at the time of initialization the indexes are copied to subscribers. You need to run this at each subscriber or try sp_addscriptexec  to create a index script file and run this at publisher.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now