Changing from always_replicate to replicate_if_changed

To change the replication status of a text, unitext, image, or rawobject column from always_replicate to replicate_if_changed:

  1. Use alter replication definition to change the status of the column to replicate_if_changed.

  2. Use sp_setrepcol to change the status of the column in Adaptive Server to replicate_if_changed.