title: Creating custom assembly in SQL Server throwing assembly not found in database error
body: <p>I am trying to create an assembly for a third party dll (developed in .net) in SQL Server 2008 for CLR  procedure project,</p>
  
  <pre><code>create assembly [`XXXX.XXX.XXX.dll`]  
  authorization dbo  
  from 'C:\Windows\Microsoft.NET\Framework\v2.0.50727\XXXX.XXX.XXX.dll'  
  with permission_set = unsafe
  </code></pre>
  
  <p>But I'm getting this error while executing the above script:</p>
  
  <blockquote>
    <p><em>Assembly 'XXX.XXX.XXX.XXX' references assembly 'XXX.XXX.XXXXX',
    version=0.0.0.0, culture=neutral, publickeytoken=null.', which is not
    present in the current database. SQL Server attempted to locate and
    automatically load the referenced assembly from the same location
    where referring assembly came from, but that operation has failed
    (reason: 2(The system cannot find the file specified.)). Please load
    the referenced assembly into the current database and retry your
    request.</em></p>
  </blockquote>
  
  <p>I appreciate your help in solving this issue</p>