Friday, December 13, 2019

Sample SQL script to delete messages in Service Broker Queue manually

SQL Script:

  1. declare @ch uniqueidentifier
  2. while(1=1)
  3. begin
  4. select top 1 @ch = conversation_handle from [dbo].[YourQueueName]
  5. if (@@ROWCOUNT = 0)
  6. break
  7. end conversation @ch with cleanup
  8. end

No comments:

Post a Comment