Friday, February 10, 2012

Change merge filter

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@.hotmail.com> wrote in message
news:ujr53NP%23EHA.1408@.TK2MSFTNGP10.phx.gbl...
> 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
>
|||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@.gmail.com> wrote in message
news:%23ixyH1X%23EHA.2032@.tk2msftngp13.phx.gbl...
>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@.hotmail.com> wrote in message
> news:ujr53NP%23EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I
> the
>

No comments:

Post a Comment