积极答复者
sql2005迁移到sql2008后 查询通知服务失效

问题
答案
-
Profiler doesn't gather much info of service broker, you can find details in views listed under 'Service Broker Catalog Views (Transact-SQL)' in books online.
- 已标记为答案 WeiLin QiaoModerator 2011年6月2日 1:32
全部回复
-
Hi rmiao, today I'v tried to trace Service Broker in Profiler. After some operations had been performed in my APP. I found there were only two results for Service Broker in Server Profiler.
1. Broker:Conversation Group ........... 1 - Create........................ sa ...................."
2. Broker:Conversation ............ sa .................. STARTED_OUTBOUND................initiator..............default..............
It means that my APP just had been created Broker Conversation successful, but Broker Service had not sent message to APP. Right?
What should I do?
-
Profiler doesn't gather much info of service broker, you can find details in views listed under 'Service Broker Catalog Views (Transact-SQL)' in books online.
- 已标记为答案 WeiLin QiaoModerator 2011年6月2日 1:32