Transaction log base tables  Marker procedures and shadow tables

Chapter 3: Replication Agent for Microsoft SQL Server

Transaction log stored procedures

Table 3-4 lists the stored procedures that are considered Replication Agent transaction log base objects. Execute permission is granted to public when these stored procedures are created.

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

Table 3-4: Replication Agent transaction log stored procedures

Procedure

Database name

Transaction information capture

prefixget_tx_info_xxx

Log truncation

prefixtruncate_logs_xxx





Copyright © 2005. Sybase Inc. All rights reserved. Marker procedures and shadow tables

View this book as PDF