Skip to content

Instantly share code, notes, and snippets.

@ghotz

ghotz/clear-broker-queue.sql

Forked from jdaigle/gist:2781349
Last active July 25, 2019 20:27
Show Gist options
  • Save ghotz/c5d710827d1ebb29bb8489a543dd319b to your computer and use it in GitHub Desktop.
Save ghotz/c5d710827d1ebb29bb8489a543dd319b to your computer and use it in GitHub Desktop.
Download ZIP
SQL Server Service Broker: Short Script to clear empty a named queue
Raw
clear-broker-queue.sql
DECLARE @handle UNIQUEIDENTIFIER;
WHILE (SELECT COUNT(*) FROM NameOfQueue) > 0
BEGIN
RECEIVE TOP (1) @handle = conversation_handle FROM NameOfQueue;
END CONVERSATION @handle WITH CLEANUP
END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment