title: Stored procedures are timing out intermittently!
body: <p>I have a number of stored procedures I call from code with <code>ExecuteNonQuery</code>.</p>
  
  <p>It was all good but 2 of my stored procedures started timing out intermittently today with:</p>
  
  <blockquote>
    <p>Timeout expired.  The timeout period
    elapsed prior to completion of the
    operation or the server is not
    responding. The statement has been
    terminated.</p>
  </blockquote>
  
  <p>If I execute the sp manually from management studio it's still all good.</p>
  
  <p>Nothing recently changed in my db - my command timeout is the default one.</p>
  
  <p>Any clue?</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>the table against the SPs are running it's huge --> 15 Gigs.
  Rebooted the box - same issue but this time can't get the sp to run from Management Studio either.</p>
  
  <p>Thanks!</p>