摘要：在cmd命令提示符中输入以下命令进行检测ssbdiagnose CONFIGURATION FROM SERVICE T1ToT2_SenderService -S 192.168.0.110 -U sa -p 123456 -d T1DB TO SERVICE T1ToT2_ReceiverService -S 192.168.0.111 -U sa -p 123456 -d T2DB ON CONTRACT T1ToT2_Contract 阅读全文

摘要：A poison message is a message containing information that an application cannot successfully process. A poison message is not a corrupt message, and may not be an invalid request.Service Broker provides automatic poison message detection. When a transaction that contains a RECEIVE statement rolls ba 阅读全文

摘要：Exception Message:The activated proc [dbo].[storedprocedure_name] running on queue [QUEUE_NAME] output the following:'The server principal "sa" is not able to access the database "AnotherDBName" under the current security context.'SOLUTION:The problem is that the activati 阅读全文

摘要：在我们开发service broker应用时候，可能用于测试或者客户端没有配置正确等导致服务端队列存在很多垃圾队列，不便于我们排查错误，我们可以使用SQL脚本来清空服务端这些垃圾数据：USETestDBdeclare@conversationuniqueidentifierwhileexists(select1fromsys.transmission_queue)beginset@conversation=(selecttop1conversation_handlefromsys.transmission_queue)endconversation@conversationwithcleanu 阅读全文