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
Post a Comment