title: Transaction (Process ID) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction
body: <p>I have a C# application which is inserting data into SQL Server (2008) table using stored procedure. I am using multi-threading to do this. The stored procedure is being called from inside the thread.
  Now my stored procedure is using "tablock" while inserting data.
  While executing this code I am getting the following error:
  "Transaction (Process ID) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction."</p>
  
  <p>Can anyone please help me with any solution to this?</p>