Use the bind parameter with sp_replication_path to associate an object with a physical or logical primary replication path. The bound object always follows the same path during replication.
You can bind objects, such as tables or stored procedures, to one or more primary replication paths. When you bind an object to a path, RepAgent sends any replicable actions that you perform upon that object through the path to the Replication Servers that you define in your multiple replication path configuration. If you do not bind an object to a path, RepAgent uses the default path to send the object to the Replication Server defined in the default path. You cannot bind an object to the default path and you do not need to do anything to send an object through the default path.
sp_replication_path dbname, 'bind', "object_type", "[table_owner].object_name", "path_name"where:
sp_replication_path pdb, 'bind', "table", "t1", "pdb_2"
sp_replication_path pdb, 'bind', "table", "owner1.t2", "pdb_2"
sp_replication_path pdb, 'bind', "sproc", "sproc1", "pdb_2"
sp_replication_path pdb, 'bind', "table", "dt1", "everywhere"
sp_replication_path pdb, 'bind', 'table', 'a*', "pdb_2"
sp_replication_path pdb, 'bind', 'table', 'au%rs', "pdb_2"
sp_replication_path pdb, 'bind', 'table', 'a*th%s', "pdb_2"
sp_replication_path pdb, 'bind', 'table', 'authors%', "pdb_2"