Transaction log objects for each marked table

Table C-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.

NoteThe transaction log stored procedures listed in Table C-6 have no effect when executed outside the context of replication.

Table C-6: Replication Agent Transaction Log Objects for Each Marked 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)

NoteThe marked objects table contains the mapping between marked objects and their corresponding shadow tables and shadow row procedures.