Changing from replicate_if_changed to always_replicate

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

  1. Let all transactions with a replicate_if_changed status finish processing.

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

  3. Use alter replication definition to change the status of the column to always_replicate.