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