Use sp_setreptable to mark individual tables for replication to replicate or replicate and standby databases. Replication Server copies DML operations on those tables to the standby and replicate databases.
Use sp_setreptable to mark tables for replication to the standby database if:
You use Adaptive Server databases, or
You choose not to use sp_reptostandby.
Using sp_setreptable maintains data, but not schema, consistency between the active and standby databases. sp_setreptable normally does not copy supported DDL commands and procedures to the standby database. You can, however, use the set replication command to force replication of DDL commands for the current isql session. Refer to “Changing replication for the current isql session” for more information about set replication.
If the database is the master database, user tables are not replicated.
