Problem with a Replication with two publications

Hi.

I have a database with two publications.
One publication is used to replicate data among 4 SQL Servers, while the other is used for the replication with SQL Server CE clients.
The problem here is that the SQLCE receive a number of changes that it is not correct.
Before establishing the publication for SQL Servers the SQL CE clients were working great, but now i have this problem.

Is there any patch or fix I should install on the server?, or do you know how can I solve this?

Thank you.

Omar Rojascan you give more details about your setup? Is this tran or merge publication? what errors are you getting? are there tables belonging to both publications?|||Hi, Greg.

Both are Merge Publications. The tables are belonging to both pubs. The problem is that when I add a SQL 2K subscription and it synchronize, it takes (in this case) about 61000 changes, while the SQLCE client just needs about 100 or so. The SQLCE client is just collecting its 100 changes, but everytime it replicates, it receives a notification that got 61000 changes (even when just 100 are real) BUT its replication time lasts very much.
The difference between publications are the filters. The filters of the SQLCE are specific for one client, while the filters of SQL2K can give info about many clients. (Specified by columns in tables)

Regards!

Omar.|||

Hi Omar,

Help me understand the scenario.

1. Publication pub1 goes to SQL 2K subscriber has a filter that qualifies 61000 rows from a table.

2. Publication pub2 goes to SQL CE subscriber has a filter that qualifies only 100 rows from the very same table

3. The only changes are in the filters for the 2 publications

4. CE subscriber syncs to the publisher for publication pub2 and does get only the relevant 100 rows but it takes a long time and reports 61000 rows downloaded. You do not see 61000 rows at the subscriber and see only 100.

|||Mahesh:

That's it, exactly as you said it!, at the time I delete the SQL2K Subscription, everything on the SQLCE subscriber becomes normal.

Have you had any scenario like this?

Thank you for your reply!

Omar|||

No, I havent seen a scenario like this.

It will help if you can post your publication/article/filter scripts.

Also I assume your CE subscriber is 2.0 and not 3.0?

|||Hi, Mahesh.

I updated the SQL Server to SP3 and all seems to work fine. Either way, Some rows are not being replicated on some tables and I'm checking on it, but the problem about de 60k rows is gone (or at least it seems to).
Thank you for your help!
Regards!

Omarsql