Three types of Microsoft SQL Server database objects are used for transaction log components:
Tables
Stored procedures
Triggers
There are several tables used by the Replication Agent transaction log, both as base objects and as shadow tables for marked primary tables in the primary database. All table components of the transaction log contain at least one index, and some contain more than one index.
Stored procedures are used by the Replication Agent transaction log to capture transactions for replication.
Triggers are used to capture the insert, update, and delete operations in marked primary tables.
