title: sql server deadlock issue on a single table
body: <p>I have one table let's say "xxx "in sql server 2000 . One .exe is inserting data into that table "xxx" through  sql job. But once data is inserted , one stored procedure is reading the data from that "xxx table "and inserting/updating into other two tables and updating back the status into the same "xxx" table. Now, client says that multiple deadlocks are occuring on that "xxx" table . please kindly anyone sdvice me the resolution steps to be taken to resolve this deadlock issue and how to identify it step by step.............</p>
  
  <p>Thanks in advance.....
  XXX</p>