[问题]
带过滤的复制项UI操作导致订阅全部初始化,但是想不全部初始化,只初始化对应的复制项
[解决]
1.如果修改过滤项,可以直接执行,然后生成快照:
-- Adding the article synchronization object
2.删除过滤项
exec sp_articlefilter @publication = N'testdb', @article = N'tablea' ,
-- Adding the article synchronization object
exec sp_articleview @publication = N'testdb', @article = N'tablea' ,
3.直接删除复制项
exec sp_dropsubscription @publication=N'testdb', @article=N'tablea', @subscriber=N'all'