"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:usFvFZooGHA.1140@TK2MSFTNGP05.phx.gbl...
> The only thing I can think of is to check that the @keep_partition_changes
> parameter is set to true.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>

> It could be proxing metadata which tags the merge contents and tombstone
> with information on where there rows have come from.
>
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
>
>
> "Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
> news:usFvFZooGHA.1140@TK2MSFTNGP05.phx.gbl...
>> The only thing I can think of is to check that the
>> @keep_partition_changes parameter is set to true.
>> Cheers,
>> Paul Ibison SQL Server MVP, www.replicationanswers.com
>> (recommended sql server 2000 replication book:
>> http://www.nwsu.com/0974973602p.html)
>>
>
>

"franck" wrote:

> Hello,
>
> I've a problem using merge replication on sql server 2005 SP1 with sql
> mobile 3.0 users and dynamic partitions and dynamic filtering using
> SUSER_SNAME().
> We have initilized something about 30 (dynamicly filtered) database for our
> mobile users without any problem.
> When trying to initialize a new one, we can see that the merge filter for
> the users, downloads the right data to the filtered db, and then updates the
> same data a lot of time (6 times).
>
> In the replication monitor we can see 299000 insert (this is alright) and
> 895000 updates applied during merge process. The final database is
> initilized with the right data and has the right size.
>
> Just an idea : We had a problem during tests using the merge process not on
> initialization of the database, but on using. We had a lot of deletes sended
> to users that do not have the data to delete using dynamic filtering on the
> local databases. For this problem, we have found that the parameter
> MaxNetworkOptimization value shoul be set to 1 over the snaphot agent. I
> don't know if there exist such a parameter that could help us for the
> massive updates.
>
> Does anyone have an Idea, please, we need help ?
>
>