HostWeb Forums » Microsoft Databases » microsoft.public.sqlserver.servicebroker » Clean up the sys.transmission_queue
Topic: Clean up the sys.transmission_queue
How do I get rid of the messages in there. I am setting up a previously
installed service broker solution. I hooked up the initiator and then they
got replication going and now I have 127k messages in the queue. The latest
error message I get is this.
Dialog security is not available for this conversation because there is no
remote service binding for the target service. Create a remote service
binding, or specify ENCRYPTION = OFF in the BEGIN DIALOG statement.
I don't want remote service binding so I removed them and will change the
Begin Dialog to Encryption = OFF. I have a private vpn tunnel so don't want
to add another level of encryption. How do I clean out those entries in the
transmission queue? Do I need to set the remote service bindings and let
them clean out or is there a quicker way of doing it.
Thanks,
jc
Replies below ↓
Replies
RE: Clean up the sys.transmission_queue
A quicker way is to query for the conversation_handle from the
sys.transmission DMV and do an END CONVERSATION {GUID} WITH CLEANUP to remove
the message.
--
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration /
Microsoft Office SharePoint Server 2007: Configuration)
MCITP (dbadmin, dbdev)
"John Cantley" wrote:
> How do I get rid of the messages in there. I am setting up a previously
> installed service broker solution. I hooked up the initiator and then they
> got replication going and now I have 127k messages in the queue. The latest
> error message I get is this.
>
> Dialog security is not available for this conversation because there is no
> remote service binding for the target service. Create a remote service
> binding, or specify ENCRYPTION = OFF in the BEGIN DIALOG statement.
>
> I don't want remote service binding so I removed them and will change the
> Begin Dialog to Encryption = OFF. I have a private vpn tunnel so don't want
> to add another level of encryption. How do I clean out those entries in the
> transmission queue? Do I need to set the remote service bindings and let
> them clean out or is there a quicker way of doing it.
>
> Thanks,
> jc
>
>
>