Transaction log objects for each marked table

Table D-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, and thus, they are not considered to be transaction log base objects.

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

Table D-7: Replication Agent transaction log objects for each marked table

Object

Database Name

shadow table

prefixSH_xxx (no permissions granted)

LOB shadow table

prefixBSH_xxx (no permissions granted)

shadow row procedure

prefixSRP_xxx (execute permission granted to public)

LOB shadow row procedure

prefixBSRP_xxx (execute permission granted to public)

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.