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.

To unmark a stored procedure

Log in to the Replication Agent administration port.
Use the pdb_setrepproc command to confirm that the stored procedure is marked in the primary database.
```
pdb_setrepproc pdb_proc
```
where 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 need not continue this procedure.
Use the pdb_setrepproc command to disable replication of the stored procedure.
```
pdb_setrepproc pdb_proc, disable
```
where pdb_proc is the name of the stored procedure that you want to unmark.
Use the pdb_setrepproc command to remove the replication marking from the stored procedure.
```
pdb_setrepproc pdb_proc, unmark
```
where 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
```
Use the pdb_setrepproc command to confirm that the stored procedure is no longer marked for replication.
```
pdb_setrepproc pdb_proc
```
where 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.