This script creates stored procedures for the publishers table at the primary and replicate sites.
-- Execute this script at Tokyo and Sydney data servers
-- 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
go
/* end of script */
