Change merge filter - 01-12-2005 , 04:09 PM
I like to change a filter of a article. I'm using sp_changemergefilter but I
need the name of the filter.
I have the names of the filters with sp_helpmergefilter but only give me the
I like to know if sp_changemergefilter only works with join filters?
And how can I change a filter that is not join filter?
Thanks for your help
Re: Change merge filter - 01-13-2005 , 08:36 AM
I think you want to use sp_changemergearticle, something like this:
exec sp_changemergearticle @publication = 'Tier1', @article = 'MergeTable',
@force_invalidate_snapshot = 1, @force_reinit_subscription = 1, @property =
'subset_filterclause', @value = 'locationID=1'
Looking for a SQL Server replication book?
"David Barquero" <davbarquero (AT) hotmail (DOT) com> wrote
Re: Change merge filter - 01-13-2005 , 10:09 AM
Hilary Thanks for your help
I try to do it like you say me, but when I'm runing the SP it's give me
Server: Msg 21416, Level 16, State 1, Procedure sp_changemergearticle, Line
Property 'subset_filterclause' of article 'TomaFisica' cannot be changed.
Why I Can't change the filterclause?
"Hilary Cotter" <hilary.cotter (AT) gmail (DOT) com> wrote