Table Objects

Replication Agent creates table objects in the Microsoft SQL Server primary database.

These tables are considered Replication Agent objects. Insert and delete permissions are granted to public only on the DDL shadow table. No permissions are granted on the other tables.

Replication Agent Table Objects
Object	Name
DDL shadow table	`prefix`ddl_trig_`xxx`
Instance table	`prefix`instance_`xxx`
Object marking table	`prefix`markObject_`xxx`
Object verifying table	`prefix`checkObject_`xxx`

Microsoft SQL Server System Tables
At initialization, Replication Agent creates some system tables in the primary database using the Microsoft SQL Server sp_replicationdboption stored procedure.

Parent topic: Replication Agent Object Names