I received the next message in the EventLog:
The following stored procedure call failed: " { call [dbo].[bts_UpdateMsgbox_BizTalkServerApplication]( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}". SQL Server returned error string: "Warning: The join order has been enforced because a local join hint is used.;Warning: The join order has been enforced because a local join hint is used.;Duplicate key was ignored.".
It seems that when SQL Server is very busy, these errors can occur. I’m working with BizTalk Server 2009, SQL Server 2008 and Windows Server 2008. When I solved the performance problem, these messages disappeared.
