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, a modification record (64 bytes in length) is logged for every text, unitext, image, or rawobject column in every data row of the table. 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.
Refer to 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.
