Drop article or table manually from replication
-- FIRST STEP DROP SUBSCRIPTION
sp_dropsubscription @publication = ' PUBLICATION name'
, @article = 'table_name'
, @subscriber = subscriber name‘'
, @destination_db = 'data base name '
GO
---------------------------------
-- SECOND STEP DROP PUBLICATION
sp_droparticle @publication = ‘PUBLICATION name '
, @article = 'table name'
GO
After that please start snap shot agent and chek replication status
No comments:
Post a Comment