SQLTeam.com | Weblogs | Forums

Deadlock Proplem


#1

i am using vb6 and sql 2005
when i make concurrent update deadlock error occure


#2

Is it possible that, for example, one process is doing

UPDATE TableA ...
UPDATE TableB ...

and another process is doign

UPDATE TableB ...
UPDATE TableA ...

?

That is the classic deadly-embrace situation.


#3

Please have look on this thread and Know How to Handle Deadlock in SQL Server