Need to update schema_option for an article that has subscription sync type 'replication support only' RRS feed

  • Question

  • 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?

    Friday, April 14, 2017 5:17 AM