Search

Friday, May 24, 2013

Drop article from Existing Publication (Transactional Replication)


EXEC sp_dropsubscription
@publication = 'Publication name',
@article = N'Table Name',
@subscriber = 'Subscriber Server Name';
 GO

 EXEC sp_droparticle
 @publication = 'Publication name',
 @article = N'Table Name',
 @force_invalidate_snapshot = 0

No comments:

Post a Comment