To always replicate text, unitext, image, or rawobject columns:
Stop updates at the primary table.
Execute the alter replication definition command, and change the status of the text, unitext, image, or rawobject columns to replicate_if_changed. Wait for the modified replication definition to arrive at the replicate sites.
Restart RepAgent to let transactions with a replicate_if_changed status finish processing.
Execute the sp_setrepcol system procedure at the Adaptive Server and change the status to always_replicate.
Execute alter replication definition and change the status of the text, unitext, image, or rawobject columns to always_replicate. Wait for the modified replication definition to be replicated to the replicate sites.
Resume updates to the primary table.
