SQL Remote User's Guide
Command Reference for Adaptive Server Enterprise
To reset the server to a point where the stable queue is empty.
sp_queue_reset
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.