Adaptive Server Commands

Use Adaptive Server commands to troubleshoot the primary database.

Command

Action

sp_start_rep_agent <dbname>

Start RepAgent

sp_stop_rep_agent <dbname>

Stop RepAgent

sp_setreplicate <tablename>, “true”

Set table for replication

sp_setreplicate

Give status of replicated tables

sp_setrepproc <proc_name>,function

Set the specified procedure for replication