title: How to get the processes running the sql server
body: <p>I am getting the deadlock problem in our database on a table . </p>
  
  <p>I am getting the following error message :</p>
  
  <pre><code>3/13/2015 11:37:35 AM
  System.Data.SqlClient.SqlException: Transaction (Process ID 143) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
  at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
  at clsdb.clsDB.execcmd(String strsql)
  at clspllog.Clspllog.RunXPSPushliveResponse(String pushtype, String journalname, String strvol, String strissue, String articleid, String PushLiveResponseTime, Int32 plstatus, String plstatusmsg, String strerrmsg)
  </code></pre>
  
  <p>There is one method named <code>RunXPSPushliveResponse</code> using the table <code>articleschedule</code> . it is trying to update this table , but it got the above error message.</p>
  
  <p>I am not able to know which is another process which is using this table. 
  thus not able to take any action.</p>
  
  <p>Is there some way so I got the processes using this table or any other way . Totally blank with this issue. Any hint will be much appreciated. I am fresher, so don't have much ideas to rectify this.</p>
  
  <p>Any help is appreciated.</p>