locked
Where is my .DLL stored? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    After I issue this command:

    CREATE ASSEMBLY MyAssembly from 'C:\MyDLL.dll' WITH PERMISSION_SET = SAFE

    I can delete C:\MyDLL.dll file and assembly can still be referenced.

    Where is the copy stored? Is it stored as .DLL file somewhere on Windows File System or is it stored in database table?
    Friday, March 12, 2010 9:36 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    It's stored in SQL Server, in the database itself. You can even extract it from there. Have a look at the "content" column in sys.assembly_files; its your assembly (or one of the related files that you or Visual Studio autodeploy added) in binary.

    Cheers,
    Bob Beauchemin
    SQLskills
    • Marked as answer by JoeSchmoe115 Friday, March 12, 2010 10:47 PM
    Friday, March 12, 2010 10:44 PM