Enabling Replication for a Marked Stored Procedure

Enable replication of stored procedures.

  1. Log in to the Replication Agent instance with the administrator login.
  2. Determine if replication is enabled for the stored procedure:
    pdb_setrepproc pdb_proc

    where pdb_proc is the name of the stored procedure stored procedure you want to enable replication for.

    If pdb_setrepproc returns information that the specified stored procedure is marked and has replication disabled, continue this procedure to enable replication for the stored procedure.

    Note: A stored procedure must be marked for replication before replication can be enabled or disabled for the stored procedure.
  3. Enable replication for the marked stored procedure:
    pdb_setrepproc pdb_proc, enable

    After replication is enabled for the stored procedure, any invocation of that stored procedure is replicated.

  4. Verify that replication is now enabled for the stored procedure:
    pdb_setrepproc pdb_proc