sp_replstatus Replication Stored Procedure

Used to update the internal table structure for replication (the internal table structure indicates whether the table is being replicated).

Syntax

sp_replstatus objectID, status

where

objectID

Is the object ID of the table being replicated.

status

Specifies the status. Can be 0 (not replicated) or 1 (replicated).

Remarks

This replication stored procedure is used by the logreader process. It returns information about the publication database from which it is executed.

Executing sp_replstatus must be done in conjunction with an update of the category bit in the sysobjects table.

Example

This example indicates the sp_replstatus is being replicated.

sp_replstatus

Permission

Execute permission defaults to the system administrator and is granted to repl_subscriber.

Table Used

None.

See Also