title: Can I safely change data in a replicated SQL Server table on the target machine?
body: <p>I replicate a table from one SQL Server 2008 instance to another which already works fine. I'd also like to set a field in the replicated table on the <strong>target instance</strong> of the SQL Servers, but I'm not quite sure whether this is allowed (even though it seems to work). </p>
  
  <p>Reason behind this: Replication from server A to B, processing of rows on server B and then setting (e.g. a flag such as "processed") when the row has been processed. This information is not available on server A and can only be set on server B.</p>
  
  <p>A more cumbersome way would involve a separate table on server B which would have to keep entries of IDs in the replicated table that have already been processed, but maybe this is not necessary?</p>