I have a transactional replication setup between the two servers and I noticed that if a run a statement similar to this:
UPDATE mytable SET mycolumn = mycolumn
the replication somehow knows to ignore this transaction and it does not get applied on the subscriber. I have confirmed it by running SQL Profiler and also by adding TIMESTAMP column to my subscriber table (it does not change). I suspect there is some sort of mechanism, which enables this kind of "smart" behavior and I was wondering if anybody could shed some light on it.