ASA Database Administration Guide
Replicating Data with Replication Server
Using the LTM
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.
When a procedure is used as a replication data source, calling the procedure sends extra information to the transaction log.