יום שני 12 מרץ 2012 08:52
in initiator database ,i use this t-sql:
select * from sys.transmission_queue;
find some messages didn't send.the to_broker_instance is null.
i use :
select * from sys.conversation_endpoints;
find this message's endpoints state is 'CO'.
I use conversation_id to select * from sys.conversation_endpoints in traget dabase.find that's conversation_endpoints state is 'DO'.
and I find the same message is sended twice！the first message's conversation is not found,the second message's conversation is same as above!
so,what can I do ?
יום חמישי 15 מרץ 2012 02:48what's the sql server version? Are both target and initiator on the same instance?
יום חמישי 15 מרץ 2012 10:58
Please capture the profiler traces (on both sender and target instances)with all the broker events and some RPC statement events. It will help you to understand the reason why the messages are not being sent:
Here is a very good link :- http://rusanu.com/2005/12/20/troubleshooting-dialogs/ to understand service broker issues.