Creates a filter stored procedure to horizontally filter data replicated from a published table. Only unsubscribed articles can be modified by this stored procedure.
sp_articlefilter [@publication =] 'publication', [@article =] 'article'
[,[@filter_name =] 'filter_name'] [,[@filter_clause =] 'filter_clause']
0 (success) or 1 (failure)
sp_articlefilter creates the filter, inserts the ID of the filter stored procedure in the filter column of the sysarticles table, and inserts the text of the restriction clause in the filter_clause column.
To create an article with a horizontal filter, execute sp_addarticle with no filter parameter. Execute sp_articlefilter, providing all parameters including filter_clause. Then execute sp_articleview, providing all parameters including the identical filter_clause. If the filter already exists and if the type in sysarticles is 1 (log-based article), the previous filter is deleted and a new filter is created.
If filter_name and filter_clause are not provided, the previous filter is deleted and the filter ID is set to 0.
Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_articlefilter.
sp_addarticle | sp_articleview |
sp_articlecolumn | System Stored Procedures |