Dead Lock

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

  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.