Use sysadmin dump_tran to dump the statements of a specific stable queue transaction into a log file. The transaction is identified through the LQID.
The sysadmin dump_tran syntax is:
sysadmin dump_tran {{, q_number, | server [,database]}, q_type, lqid [, num_cmds] [, {L0 | L1 | L2 | L3}] [, {RSSD | client | “log” | file_name}] | “next” [, num_cmds]}