Guest User

Untitled

a guest
Aug 15th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. Is there a quick way of dropping a Service Broker queue
  2. declare @conversationHandle uniqueidentifier
  3. select top 1 @conversationHandle = conversation_handle from sys.conversation_endpoints
  4. while @@rowcount = 1
  5.  
  6. begin
  7. end conversation @conversationHandle with cleanup
  8. select top 1 @conversationHandle = conversation_handle from sys.conversation_endpoints
  9. end
Add Comment
Please, Sign In to add comment