In this example, these commands were executed at a primary database, NYDS.nydb:
sp_setreplicate emp_queue, true insert emp_queue values("123456789", "Davis", "Gen", "Process Engineer","1/1/95", 1111) insert emp_queue values("987654321", "Irvine", "Ben", "Microwave Engineer","3/5/94", 2222) grant all on emp_queue to public
To view the inbound queue of the primary Replication Server:
sysadmin dump_queue, 102,1,-1,1,-2
I. 2006/07/05 08:27:05. BLOCK BEGIN q_number=102 q_type=1 blk=0:4 cnt=10 I. 2006/07/05 08:27:05. Begin Transaction Origin User=sa Tran Name=rs_logexec I. 2006/07/05 08:27:05. ENTRY ver=1100 len=216 orig=102 lorig=0 oqid=00000000000016c7000004ff0005000004ff0005 000097f5008af20b0000000000000000 lqid=0:4:0 st=4 tr= '00000000000016c70005' NYDSnydb comlen=97 begin transaction I. 2006/07/05 08:27:05. ENTRY ver=1100 len=204 orig=102 lorig=0 oqid=00000000000016c7000004ff0007000004ff0005 000097f5008af20b0000000000000000 lqid=0:4:1 st=1 tr= '00000000000016c70005' NYDSnydb comlen=86 commit transaction I. 2006/07/05 08:27:05. Begin Transaction Origin User=sa Tran Name=_ins I. 2006/07/05 08:27:05. ENTRY ver=1100 len=208 orig=102 lorig=0 oqid=00000000000016c7000004ff0008000004ff0008 000097f5008af20b0000000000000000 lqid=0:4:2 st=4 tr= '00000000000016c70008' NYDSnydb comlen=91 begin transaction I. 2006/07/05 08:27:05. ENTRY ver=1100 len=524 orig=102 lorig=0 oqid=00000000000016c7000004ff0009000004ff0008 000097f5008af20b0000000000000000 lqid=0:4:3 st=2097152 tr= '00000000000016c70008' NYDSnydb comlen=406 insert into dbo.emp_queue (emp_id, emp_first, emp_last, emp_title, emp_date, id) values ('123456789', 'Gen', 'Davis', 'Process Engineer', '1/1/95', 1111) I. 2006/07/05 08:27:05. ENTRY ver=1100 len=204 orig=102 lorig=0 oqid=00000000000016c7000004ff000a000004ff0008 000097f5008af20b0000000000000000 lqid=0:4:4 st=1 tr= '00000000000016c70008' NYDSnydb comlen=85 commit transaction I. 2006/07/05 08:27:05. Begin Transaction Origin User=sa Tran Name=_ins I. 2006/07/05 08:27:05. ENTRY ver=1100 len=208 orig=102 lorig=0 oqid=00000000000016c7000004ff000b000004ff000b 000097f5008af20b0000000000000000 lqid=0:4:5 st=4 tr= '00000000000016c7000b' NYDSnydb comlen=91 begin transaction I. 2006/07/05 08:27:05. ENTRY ver=1100 len=528 orig=102 lorig=0 oqid=00000000000016c7000004ff000c000004ff000b 000097f5008af20b0000000000000000 lqid=0:4:6 st=2097152 tr= '00000000000016c7000b' NYDSnydb comlen=409 insert into dbo.emp_queue (emp_id, emp_first, emp_last, emp_title, emp_date, id) values ('987654321', 'Ben', 'Irvine', 'Microwave Engineer', '3/5/94', 2222) I. 2006/07/05 08:27:05. ENTRY ver=1100 len=204 orig=102 lorig=0 oqid=00000000000016c7000004ff000d000004ff000b 000097f5008af20b0000000000000000 lqid=0:4:7 st=1 tr= '00000000000016c7000b' NYDSnydb comlen=85 commit transaction I. 2006/07/05 08:27:05. Begin Transaction Origin User=sa Tran Name=_grrev I. 2006/07/05 08:27:05. ENTRY ver=1100 len=212 orig=102 lorig=0 oqid=00000000000016c7000004ff000e000004ff000e 000097f5008af20b0000000000000000 lqid=0:4:8 st=4 tr= '00000000000016c7000e' NYDSnydb comlen=93 begin transaction I. 2006/07/05 08:27:05. ENTRY ver=1100 len=204 orig=102 lorig=0 oqid=00000000000016d2000005010016000004ff000e 000097f5008af20b0000000000000000 lqid=0:4:9 st=1 tr= '00000000000016c7000e' NYDSnydb comlen=85 commit transaction
Q_type=1
An inbound queue.
Tran Name=rs_logexec
Name of the transaction sp_setreplicate.
Tran Name=_ins
Adaptive Server uses transaction name _ins for implicit insert transactions.
Tran Name=_grrev
The grant and revoke permission commands get a special transaction name from the Adaptive Server.
You will see all begin, commit, and rollback commands regardless of whether or not the transactions contain changes that need to be replicated. When the RepAgent reads the log, it does not know whether or not the transaction includes changes to objects that are marked for replication. Because future versions of Replication Server may change this scheme to optimize for network traffic, you should check your current version of Replication Server for this behavior.