This script creates a function replication definition for the publishers table at the primary Replication Server. The replication definition uses the same name, parameters, and datatypes as the stored procedure in the primary database.
-- Execute this script at Tokyo Replication Server
-- Creates replication definition
upd_publishers_pubs2
create function replication definition upd_publishers_pubs2
with primary at TOKYO_DS.pubs2
(@pub_id char(4),
@pub_name varchar(40),
@city varchar(20),
@state char(2))
go
/* end of script */