title: SQL query to get the deadlocks in SQL SERVER 2008
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/720508/help-with-deadlock-in-sql-server-2008">Help with deadlock in Sql Server 2008</a>  </p>
  </blockquote>
  
  
  
  <p>SQLServer automatically logs all deadlocks. Can anyone help me to get sql query which will  capture deadlocks data that is being collected, for a recent event.</p>
  
  <p>I am using SQL SERVER 2008 R2 for my development activities.</p>
  
  <p>Thanks &amp; Regards,
  Santosh Kumar Patro</p>