Chapter 3: Replication Agent for Microsoft SQL Server

Transaction log objects for each marked table

Table 3-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 3-6 have no effect when executed outside the context of replication. See “Marked objects table”.

**Table 3-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)

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

View this book as PDF