I have a few columns in a table that are added to my publication articles. When a change on a column that is not included in replication occurs, it still seems to update the msrepl_tran_version which i assume still assigns the row for replication. Is this how SQL-Server works? Is there a way to tell sql only to relicate rows when a colum that is included in the articles is changed and not when a non-replicated column is changed?
A:
There is no way to avoid this aside from hacking the system-generated triggers and procedures (which is very, very, very strongly discouraged). I'd strongly encourage you to enter a bug/suggestion at Microsoft Connect outlining this issue and how it is affecting your environment. There are others you may want to recruit in your cause as well.
chadhoc
2009-11-18 15:11:42