I think I finally have the broker set up correctly. I have a bunch of entries on the transmission queue and would like to clear them out. I tried the following and it works to a point but doesn't work on older conversations. I see the conversation on the queue but when I try and ...
I am setting up service broker to replace a batch job. I got everything set up and ready to go. When I did my first message test I get broker not enabled in the transmission_queue. So I found this statement Alter database xxx set Enable_Broker With Rollback Immediate.
I read the Service Broker Tutorials, which have a description of using Windows authentication for "a conversation between instances". And I read the book, Pro SQL Server 2005 Service Broker, which has a description of using certificate-based authentication for such a conversation ...