Merge Replication downloading rows immediately after uploading SQL 2005

Hi

I have noticed that four out of the 145 tables being replicated in my topology perform a mysterious update.

If I insert data at the subscriber then synchronise the upload is completed followed by immediate downloading of the same identical set of rows as updates.

Has anyone seen anything like this. I cannot see any difference in the filter joins or article settings compared to any other table in the system but these four consistently do this.

Publisher/Distributor: SQL 2005 SP1 on Win 2003 Server
Subscriber: SQL Express 2005 SP1 on Win XP SP2

Cheers
Rab

Answer this question

Merge Replication downloading rows immediately after uploading SQL 2005

Colin Mackintosh
Rab, do you mean the newly inserted rows on the subscriber will be updated during the downloading phase Are you using any parition options
DavidLant

I tried a simple scenario with only one table and was not able to repro this.

Do you have this table in a filter relationship which may be causing the rows to be re-evaludated due to the insert and hence you see downloads
Wanting to gain knowledge
Yes the newly inserted rows at the subscriber are uploaded and then downloaded as updates during the same session.

Partition Options = 0

Data can overlap multiple partitions for these particular tables.

I have include a line from the publication script for one of these articles below.

exec sp_addmergearticle @publication = N'1031', @article = N'tblTACompleted', @source_owner = N'dbo', @source_object = N'tblTACompleted', @type = N'table', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x000000000000CFF1, @identityrangemanagementoption = N'none', @destination_owner = N'dbo', @force_reinit_subscription = 1, @column_tracking = N'true', @article_resolver = N'Microsoft SQL Server DATETIME (Later Wins) Conflict Resolver', @subset_filterclause = N'', @resolver_info = N'lud', @vertical_partition = N'false', @verify_resolver_signature = 0, @allow_interactive_resolver = N'false', @fast_multicol_updateproc = N'true', @check_permissions = 0, @subscriber_upload_options = 0, @delete_tracking = N'true', @compensate_for_errors = N'false', @stream_blob_columns = N'false', @partition_options = 0

Many thanks
Rab
baga
I dropped the publication and created new one using different (Simpler) filter join and the problem has not reoccured.

Cheers
Rab
Merge Replication downloading rows immediately after uploading SQL 2005

Answer this question