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.
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.
Refer to “Enabling replication with owner_on status” on page 303 in the Replication Server Administration Guide Volume 1 for syntax and other information about using sp_setreptable to set owner status.
If you mark a table with a non-unique name for replication
and then create a replication definition for it, you must include
owner information in the replication definition. Otherwise, Replication
Server will be unable to find the correct table in the replicate
or standby database.
