Deletes a stable queue. Use this command to drop a failed materialization queue.
sysadmin drop_queue, <q_number>, <q_type>
The site ID for the Replication Server or database that is the source or destination for the queue.
The queue type.
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.
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.
sysadmin drop_queue requires “sa” permission.