SQLServerCentral / SQL Server 2005 / SS2K5 Replication / Beginner at replication - How can you tell how often replication kicksoff? / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 14:52:50 GMT20RE: Beginner at replication - How can you tell how often replication kicksoff?http://www.sqlservercentral.com/Forums/Topic794689-291-1.aspxGlad I could help... Send out the Six pack by post...;-)Tue, 29 Sep 2009 13:19:22 GMTRoy ErnestRE: Beginner at replication - How can you tell how often replication kicksoff?http://www.sqlservercentral.com/Forums/Topic794689-291-1.aspxAwesome! Thank you very much. Really appreciate your help. I owe you a 6 pack. :-)Tue, 29 Sep 2009 08:02:15 GMTtan110RE: Beginner at replication - How can you tell how often replication kicksoff?http://www.sqlservercentral.com/Forums/Topic794689-291-1.aspxIf you script the Publication, check what is the value for @repl_freq. If it is continuous, then it updates the subscriber immediately.Tue, 29 Sep 2009 07:05:56 GMTRoy ErnestRE: Beginner at replication - How can you tell how often replication kicksoff?http://www.sqlservercentral.com/Forums/Topic794689-291-1.aspxWhere do I check to see if the transactional rep is set to immediate?Mon, 28 Sep 2009 15:33:24 GMTtan110RE: Beginner at replication - How can you tell how often replication kicksoff?http://www.sqlservercentral.com/Forums/Topic794689-291-1.aspxOk, its transactional.Mon, 28 Sep 2009 15:32:37 GMTtan110RE: Beginner at replication - How can you tell how often replication kicksoff?http://www.sqlservercentral.com/Forums/Topic794689-291-1.aspxHow can I tell whether its snapshot or transactional? I'm thinking its just transactional, but I'll double check.Mon, 28 Sep 2009 15:31:59 GMTtan110RE: Beginner at replication - How can you tell how often replication kicksoff?http://www.sqlservercentral.com/Forums/Topic794689-291-1.aspxIt depends. It depends on the type of replication. If it is Snapshot replication, it will be scheduled to run at a certain interval. But if it is Transactional replication and set with immediate, then it will update as soon as a data is changed. (Of course there might be a small lag)Mon, 28 Sep 2009 15:25:22 GMTRoy ErnestBeginner at replication - How can you tell how often replication kicksoff?http://www.sqlservercentral.com/Forums/Topic794689-291-1.aspxI'm a beginner at replication, and trying to look at an existing replication job. From server A to server B. Looks like its just one-way replication. with a A being the publisher/Distributor, and B, being the subscriber. Is there a way to tell how often replication kicksoff? a scheduler of some type? Need to answer the question "is replication occuring every 5, 10, or 15 minutes?" or is it constant, every time a change occurs on A, is B automatically updated. Basically a continuous update/replication?Mon, 28 Sep 2009 12:44:48 GMTtan110