Table 2-6 lists the Replication Agent transaction log objects that are created for each primary table that is marked for replication. These objects are created only when a table is marked for replication. These objects are not considered transaction log base objects.
The transaction log stored procedures listed in Table 2-6 have no effect when
executed outside the context of replication. See “Marked objects table”.
Marked table object |
Database name |
|---|---|
Shadow table |
prefixsh_xxx |
Shadow row procedure |
prefixsrp_xxx (public execute permission) |
LOB shadow table |
prefixbsh_xxx |
LOB shadow row procedure |
prefixbsrp_xxx (public execute permission) |
Insert trigger |
prefixinstrg_xxx (or existing-trigger name) |
Update trigger |
prefixupdtrg_xxx (or existing-trigger name) |
Delete trigger |
prefixdeltrg_xxx (or existing-trigger name) |
The marked objects table contains the mapping between
marked objects and their corresponding shadow tables and shadow
row procedures.
