Cannot drop the table  because it is being used for replication.
Hi Geeks, We have transaction replication setup (not bidirectional or updatable subscriber) with Publisher A having Subscriber B. The subscriber B is acting as a publisher for six more subscribers. Now, when I tried to reinitialize the subscription for B (with new snapshot as older snapshots were deleted),The replication is failing with error : Cannot drop the table 'table_name' because it is being used for replication. table_name is one of many tables in article being published. Do I need to drop all the subscribers of B (as B is also a publisher) and set the things up from scratch? Need suggestions on workaround or fix. TIA ! Regards, Sajal Bagchi
Set your attributes for the package that you are trying to reinitialize, the article properties, so that the Action if name is in use to Delete Data. This will push the reload throughout your system without dropping the tables or having to remove the replication in the middle.