SQL CODE BANK
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment