title: Time-out occurred while waiting for buffer latch type 2 for page
body: <p>I'm having the following timeout error when I put the computer to sleep while a SQL select process was running and bringing it back up online.</p>
  
  <blockquote>
    <p>Time-out occurred while waiting for buffer latch type 2 for page (1:53), database ID 10.</p>
  </blockquote>
  
  <p>Because it takes time for the computer to unsleep, the process fails and is waiting for something from the SQL Server that just woke up.</p>
  
  <p>Is there a way to set this time out (increase it) in C#, in like <code>SqlCommand</code>, <code>SqlDataAdapter</code> from .NET?</p>