• Still not clear.

    See the words from BOL

    For snapshot or transactional publications, articles can be dropped with no special considerations prior to subscriptions being created. If an article is dropped after one or more subscriptions is created, the subscriptions must be dropped, recreated, and synchronized. For more information about dropping subscriptions, see Subscribing to Publications and sp_dropsubscription (Transact-SQL). sp_dropsubscription allows you to drop a single article from the subscription rather than the entire subscription.

    My situation is i have 10 articles published and subscribed. If i drop one article from SSMS or using sp_droparticle,

    Do I need to take snapshot Again ?

    Do i need to reinitialize the subscription again?

    Will my replication for the remaining 9 tables continue to work without doing the above two (snapshot & reinitializaton)?


    subban