title: How to clear cache of 1 stored procedure in sql server
body: <p>I am using SQL Server 2008 R2. </p>
  
  <p>I know that <code>DBCC FREEPROCCACHE</code> will clear cache of all stored procedures in SQL Server. </p>
  
  <p>But what I need is to clear cache of only 1 stored procedure. How can I do that?</p>
  
  <p>The Stored Procedure name is <code>Rpt_RegionReport</code>. I don't want to execute the stored procedure with <code>WITH RECOMPILE</code> option.</p>