title: When does a Stored Procedure recompile?(Sql Server)
body: <p>I guess,</p>
  
  <p>When i use  temporary table in Stored Procedure ,the stored procedure 
  will be automatically recompiled.</p>
  
  <p>Kindly give me the other possibilites.</p>