The script creates the stored procedure upd_publisher_pubs2 at the primary site.
The following script modifies the upd_publishers_pub2_req stored procedure at the replicate site. The insert into clause tells the replicate Replication Server to insert values into the publishers_pend table.
-- Execute this script at Sydney data server -- Creates stored procedure create procedure upd_publishers_pubs2_req (@pub_id char(4), @pub_name varchar(40), @city varchar(20), @state char(2)) as insert into publishers_pend values (@pub_id, @pub_name, @city, @state) go /* end of script */
This script modifies the upd_publishers_pubs2 procedure for the replicate site. It updates the publishers table and deletes the corresponding information from the publishers_pend table.
-- Execute this script at Sydney data server -- Creates stored procedure upd_publishers_pubs2 create procedure upd_publishers_pubs2 (@pub_id char(4), @pub_name varchar(40), @city varchar(20), @state char(2)) as update publishers set pub_name = @pub_name, city = @city, state = @state where pub_id = @pub_id delete from publishers_pend where pub_id = @pub_id go /* end of script */