Change Column Status for text, unitext, image, or rawobject Columns

Use sp_setrepcol to adjust the replication status for text, unitext, image, or rawobject columns.

When you mark a table with text, unitext, image, or rawobject columns for replication, sp_setreptable sets the replication status of text, unitext, image, or rawobject columns to always_replicate.

The replication status is the same for all replication definitions of a primary table. If you change the replication status for one replication definition with alter replication definition, you change the replication status for all replication definitions on the same primary table.

If you do not want to replicate some of the text, unitext, image, or rawobject columns in a marked table (or you marked the table using sp_setreplicate, which sets the replication status of text, unitext, image, and rawobject columns to do_not_replicate), use sp_setrepcol to adjust the replication status. You can set the replication status for one or all columns to always_replicate, do_not_replicate, or replicate_if_changed.

To use sp_setrepcol, you must be the Database Owner or System Administrator for the data server.

Note: If you have marked the database for replication to a standby database using sp_reptostandby and marked database tables for replication to a replicate database using sp_setreptable, Replication Server copies text, unitext, image, and rawobject columns to standby and replicate databases as always_replicate. If you want to copy text, unitext, image, and rawobject columns as replicate_if_changed, use sp_setrepcol to adjust the replication status. See Replication Server Administration Guide Volume 2 > Manage Warm Standby Applications > What Information is Replicated for ASE Warm Standby Application? > Replicate text, unitext, image, and rawobject Data for more information about replicating in a warm standby application.

See Replication Server Reference Manual > Adaptive Server Commands and System Procedures > sp_setrepcol.

text, unitext, image, or rawobject Column Replication Status
There are three status clauses to set the replication status of the text, unitext, image, or rawobject columns.
Enable Column Replication
Use sp_setrepcol to mark a column with an image or rawobject datatype for replication.
Disable Column Replication
Use sp_setrepcol with the do_not_replicate parameter to turn off replication for an image or rawobject column.
Enable or Disable Replication for All Columns
To mark all text, unitext, image, and rawobject columns in the table with the same replication status, enter “null” instead of a column name.

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