Thursday 9 June 2011

Drop article or table manually from replication in SQL SERVER

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