CREATE ASSEMBLY失败，因为它无法打开物理文件 [英] CREATE ASSEMBLY failed because it could not open the physical file

问题描述

CREATE ASSEMBLY失败，因为它无法打开物理文件（设备尚未就绪）

CREATE ASSEMBLY failed because it could not open the physical file (The device is not ready

CREATE ASSEMBLY ROCEventHandler
AUTHORIZATION dbo
FROM 'C:\WINDOWS\assembly\a.dll'
WITH PERMISSION_SET = SAFE
GO

推荐答案

您可以尝试查看此MSDN链接



如何：使用公共语言运行时集成创建和运行SQL Server用户定义函数



因为不支持..确保您在尝试以当前代码中的方式引用它之前首先创建了该程序集。还要确保程序集不引用其他程序集，否则您将首先需要创建这些程序集。



确保在Z中要查找的目录中创建程序集：在引用之前

you may try looking at this MSDN Link

How to: Create and Run a SQL Server User-Defined Function by using Common Language Run-time Integration

As as side not.. make sure that you have created that Assembly first before trying to reference it in the way you are doing in your current code..also make sure that assembly does not reference other assemblies otherwise you will need to create those assemblies first as well..

Make sure the assembly is created in the directory you are looking for in Z: prior to referencing as well

这篇关于CREATE ASSEMBLY失败，因为它无法打开物理文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！