db process blocking issue

[Mullin]

i got db processes locked sometimes. when i looked at the property of each
process at Enterprise Manage, i found out the process running the following
sql statements

1. an embedded Insert sql statement which is running at C# program.
transaction statement has been used

2. a stored procedure which will select records from the same table at step
1 and then update it. it has the transaction statement too.

how transaction locking/isolation at the c# and stored procedure can make
sure that no blocking issue. it's because when blocking happens, the
database will be timeout!!

any ideas?

 

[Mohamoss]

Hi Myllin
Unfortunately , you have to make sure that blocking will not happen your
self so you would try to re arange your program to make sure that no
blocking situation is going to happened . Or ,at least , you need to detect
that when it happens and take some action to restart on of the blocked
operations ....