Enables or disables replication for an Adaptive Server table or displays the current replication status of a table.
sp_setreptable [table_name [, {'true' | 'false'} [, {owner_on | owner_off}]]]
The name of a table in the current database.
Enables replication for the table.
Disables replication for the table.
Sets the mode of the table so that both the table name and owner name are considered when the table is marked for replication. Enables tables with the same name but different owners to be replicated. This option is for Adaptive Server version 11.5 and later databases.
Sets the mode of the table so that only the table name is considered when the table is marked for replication. This is the default. It ensures that the name for each table marked for replication is unique. This option is for Adaptive Server version 11.5 and later databases.
Displays the replication status for all of the tables in the current database.
sp_setreptable
Displays the replication status for the publishers table.
sp_setreptable publishers
Enables replication for the publishers table.
sp_setreptable publishers, 'true'
Allows multiple tables named publishers each owned by different users to be replicated.
sp_setreptable publishers, 'true', owner_on
Use sp_setreptable with no parameters to display a list of replicated tables in the database.
Use sp_setreptable table_name without true or false to display the current replication status of the table.
When you include the owner_on option, multiple tables with the same table name but different owners may be replicated to replicate and warm standby databases. Make sure that the replication definition on the table also includes owner information or replication may fail.
If a table has been marked for replication with sp_setreptable, you can change the owner mode with the sp_setrepdefmode system procedure.
sp_setreptable requires sa or dbo permission or replication_role.
sp_reptostandby, sp_setrepcol, sp_setrepdefmode, sp_setreplicate, sp_setrepproc
