Is there a way to script out the endpoints. I get info back when I do a select * from sys.endpoints but how do I figure out the endpoints authorization. I see a principal_id but what system table does that relate to.
I get this when I try to setup the following endpoint.I can create the endpoint when I do authentication = windows but that is not what I need here. There are two instances on different domains. Create Endpoint MemberUpdateTargetEndpoint
Ok, I am getting a disabled queue as a result of message poisoning, i guess. The question is. The correct steps to enable are remove the suspect conversations from the transmission queue
I have service broker running between two instances. That works fine. What I am doing when I get the response back from the target is to log the response time and some other information out of the xml (cast as varchar). So I call the stored proc and it fails everytime. I have a ...