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
join filters.
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

David Barquero

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'

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"David Barquero" <davbarquero (AT) hotmail (DOT) com> wrote

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
this error

Server: Msg 21416, Level 16, State 1, Procedure sp_changemergearticle, Line
272
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