sp_remove_remote_table procedure
Purpose Tomark a table as unavailable for SQL Remote replication.
Syntax sp_remove_remote_tabletable_name
Argument Description
table_name
Thetable to be marked as not available for SQL Re-
motereplication.
Seealso “sp_add_remote_tableprocedure” on page 384
“sp_modify_remote_tableprocedure” on page 400
Description Marks a table as unavailablefor replication. Oncethis procedure has been
called,the data in the table cannot be shared with other databases using
SQLRemote.
Example ♦Thefollowing statement marks the employee table as unavailable for
replication:
sp_remove_remote_table employee
go
430