Adaptive Server and Replication Server allow you to replicate
tables with the same name but different owners.
When you mark a database for replication with sp_reptostandby,
updates are copied automatically to the table of the same name and
owner in the standby database.
When you mark a table for replication using
sp_setreptable,
you can choose whether the table owner name is used to select the
correct table in the standby database.
If you set owner_on,
Replication Server sends the table name and table owner name to
the standby database.
If you set owner_off,
Replication Server sends the table name and “dbo” as the
owner name to the standby database.
Note: If you are copying information to a replicate database
and have used sp_setreptable to set owner_off,
Replication Server sends the table name to the replicate database.
It does not send owner information.
See Replication Server Administration Guide Volume 1 > Manage Replicated Tables > Mark Tables for Replication > Use the sp_setreptable System Procedure > Enable Replication with owner_on Status.
Note: If you mark a table with a nonunique name for replication, then create a replication definition for it, you must include
owner information in the replication definition. Otherwise, Replication
Server cannot find the correct table in the replicate
or standby database.