Thursday, March 10, 2011 4:44 PM
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?
Monday, March 14, 2011 9:41 AMModerator
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.
- Marked As Answer by Ai-hua QiuModerator Sunday, March 20, 2011 9:25 AM
Sunday, August 07, 2011 12:47 PM
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
Friday, December 09, 2011 12:02 PMI have the same error on SQL Server 2008R2.
Monday, March 19, 2012 5:34 AM
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