title: SQL Server 2008 error message from stored procedure
body: <p>I am using SQL Server 2008 Enterprise. When we met with such error message from stored procedure,</p>
  
  <blockquote>
    <p>Message 1205, Level 13, State 52, the
    process Pr_FooV2, Line 9 Services
    (Process ID 111) and another process
    is deadlock in the lock |
    communication buffer resources, and
    has been chosen as the deadlock
    victim. Rerun the transaction.</p>
  </blockquote>
  
  <p>I am wondering whether such messages are stored in log files? I searched log folder of my SQL Server 2008 installation root (in my environment, it is C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log), but can not find such files.</p>
  
  <p>thanks in advance,</p>
  
  <p>George</p>