Stored procedures

At the primary site:

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 */

At the replicate site:

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 */