title: Very Simple Stored Procedure Will Time Out
body: <p>I have a problem with this one stored procedure that works 99% of the time throughout our application, but will time out when called from a particular part of the application. </p>
  
  <p>The table only has 3 columns and contains about 300 records. The stored proc will only bring back one record and looks like this </p>
  
  <p>"Select * from Table Where Column = @parameter"</p>
  
  <p>When the sp is executed in management studio it takes :00 seconds. </p>
  
  <p>The stored procedure is used a lot in our application, but only seems to time out in one particular part of our program. I can't think of any reason why such a simple sp would time out. Any ideas?</p>
  
  <p>This is a vb.net desktop application and using sql server 2005.</p>