BizTalk Server - Transaction Deadlock.

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server > March 2005 > Transaction Deadlock.





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Transaction Deadlock.
vishal

2005-03-30, 5:51 pm

Hello All,
I am trying to insert into the SQL DB by calling the SP from a .Net assembly
in my BizTalk orchestration. While inserting large number of transactions I
am getting the following error.
Transaction (Process ID 95) was deadlocked on lock resources with another
process and has been chosen as the deadlock victim. Rerun the transaction.

Is there a way I can configure to consume single thread. Or if anyone can
tell me how can I resolver this issue.
Thanks is Advance,
Vishal.

Winson

2005-03-30, 5:51 pm

Hi,

This is more of a SQL Question but please review the thread here >>
http://groups-beta.google.com/group...b6034fd74c6899f

The solution may be to implement locking hints (select with nolocks) on
your reads...

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com