Adaptive Server Commands and System Procedures

Lists the Adaptive Server commands and system procedures used with Replication Server.

• dbcc dbrepair
  A Transact-SQL command that clears the secondary truncation point for an offline replicated database.
• dbcc gettrunc
  A Transact-SQL command to retrieve current RepAgent information about an Adaptive Server database.
• dbcc settrunc
  A Transact-SQL command that modifies the secondary truncation point information for an Adaptive Server database.
• set replication
  A Transact-SQL command that enables or disables replication of data definition language (DDL) and/or data manipulation language (DML) commands to the standby database for the current isql session.
• set repmode
  Enables or disables, at the session level, the replication of update, delete, insert select, or select into as SQL statements.
• set repthreshold
  Specifies the minimum number of rows that a replicated SQL statement must impact before SQL statement replication is activated for the session.
• sp_configure 'enable rep agent threads'
  Enables or disables RepAgent thread integration in the Adaptive Server.
• sp_configure 'Rep Agent Thread administration'
  Display the current RepAgent thread pool size and the settings of other RepAgent thread parameters.
• sp_configure 'replication agent memory size'
  Change the memory that Adaptive Server allocates to the RepAgent thread pool for multithreaded RepAgent.
• sp_config_rep_agent
  Changes or displays the configuration parameters for the RepAgent thread for an Adaptive Server database.
• sp_help_rep_agent
  Displays static and dynamic information about a RepAgent thread.
• sp_replication_path
  Configures and manages alternate replication paths between a primary database and Replication Server.
• sp_reptostandby
  Marks or unmarks database for replication to the standby database. Enables replication of supported schema changes and data changes to user tables.
• sp_setrepcol
  Sets or displays the replication status for text, unitext, or image columns.
• sp_setrepdbmode
  Enables or disables replication of SQL statements at the database-level and for one or more specific DML operation type.
• sp_setrepdefmode
  Changes or displays the owner status of tables marked for replication, and enables or disables table-level SQL statement replication for a specific DML operation.
• sp_setreplicate
  Enables or disables replication for an Adaptive Server table or stored procedure. It also displays the current replication status of a table or stored procedure.
• sp_setrepproc
  Enables or disables replication for a stored procedure or displays the current replication status of a stored procedure.
• sp_setreptable
  Enables or disables replication for an Adaptive Server table or displays the current replication status of a table.
• sp_start_rep_agent
  Starts a RepAgent thread for the specified database.
• sp_stop_rep_agent
  Shuts down the RepAgent thread for the specified database.