title: Timeout issue - SQL Server Native Client 10.0, TCP Provider - Error 258
body: <p>Apology if this is already answered somewhere.</p>
  
  <p>I have a very complex stored procedure which takes date range as parameters and perform some actions. The problem is it is timing out when I provide longer range of dates. It is totally working fine with those ranges from SQL Server Management Studio.</p>
  
  <p>Environment:</p>
  
  <pre><code>Windows Server 2008, SQL Server 2008, PHP, IIS, 
  SQL Server Driver (php_sqlsrv_53_ts_vc6)
  </code></pre>
  
  <p>Error I am getting:</p>
  
  <pre><code>[Microsoft][SQL Server Native Client 10.0]TCP Provider: Timeout error [258].
  </code></pre>
  
  <p>How can I increase Time of execution for this procedure or overall for the application?</p>