title: SQL Server 2008 R2 how to create ASSEMBLY
body: <p>I am trying to run an assembly I have saved the project and the dll file in the mapped drive on my PC to the server:</p>
  
  <pre><code>USE &lt;TEMP&gt;
  GO
  
  CREATE ASSEMBLY [BooksMgr]
  AUTHORIZATION [dbo]
  FROM 'Z:\FY_2011-12\04 Individual\JohanZ\BooksMgr\BooksMgr\bin\Release\BooksMgr.dll' 
  WITH PERMISSION_SET = SAFE
  GO
  </code></pre>
  
  <p>and the error I am getting:</p>
  
  <blockquote>
    <p><em>CREATE ASSEMBLY failed because it could not open the physical file<br>
    "Z:\FY_2011-12\04
    Individual\JohanZ\BooksMgr\BooksMgr\bin\Release\BooksMgr.dll":21<br>
    (failed to retrieve text for this error. Reason: 15105).</em></p>
  </blockquote>