title: SQL Server - force NO recompile stored procedure
body: <p>I would like to know if exists some command to force NO RECOMPILE of a stored procedure.
  I have a procedure that take about 5 minutes to executed. But when I run directly in the Query windows it takes just few seconds. This sp have a temporary table. </p>
  
  <p>My question is: Is there any way to force a stored procedure to avoid recompilation???</p>
  
  <p>Note: I am using SQL Server 2005.</p>