Contents Index Preparing procedures and functions for replication Asynchronous procedures

ASA Database Administration Guide
  Replicating Data with Replication Server
    Using the LTM

SQL Statements for controlling procedure replication


A procedure can be configured to act as a replication source using the ALTER PROCEDURE statement.

The following statement makes the procedure MyProc act as a replication source.

ALTER PROCEDURE MyProc
REPLICATE ON

The following statement prevents the procedure MyProc from acting as a replication source.

ALTER PROCEDURE MyProc
REPLICATE OFF

These statements have the same effect as running sp_setreplicate or sp_setrepproc 'table' on the procedure in Adaptive Server Enterprise. The sp_setrepproc 'function' syntax is not supported.

The effects of setting REPLICATE ON for a procedure 

When a procedure is used as a replication data source, calling the procedure sends extra information to the transaction log.


Contents Index Preparing procedures and functions for replication Asynchronous procedures