sp_replica Replication Stored Procedure

Remotely sets on a subscription server a sysobjects category bit that marks the table as a replica.

Syntax

sp_replica tabname, replicated

where

tabname
Is a unique table name (owner.table) within the current database.
replicated
Sets a category bit that indicates that this is a destination table, a copy and not the original (publication) table. If false, clears the category replica_bit; if true, sets the category replica_bit.

Example

This example marks the authors table as a replica.

sp_replica authors, true

Permission

Execute permission defaults to the system administrator.

Table Used

sysobjects

See Also

sp_distcounters sp_replcleanup
sp_replsync