Unmarking a stored procedure

When you unmark a stored procedure, Replication Agent removes the transaction log objects that were created when the stored procedure was marked.

1. Log in to the Replication Agent instance with the administrator login.

2. Use the pdb_setrepproc command to confirm that the stored procedure is marked in the primary database:

   pdb_setrepproc pdb_proc
   

   Here, pdb_proc is the name of the stored procedure that you want to unmark.

   • If the pdb_setrepproc command returns information that the specified stored procedure is marked, continue this procedure to unmark the stored procedure.

   • If the pdb_setrepproc command does not return information that the specified stored procedure is marked, you do not need to continue this procedure.

3. Use the pdb_setrepproc command to disable replication of the stored procedure:

   pdb_setrepproc pdb_proc, disable
   

   Here, pdb_proc is the name of the stored procedure that you want to unmark.

4. Use the pdb_setrepproc command to remove the replication marking from the stored procedure:

   pdb_setrepproc pdb_proc, unmark
   

   Here, pdb_proc is the name of the stored procedure that you want to unmark.

   If you need to force the unmark, you can use the following command:

   pdb_setrepproc pdb_proc, unmark, force
   

5. Use the pdb_setrepproc command to confirm that the stored procedure is no longer marked for replication:

   pdb_setrepproc pdb_proc
   

   Here, pdb_proc is the name of the stored procedure in the primary database that you unmarked.

You can unmark all marked stored procedures in the primary database by invoking the pdb_setrepproc command with the all keyword.