Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Is there a quick way of dropping a Service Broker queue
- declare @conversationHandle uniqueidentifier
- select top 1 @conversationHandle = conversation_handle from sys.conversation_endpoints
- while @@rowcount = 1
- begin
- end conversation @conversationHandle with cleanup
- select top 1 @conversationHandle = conversation_handle from sys.conversation_endpoints
- end
Add Comment
Please, Sign In to add comment