title: How refresh to refresh C# CLR code (assembly) in SQL Server?
body: <p>I implemented the <a href="http://msdn.microsoft.com/en-US/library/ms254956%28v=vs.80%29.ASPX" rel="nofollow">"HelloWorld" sample of a CLR stored procedure</a>, and it worked. </p>
  
  <p>I then changed the code, recompiled, and re-ran it, and got the old results, not the new results. </p>
  
  <p>Example Code Change (all other code is in above link): </p>
  
  <p>Before:</p>
  
  <pre><code>SqlContext.Pipe.Send("Hello world!\n");
  </code></pre>
  
  <p>After: </p>
  
  <pre><code>SqlContext.Pipe.Send("Hello world new version!\n");
  </code></pre>
  
  <p>Is there anything short of recycling SQL to get the new assembly loaded? </p>