title: Create CLR stored procedure using the dll created by .net framework 4.0 in sql server 2008. Is shows error
body: <p>I am using the below code for CLR stored procedure creation. While I am creating the assembly. it shows the below issue. My target framework is 4.0. sql server is 2008 r2</p>
  
  <p>SQL code: </p>
  
  <pre><code>create assembly SampleSearch from 'E:\CLR Files\Sample\ElasticSearch.dll'
  </code></pre>
  
  <p>error message: </p>
  
  <blockquote>
    <p>CREATE ASSEMBLY for assembly 'ElasticSearch' failed because the
    assembly is built for an unsupported version of the Common Language
    Runtime.</p>
  </blockquote>