Dead Lock

1

Hi All,

I have one procedure which is getting executed in one loop which is running in Vb.Net. Event though i am checking the procedure with unique conditions but still some time get dead lock error.

Any suggestions

2
  1. post the proc
  2. check the isolation levels.
  3. Are you running the proc in a transaction
  4. you can use SQL Profiler (if this is not a production server) to show the deadlock, if you can reproduce the deadlock at will.