Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Merge replication - changes tracking level

Author  Topic 

PeterTheOne
Starting Member

1 Post

Posted - 2010-11-03 : 03:33:39
Hello,

I've got the following problem - I am replicating only selected columns from the table A. There are different updates performed at the publisher that update records in this table. There are many updates performed that affect only columns that are not replicated in the table A. However, in such cases, the replication engine decided that these rows must be also synchronized, because there was a change in a row. In my case, it is unnecessary and it has got a huge impact on the performance of the system. Is there any way to exclude those columns which are not replicated in the table A from the tracking changes mechanisms?

Thanks for all answers in advance. Peter.
   

- Advertisement -