2011年3月10日 下午 04:44
Recently. my service broker audit system is displaying the following messages in Profiler "This message was dropped because it could not be dispatched on time.'. My understanding is that this particular issue was fixed in SP2 CU4. The server in question is SQL Server 2005 at version number 9.0.4226. I believe this is SP3 CU4. Anyone else having this issue and how to fix it?
2011年3月14日 上午 09:41版主
As you said, this issue had been fixed SQL Server 2005 SP2 CU4, please see:
Service Pack 4 (SP4) for Microsoft SQL Server 2005 is now available, could you please download and install? Please see:
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
- 已標示為解答 Ai-hua QiuModerator 2011年3月20日 上午 09:25
2011年8月7日 下午 12:47
Dear Ai-Hua Qiu,
I am using SQL Server 2008 R2 and I'd the same error.
This message was dropped because it could not be dispatched on time. State: 1
2011年12月9日 下午 12:02I have the same error on SQL Server 2008R2.
2012年3月19日 上午 05:34
I have the same problem at the destination. "This message was dropped because it could not be dispatched on time. State: 2".
Do you got any solution?
Madhavan Thasu Ramachandran