User's Manual

sp_remove_remote_table procedure
Purpose To mark a table as unavailable for SQL Remote replication.
Syntax sp_remove_remote_table table_name
Argument Description
table_name The table to be marked as not available for SQL Re-
mote replication.
See also “sp_add_remote_table procedure” on page 384
“sp_modify_remote_table procedure” on page 400
Description Marks a table as unavailable for replication. Once this procedure has been
called, the data in the table cannot be shared with other databases using
SQL Remote.
Example
♦ The following statement marks the employee table as unavailable for
replication:
sp_remove_remote_table employee
go
430