Transaction log base tables

Table 2-3 lists the tables that are considered Replication Agent transaction log base objects. No permissions are granted on these tables when they are created.

Table 2-3: Replication Agent transaction log base tables

Description

Database name

Transaction log system table

prefixxlog_system_

Marked objects table

prefixmarked_objs_xxx

Transaction log table

prefixtran_log_xxx

LOB columns table

prefixblob_column_xxx

Exception holding table

prefixexception_xxx

Transaction sequence counter table

prefixtran_seq_xxx

Procedure sequence counter table

prefixproc_seq_xxx

Log Reader work table

prefixlr_reptran_xxx

Log Admin work table

prefixrawork_xxx

Transaction active table

prefixtranactive_xxx

Procedure active table

prefixprocactive_xxx