all groups > sql server replication > april 2007 >
You're in the

sql server replication

group:

Merge Replication Status


Merge Replication Status Brian Bunin
4/11/2007 4:45:36 PM
sql server replication:
I'm using sp_replmonitorhelpmergesession to determine the status of
multiple push subscriptions.



When I set the Merge Agent to Slow Link, I get a status of 4 and the
message "No Data needed to be Merged" when there are no changes.

I'd like to get it to return the Status 4 when it's idle, but I want
to increase the polling interval from 60 to 180.
So I copy the Agent Profile "Slow Link" and alter the polling interval
and validation intervals only.

When I copy the slow Link Profile and use the copy, I get a Status of
3 and the message "Waiting xxx second(s) before polling for further
changes."

Where/how are these controlled?
Re: Merge Replication Status Hilary Cotter
4/12/2007 11:48:02 AM
pollinginterval

--
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



[quoted text, click to view]

Re: Merge Replication Status Brian Bunin
4/12/2007 1:25:12 PM
[quoted text, click to view]

Yes, but why does changing that alter the behavior of the Status and
messages?
AddThis Social Bookmark Button