Disabling Replication for a Marked Stored Procedure

Disable replication of stored procedures.

Log in to the Replication Agent instance with the administrator login.
Determine if replication is enabled for the stored procedure:
```
pdb_setrepproc pdb_proc
```
where pdb_proc is the name of the stored procedure for which you want to disable replication.

If pdb_setrepproc returns information that the specified stored procedure is marked and has replication enabled, continue this procedure to disable 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.
Disable replication of the stored procedure:
```
pdb_setrepproc pdb_proc, disable
```
After replication is disabled for the stored procedure, any invocation of that stored procedure is not captured for replication until replication is enabled again.
Verify that replication is now disabled for the stored procedure:
```
pdb_setrepproc pdb_proc
```