This script creates the user stored procedure upd_publisher_pubs2 at the primary site.
-- Execute this script at Sydney data server -- Creates stored procedure upd_publishers_pub2 create procedure upd_publishers_pubs2 (@pub_id char(4), @pub_name varchar(40), @city varchar(20), @state char(2)) as insert into publishers values (@pub_id, @pub_name, @city, @state) go /* end of script */
This script creates the empty-body stored procedure upd_publishers_pubs2_req.
-- Execute this script at Sydney Replication Server -- Creates stored procedure upd_publishers_pubs2_req create procedure upd_publishers_pubs2_req (@pub_id char(4), @pub_name varchar(40), @city varchar(20), @state char(2)) as begin if (select 1) > 1 print "Submitting request." end go /* end of script */