sysadmin drop_queue

Deletes a stable queue. Use this command to drop a failed materialization queue.

Syntax

sysadmin drop_queue, <q_number>, <q_type>

Parameters

q_number: The site ID for the Replication Server or database that is the source or destination for the queue.
q_type: The queue type.

Usage

Use sysadmin drop_queue to stop and delete a materialization queue that remains after a subscription experiences an unrecoverable error and must be manually cleaned up.

Caution
Use sysadmin drop_queue only to drop a failed materialization queue.
Use admin who to find the <q_number> and <q_type> for a queue. The values appear in the command’s SQM thread output.

Permissions

sysadmin drop_queue requires “sa” permission.