sql server replication: Continuous Replication updates every minute -- sql server replication

Continuous Replication updates every minute

Aidan
8/27/2007 12:00:00 AM

sql server replication:

Hi,

I have a setup a merge replication which is set to run continuously. At the
subscriber side I am seeing the tables updated every minute or so. Is it
possible increase the frequency of the replication?

SQL Server 2005
Standard

Thanks
Aidan

Re: Continuous Replication updates every minute

Hilary Cotter
8/27/2007 12:00:00 AM

set pollinginterval to 1, and use the high volume server to server profile.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

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]