DownloadGenerationsPerBatch and SQLMerge

Using Merge replication.
Publisher is Sql Server 2000 SP4, subscribers are laptops using MSDE SP4.
Using anonymous subscribers that use the SQLMerge object to invoke
replication. We've run into issues where the publisher has deleted subscriber
records so we are changing all of our FKs for NFR and want to set
DownloadGenerationsPerBatch to 2000.
However, all documentation and newsgroups just talk about a command line
argument. How do I set DownloadGenerationsPerBatch on the SQLMerge object.
create a profile for this, and use the profile name option in the activeX
merge object - ie ProfileName
But I think you could solve your problem by using
compensate_for_errors=false in sp_addmergearticle
Consult this kb for more info
http://support.microsoft.com/kb/828637
Hilary Cotter
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
"Buzz" <buzz@.online.nospam> wrote in message
news:C26C42E3-906B-4CFA-ADBE-81183E43C890@.microsoft.com...
> Using Merge replication.
> Publisher is Sql Server 2000 SP4, subscribers are laptops using MSDE SP4.
> Using anonymous subscribers that use the SQLMerge object to invoke
> replication. We've run into issues where the publisher has deleted
subscriber
> records so we are changing all of our FKs for NFR and want to set
> DownloadGenerationsPerBatch to 2000.
> However, all documentation and newsgroups just talk about a command line
> argument. How do I set DownloadGenerationsPerBatch on the SQLMerge object.
>
|||Thanks for pointing me in the right direction! Both with profiles and the new
article option!
"Hilary Cotter" wrote:

> create a profile for this, and use the profile name option in the activeX
> merge object - ie ProfileName
> But I think you could solve your problem by using
> compensate_for_errors=false in sp_addmergearticle
> Consult this kb for more info
> http://support.microsoft.com/kb/828637
> --
> Hilary Cotter
> 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
> "Buzz" <buzz@.online.nospam> wrote in message
> news:C26C42E3-906B-4CFA-ADBE-81183E43C890@.microsoft.com...
> subscriber
>
>
sql