Transaction log objects for each marked table

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

No permission is granted on these procedures.

Table B-7: Replication Agent Transaction Log Objects for Each Marked Table

Object

Database Name

shadow table

prefixsh_xxx

shadow row procedure

prefixsrp_xxx

LOB shadow table

prefixbsh_xxx

LOB shadow row procedure

prefixbsrp_xxx

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 records the mapping between marked objects and their corresponding shadow tables and shadow row procedures. The pdb_setrepproc and pdb_setreptable commands return this information.