Modify the Owner Status of a Table

You can use the sp_setrepdefmode system procedure to change the owner status of a table previously marked for replication.

To change the status of a table already marked for replication to “owner on,” log in to Adaptive Server and enter:

sp_setrepdefmode table_name, owner_on

To change the status of a table already marked for replication to "owner off," log in to Adaptive Server and enter:

sp_setrepdefmode table_name, owner_off

You must reflect a change in owner status by including owner information in the replication definition. Use create replication definition at the Replication Server to create a new replication definition that includes the table owner.