Use sp_setreptable to set the initial replication status for text, unitext, image, and rawobject columns in Adaptive Server when you mark the table for replication.
sp_setreptable sets the replication status of text, unitext, image, or rawobject columns to always_replicate.
If you use sp_setreptable to mark a table for replication and the table includes text, unitext, image, and rawobject columns, an internal operation needs to be completed for every text, unitext, image, or rawobject columns in every data row of the table. This internal modification is performed in a single transaction, and for large tables, this operation may be time-consuming and involve a significant amount of data.
Before you use sp_setreptable on a large table that has text, unitext, image, or rawobject columns, be sure that you have enough log space for this operation. You may also want to choose a time that will be least disruptive for client applications or replication system administration.
You can speed up the process of marking a table with text, unitext, image, or rawobject, if you use the option use_index. When using this option, Adaptive Server creates an internal nonclustered index for each text, unitext, image, or rawobject, in the table. For example:
sp_setreptable aux_pix, true, null, use_index
See Replication Server Reference Manual > Adaptive Server Commands and System Procedures > sp_setreptable.