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.
WARNING! 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.
