title: CREATE ASSEMBLY for assembly 'dotnetpiper.CLR' failed because assembly 'microsoft.visualbasic.activities.compiler'
body: <p>I am facing an issue during <code>CREATE ASSEMBLY</code> command in SQL Server, error message is given below:</p>
  
  <blockquote>
    <p>Msg 6544, Level 16, State 1, Line 19<br>
    CREATE ASSEMBLY for assembly 'dotnetpiper.CLR' failed because assembly 'microsoft.visualbasic.activities.compiler' is malformed or not a pure .NET assembly.<br>
    Unverifiable PE Header/native stub</p>
  </blockquote>
  
  <p>I'm using this query:</p>
  
  <pre class="lang-sql prettyprint-override"><code>CREATE ASSEMBLY dotnetpiper
  from 'D:\My\dotnetpiper.CLR.dll'
  WITH PERMISSION_SET = UNSAFE
  </code></pre>
  
  <p>Please advise me of any mistakes I'm making. I've not found anything helpful so far on this.</p>