title: How to set SQL Server 2008 R2 remote transaction time out
body: <p>I have written a stored procedure which is executing from a c# windows from application. I am connecting to the server using an entity data model.</p>
  
  <p>The problem is my stored procedure takes more than 4 minutes to execute and complete its process</p>
  
  <p>BUT whenever I am executing it gives error</p>
  
  <blockquote>
    <p>Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.</p>
  </blockquote>
  
  <p>As I searched this is due to remote transaction time out because I am executing it from my c# code because when i am executing it from server it always complete with no error </p>
  
  <p>PLS HELP ME.. </p>