In an already existing publication, I have an article that uses schema_option 0x0000000000000080. I need to change it as this doesn't allow custom proc updates.(I need to do DDL changes on the article at Publisher, and that is not being allowed )
Subscrition for this article has sync type 'Replication Support Only'.
My questions are:
1.When I use sp_changearticle to update the schema_option, do i need to create snapshot?
Documentation says you must specify a value of 1 for
the force_invalidate_snapshot parameter
if you are updating schema_option.
But since this is 'Replication Support Only', it should be fine if i keep force_invalidate_snapshot=0?
2.Do I need to drop and re-add subscription if i change schema_option using sp_changearticle?
