If a database is marked with sp_reptostandby, the replication status is automatically replicate_if_changed, and Adaptive Server logs only text, unitext, image, and rawobject columns that have been changed. This ensures that the standby database stays in sync with the active database. You cannot change the replication status of such a table using sp_setrepcol.
If a table is marked for replication with sp_setreptable, the default replication status is always_replicate, and Adaptive Server logs all text, unitext, image, and rawobject column data. You can change the replication status of text, unitext, image, and rawobject columns in tables marked with sp_setreptable. Use sp_setrepcol to change the replication status to replicate_if_changed or do_not_replicate. A column or combination of columns must uniquely identify each row.
If you use replication definitions, the primary key must be a set of columns that uniquely identify each row in the table. You have to make sure that the replication status is the same at the Adaptive Server and the Replication Server.
