title: How to increase Timeout in stored procedure of SQL Azure
body: <p>I have one stored procedure in SQl Azure is calling periodically at 5 minutes and processing crore of data and it sometimes give Timeout error as per below as per my log.</p>
  
  <blockquote>
    <p>Timeout expired.  The timeout period elapsed prior to completion of
    the operation or the server is not responding.</p>
  </blockquote>
  
  <p><strong>How can i increase Timeout of this query or whole Db? and what would be default Timeout?</strong></p>
  
  <p><strong>Update</strong></p>
  
  <p>I think Time out is not due to connection to sql azure here as per answers of @Ming and @Ruchit because when i have checked the log then below error it will display message like</p>
  
  <blockquote>
    <p>Warning: Null value is eliminated by an aggregate or other SET
    operation.</p>
  </blockquote>
  
  <p>It means query is being executed, above message because of i have used some aggregate function on NULL value. Am i thinking correct? what should be other possible cause?</p>
  
  <p>Thanks in Advance.</p>