Collection Contents Index sp_queue_set_confirm procedure sp_queue_transaction procedure pdf/chap18.pdf

Data Replication with SQL Remote
   PART 4. Reference
     CHAPTER 18. Command Reference for Adaptive Server Enterprise       

sp_queue_set_progress procedure


Purpose 

This procedure is used by the SQL Remote Message Agent, and should not be called directly.

Syntax 

sp_queue_set_progress page_id, row_id, commit_offset, backup_offset, marker

Description 

This procedure is used by the SQL Remote Message Agent, and should not be called directly. It sets the transaction log scanning progress value in the sr_queue_state table.


Collection Contents Index sp_queue_set_confirm procedure sp_queue_transaction procedure pdf/chap18.pdf