Monday, February 20, 2012

Merge Replication and ExchangeType param

Kuba,
It might seem possible to create a new profile and add
the new parameter (-ExchangeType in this case) to
MSagent_parameters for the relevant profile_id
(MSagent_profiles). Unfortunately, the parameters picked
up from the profile are hardcoded in
sp_MSvalidate_agent_parameter so not all the ones listed
on the MS site are acceptable. To try to add a particular
parameter, use sp_add_agent_parameter - it'll return an
error if it is not acceptable, in your case you must
resort to the command-line arguments.
HTH,
Paul Ibison
(The ONLY sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Paul!
unfortunately, it doesn't work, as you said, i'm obtaining ExhangeType is
InvalidParameter for MergeAgent, message ...
thanks for your time...
br
kg
|||did you try Exchange or Exchange?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Kuba" <k.gluszkiewicz@.citysoftware.com.pl> wrote in message
news:OKVEmhDlEHA.1644@.tk2msftngp13.phx.gbl...
> Paul!
> unfortunately, it doesn't work, as you said, i'm obtaining ExhangeType is
> InvalidParameter for MergeAgent, message ...
> thanks for your time...
> br
> kg
>
|||Hilary!
i tried this:
sp_add_agent_parameter 6, 'ExchangeType', 1
thanks
kg
|||Does it work now?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Kuba" <k.gluszkiewicz@.citysoftware.com.pl> wrote in message
news:OL%23ti6NlEHA.3520@.TK2MSFTNGP11.phx.gbl...
> Hilary!
> i tried this:
> sp_add_agent_parameter 6, 'ExchangeType', 1
> thanks
> kg
>
|||no, Hilary, as i wrote before, i'm obtaining ExchangeType is
InvalidParameter for MergeAgent message, yes i know i made mistake in
ExchangeType word in previous post, but i tried it with correct
"ExchangeType"
thanks anyway...
kg

No comments:

Post a Comment