title: Deploying my first SQLCLR stored procedure to Amazon RDS SQL Server instance
body: <p>At my current consulting assignments they are letting me use CLR Sprocs which is great (some past engagements did not for bogus reasons).</p>
  
  <p>I followed all the steps at:</p>
  
  <p><a href="https://msdn.microsoft.com/en-us/library/5czye81z(v=vs.90).aspx" rel="nofollow">https://msdn.microsoft.com/en-us/library/5czye81z(v=vs.90).aspx</a></p>
  
  <p>but made a simple Sproc in Visual Studio:</p>
  
  <pre class="lang-cs prettyprint-override"><code>using System.Diagnostics;
  public partial class StoredProcedures
  {
      [SqlProcedure]
      public static void TestCLR_001 ()
      {
         Debug.Write("Hello World");
      }
  }
  </code></pre>
  
  <p>and my admin ran:</p>
  
  <pre class="lang-sql prettyprint-override"><code>sp_configure 'show advanced options', 1;
  GO
  RECONFIGURE;
  GO
  sp_configure 'clr enabled', 1;
  GO
  RECONFIGURE;
  GO
  </code></pre>
  
  <p>But when I build solution or deploy solution no errors but they never make it to SQL Server. I.e.</p>
  
  <pre class="lang-sql prettyprint-override"><code>use pls;
  
   Exec TestCLR_001;
  </code></pre>
  
  <p>does not work.</p>
  
  <blockquote>
    <p>Msg 2812, Level 16, State 62, Line 3<br>
    Could not find stored procedure 'TestCLR_001'.</p>
  </blockquote>