Groups | Blog | Home
all groups > sql server replication > october 2006 >

sql server replication : Merge Replication-Massive Insertion


Hilary Cotter
10/26/2006 12:52:13 PM
Can you use profiler to determine which table these inserts are occurring on
of it is part of the merge replication meta data processing? Also are you
using join filters?

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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]

Maria
10/26/2006 6:16:22 PM
Hi,
I have a merge replication with two sql server 2000 sp3.
The schedule of the merge is periodic every 10 minutes.
Though no change has taken place in any of two databases, always massive
insertions take place by the suscriptor.

Why?.That I must do?.
Thank you in advance and sorry for my english

Maria
10/27/2006 2:18:03 PM
Thanks, Hilary
Following your instruccions, I have found the problem.
Really, the problem wasn´t in the merge replication, was in our software.
Thanks
Maria

"Hilary Cotter" <hilary.cotter@gmail.com> escribió en el mensaje
news:uM83U7R%23GHA.3348@TK2MSFTNGP03.phx.gbl...
[quoted text, click to view]

AddThis Social Bookmark Button