Example 3: Inbound Queue after update

This update command was executed at the primary database:

update emp_queue
   set emp_first = "General"
   where emp_id = "123456789"

Dump the inbound queue of the primary Replication Server:

sysadmin dump_queue, 102,1,-1,1,-2

Output:

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