"JE" <jgegroups.spam@gmail.nospam.com> wrote in message
news:45FFDF85.7030807@gmail.nospam.com...
>I see, so adding the parameter directly to the merge agent job will
>override the value specified in the default merge agent profile and also
>allow me to set it to whatever I need.
>
> I wonder if Microsoft can tell us why they limit the MaxDownloadChanges to
> 300 in the agent profile properties dialog.
>
> Hilary Cotter wrote:
>> Open up replication monitor, locate your publication, locate your
>> publication (click on it), right click and select view details, click on
>> Action, Merge Agent Job Properties, and select Steps, run agent, and
>> click edit, click in the command box, and hit end, then
>> type -MaxDownloadChanges 100
>>
>> Close the dialog and restart your agent.
>>

"JE" <jgegroups.spam@gmail.nospam.com> wrote in message
news:uqaHGxtaHHA.1296@TK2MSFTNGP02.phx.gbl...
>I am trying to limit the downloaded records per merge session over my less
>reliable links. Under SQL2000 I could set MaxDownloadChanges in the agent
>profile to 1500, but in SQL2005 this value is limited to 300 max. Has
>anybody run into this issue before? Why was it changed from SQL2000 to
>SQL2005?
>
> The parameters are defined in msdb..MSagentparameterlist. I am considering
> changing the record to allow a different maximum. Would this be an issue?

"JE" <jgegroups.spam@gmail.nospam.com> wrote in message
news:45FFC69D.2030108@gmail.nospam.com...
> When I try to override it I am not allowed to enter a value higher than
> 300. In SQL2000 I was able to enter any value, but in SQL2005 it limits me
> to 300.
>
> Hilary Cotter wrote:
>> I have no idea why it was changed but you should be able to override the
>> profile settings in the agent properties.
>>