In this example, this update command was executed at the primary database:
update emp_queue set emp_first = "General" where emp_id = "123456789"
Execute the sysadmin dump_queue command to view the inbound queue of the primary Replication Server:
sysadmin dump_queue, 102,1,-1,1,-2
I. 2006/07/05 08:29:52. BLOCK BEGIN q_number=102 q_type=1 blk=0:5 cnt=3 I. 2006/07/05 08:29:52. Begin Transaction Origin User=sa Tran Name=_upd I. 2006/07/05 08:29:52. ENTRY ver=1100 len=208 orig=102 lorig=0 oqid=00000000000016e3000005020002000005020002 000097f5008bedfe0000000000000000 lqid=0:5:0 st=4 tr= '00000000000016e30002' NYDSnydb comlen=91 begin transaction I. 2006/07/05 08:29:52. ENTRY ver=1100 len=568 orig=102 lorig=0 oqid=00000000000016e3000005020004000005020002 000097f5008bedfe0000000000000000 lqid=0:5:1 st=2097152 tr= '00000000000016e30002' NYDSnydb comlen=451 update dbo.emp_queue set emp_id='123456789', emp_first='General', emp_last='Davis', emp_title='Process Engineer', emp_date='1/1/95', id=1111 where id=1111 I. 2006/07/05 08:29:52. ENTRY ver=1100 len=204 orig=102 lorig=0 oqid=00000000000016e3000005020005000005020002 000097f5008bedfe0000000000000000 lqid=0:5:2 st=1 tr= '00000000000016e30002' NYDSnydb comlen=85 commit transaction
Tran Name=_upd
Adaptive Server uses transaction name upd for implicit update transactions. RepAgent reads this name from the log.
