Change the Status of subscribe to truncate table

Use sysadmin apply_truncate_table to change the status of “subscribe to truncate table” for all subscriptions on a replicate table.

All subscriptions for a replicate table in a particular database must either support or not support replication of truncate table. You cannot create a subscription that enables replication of truncate table if all existing subscriptions for that table do not support replication of truncate table.

For example, to turn on replication of truncate table for all subscriptions to a replicate table, log in to the replicate Replication Server and execute this command at the isql prompt:

sysadmin apply_truncate_table, data_server,
 database, {table_owner|’’|””}, table_name'on'

where data_server is the name of the replicate data server, database is the name of the replicate database managed by the data server, table_owner is the owner of the replicate table, and table_name is the name of the replicate table.

If you specified a replicate table owner in the replication definition, you must also specify a table owner with the sysadmin apply_truncate_table command. If you did not specify a replicate table owner in the replication definition, enter '' (two single-quote characters) or ““ (two double-quote characters) for the table owner name.

See Replication Server Reference Manual > Replication Server Commands > sysadmin apply_truncate_table.