SQLTeam.com | Weblogs | Forums

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.