User's Manual

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.
420