all groups > sql server replication > october 2004 >
You're in the

sql server replication

group:

SQL CE replication and MSmerge_contents


SQL CE replication and MSmerge_contents JorgenD
10/14/2004 2:57:02 AM
sql server replication: Hi,

I'm having periodic problems with some SQL CE subscribers that dosen't get
all data replicated.
When synchronizing a common, non filtered transactions table/article all
subribers should be able to see tranactions from each other. Somehow one or
two of 40+ subscriberes don't get all rows replicated, and there is no
patteren in which rows that gets replicated.
Then i want to investigate the generation ID of the rows,and the whole merge
process, but the table MSmerge_contents is not in the SQL CE Database.

Any suggestion on what could go wrong in the merge process?
And why is there no MSmerge_contents table in the SQL CE DB?

Regards
Re: SQL CE replication and MSmerge_contents Hilary Cotter
10/14/2004 7:33:07 AM
I'm not exactly sure why this is. Are you doing any filtering?

MSMerge_Contents is not used for SQL CE. Please refer to
http://support.microsoft.com/default.aspx?scid=kb;en-us;272210 for more
information.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html


[quoted text, click to view]

Re: SQL CE replication and MSmerge_contents JorgenD
10/14/2004 9:13:04 AM
Hi (again) Hilary.

Perhaps you can explain this to me:
If the subscriber is anonymous, my understanding is that the publisher/merge
agent have no idea of which data/generation the subscriber got the last time
it was synchronizing, and I cant find any information of that either in the
subscribers system tables. So how do the merge agent figure out from which
generation to start to merge data?


[quoted text, click to view]
AddThis Social Bookmark Button