-ForceConvergenceLevel - Where dose it go? -- sql server replication

Paul Ibison
10/14/2004 5:18:15 AM

It is (slightly) documented in BOL - see Replication
Merge Agent Utility. This is a commandline parameter that
can be added to the merge agent's job step. Is this
something that you have been told to do by PSS? I'm
curious about why you are implementing it.
Rgds,
Paul Ibison

[quoted text, click to view]

Hilary Cotter
10/14/2004 8:12:58 AM

check this link out:

http://support.microsoft.com/default.aspx?scid=kb;en-us;305039

to use this expand replication monitor, expand the agents folder, expand the
merge agents folder, right click on your merge agent, select merge agent
properties, select steps, double click on Run Agent.

Click on the commands text box, press the end key, press the space key, and
enter -ForceConvergenceLevel and then the level you wish.

Then click apply, ok, apply, ok. Then right click again on your merge agent
and start it up.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

[quoted text, click to view]

JorgenD
10/14/2004 8:57:09 AM

Thanks for your reply Hilary,

The problem is that my subscribers are anonymous and disconnected (SQL CE on
PDAs), so first of all I have 100+ merge agents and second, properties are
not available since they are not connected. Clicking Properties returns a
"SQL server not found"-error

When the subscriber connects and starts the merge process (pull
subsctiption) somhow the agent wakes up. But where is that "trigger"/"command
line"?

[quoted text, click to view]

JorgenD
10/14/2004 9:05:03 AM

Hi Paul.

I'm desperate, due to problems with rows not being replicated. Two
subscribers synchronizes fine without errors, but one gest all the rows from
a table and the other gets most but a few is missing. No filters is applied
on that article.
So I saw a discussion on the subject (can't remember where) and this article
http://support.microsoft.com/default.aspx?scid=kb;en-us;272210 so I thought
it was worth a try.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : -ForceConvergenceLevel - Where dose it go?