Use the sp_setreptable System Procedure

To use sp_setreptable, you must be the Database Owner or the System Administrator for the data server.

See Replication Server Reference Manual > Adaptive Server Commands and System Procedures for more information about sp_setreptable command.

• Enable Replication
  To designate a primary Adaptive Server table for replication, use sp_setreptable.
• Check Replication Status
  You can use sp_setreptable to check the replication status for a table or all tables in the database.
• Enable SQL Statement Replication
  Use sp_setrepdefmode to enable and configure SQL statement replication.
• Enable Replication with owner_on Status
  User tables may have the same name but different owners. Adaptive Server allows you to mark a table for replication and specify that table owner information should be considered when identifying the table.
• Disable replication
  Use sp_setreptable with the false parameter to turn off replication for the table.