Transaction log object names  Transaction log stored procedures

Chapter 3: Replication Agent for Microsoft SQL Server

Transaction log base tables

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



Copyright © 2005. Sybase Inc. All rights reserved. Transaction log stored procedures

View this book as PDF