Coding Tips, Code Samples, Bug Fixes, Articles & More
Pages
▼
Friday, December 13, 2019
Sample SQL script to delete messages in Service Broker Queue manually
SQL Script:
declare @ch uniqueidentifier
while(1=1)
begin
select top 1 @ch = conversation_handle from [dbo].[YourQueueName]
if (@@ROWCOUNT = 0)
break
end conversation @ch with cleanup
end
No comments:
Post a Comment