带过滤的复制项UI操作导致订阅全部初始化，但是想不全部初始化，只初始化对应的复制项
[解决]
1.如果修改过滤项，可以直接执行，然后生成快照：
exec
sp_articlefilter
@publication
=
N'testdb
'
,
@article
=
N'tablea
'
,
@filter_name
=
N'FLTR_tablea
_1__97'
,
@filter_clause
=
N'[Loc] =''WD2'' or [Loc] =''TDC'''
,
@force_invalidate_snapshot
=
1
,
@force_reinit_subscription
=
1
-- Adding the article synchronization object
exec
sp_articleview
@publication
=
N'testdb
'
,
@article
=
N'tablea
'
,
@view_name
=
N'SYNC_tablea
_1__97'
,
@filter_clause
=
N'[Loc] =''WD2'' or [Loc] =''TDC'''
,
@force_invalidate_snapshot
=
1
,
@force_reinit_subscription
=
1
2.删除过滤项
exec
sp_articlefilter
@publication
=
N'testdb
'
,
@article
=
N'tablea
'
,
,
@force_reinit_subscription
=
1
-- Adding the article synchronization object
exec
sp_articleview
@publication
=
N'testdb
'
,
@article
=
N'tablea
'
,
,
@force_reinit_subscription
=
1
3.直接删除复制项
exec
sp_dropsubscription
@publication
=
N'testdb
'
,
@article
=
N'tablea
'
,
@subscriber
=
N'all'
EXEC
sp_droparticle
@publication
=
N'testdb
'
,
@article
=
N'tablea
'
,
@force_invalidate_snapshot
=
1
本文转自 Fanr_Zh 博客园博客，原文链接：http://www.cnblogs.com/Amaranthus/p/7092691.html
，如需转载请自行联系原作者
