开发者

DLL needed after assembly creation?

Can I delete 开发者_Python百科the DLL-File C:\PATH\TO\DLL\FILE.DLL after creating an assembly with

CREATE ASSEMBLY MyAssemblyName FROM 'C:\PATH\TO\DLL\FILE.DLL'

?

Everything seems to work fine after deleting the file. But

SELECT * FROM sys.assembly_files

shows the path of the file in the name column. Can this cause problems? (or is the content of the DLL stored in the database)


The assembly bits are transfered into the database, the original DLL location is irelevant. The idea is that an SQL loaded assembly should continue to work after a backup and restore on a different machine, it has to be entirely contained inside the database.


It's actually stored in sys.assembly_files so can be deleted

This means it's an integral part of the database through backuo/restore, attach/detach etc

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜