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 do not want to replicate text, unitext, image,
and rawobject columns, use sp_setreplicate to
mark the table for replication, which sets the replication status
of text, unitext, image,
and rawobject columns to do_not_replicate.
If you use sp_setreptable to mark a table for replication and the table includes text, unitext, image, or rawobject columns, an internal operation needs to be completed for every text, unitext, image, or rawobject column 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 rawobjects, 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 Chapter 5, “Adaptive Server Commands and System Procedures” in the Replication Server Reference Manual for more information about sp_setreptable command.
Refer to your Replication Agent documentation for instructions
on marking tables for replication in non-Sybase data servers.
