Showing posts with label addthe. Show all posts
Showing posts with label addthe. Show all posts

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