Contents Index sp_queue_read procedure sp_queue_set_confirm procedure

SQL Remote User's Guide
  Command Reference for Adaptive Server Enterprise

sp_queue_reset procedure


Purpose 

To reset the server to a point where the stable queue is empty.

Syntax 

sp_queue_reset

Description 

This procedure is used by the SQL Remote Message Agent, and should not be called directly in a production environment. It deletes all rows from the stable queue sr_transaction table, and resets the sr_queue_state table, ready for a new SQL Remote setup.

In a development phase, this procedure can be useful to reset the server.


Contents Index sp_queue_read procedure sp_queue_set_confirm procedure