XY Problem background info:
I have a pull replication publisher in which I want to add or alter a index and have those changes be applied to the subscriber.
The solution to that problem I would like to do is to generate a new snapshot and re-init the subscription.
How do I, from the publisher, mark a pull merge replication publication as having a invalid snapshot such that if I did
snapshot_ready column would return 0.
exec sp_reinitmergesubscription @upload_first = 'true' will cause the subscriber to re-initialize but it does not mark the snapshot as invalid.
I know I could change a publication or article property then change it back and cause to invalidation to happen that way but I would really like to invalidate as the "primary action" instead of having the invalidation be a side effect of some other action.
I am looking for something similar to transactional replication's
sp_reinitsubscription procedure which has a
@invalidate_snapshot parameter, but I could not find the equivalent for merge replication.
Is there any way to invalidate a merge replication snapshot only without making some other kind of change that has snapshot invalidation as a side effect?