Re: Help, SQL adapter deadlocked!!!

Hi,
follow all recomendations from the SQL Server documentation to avoid
deadlocks.
There are some generic rules, you'll see them.

--

Regards,

Leonid Ganeline
BizTalk Developer,
Microsoft Certified Technology Specialist: BizTalk Server 2006
http://geekswithblogs.net/leonidganeline/
<twang090@xxxxxxxxx> wrote in message
news:1168885934.501076.103860@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Following in event log, "The adapter failed to transmit message going
to send port "SQL_StatusUpdate" with URL
"SQL://mlisilctgdfosql/Aff_STP_T1/". It will be retransmitted after the
retry interval specified for this Send Port.
Details:"HRESULT="0x80004005" Description="Transaction (Process ID 162)
was deadlocked on lock resources with another process and has been
chosen as the deadlock victim. Rerun the transaction.""

Anyone, please help! Thanks in advance.



.

Loading