Alter Replication Status for text, unitext, image, or rawobject Columns

When you replicate text, unitext, image, and rawobject columns you must specify a compatible replication status for each column in both the replication definition and in Adaptive Server.

If you change the replication status of text, unitext, image, and rawobject columns in one table replication definition, the replication status automatically changes in all other replication definitions for the same table that includes those text, unitext, image, and rawobject columns.

If the primary database supports the rs_send_repserver_cmd stored procedure, you can change the replication status of a text, unitext, image, or rawobject column in the primary database by:

  1. Using sp_setrepcol to change the replication status of the column. For example:

    sp_setrepcol authors, au_pix, replicate_if_changed

  2. Using rs_send_repserver_cmd to execute an alter replication definition request to change the replication status. For example: 

    exec rs_send_repserver_cmd ‘alter replication definition authors replicate_if_changed au_pix’

If the primary database does not support rs_send_repserver_cmd, or if there are no data rows for the table in the database log:

  1. Use sp_setrepcol to change the status of the column in the database to the new replication status.

  2. Use alter replication definition to change the status of the column to the new replication status.

Parent topic: Replicate text, unitext, image, and rawobject Columns