clr - When you register an assembly in SQL Server using CREATE ASSEMBLY - where does SQL Server store it? -


When you register CREATE ASSEMBLY using an assembly in SQL Server - Where does SQL Server store it?

The following statement registers an assembly with SQL Server, but I want to know where it is stored by SQL Server

  create assembly [YaddyYaddy] 'C: \ YaddyYaddy.dll' PERMISSION_SET = with UNSAFE; The short answer is that the actual upload DLL code  Sys.assembly_files    / Strong>, within the database which was loaded in the assembly.  

See sys.assemblies, sys.assembly_files, and sys.assembly_moduleules (and follow the object_id link sys.objects) for details of stored assemblies.

Comments