Get List of ASSEMBLY and PATH

Get List of assembly and there paths

SELECT 
    assembly = saa.name, 
    path     = af.name
FROM sys.assemblies AS sa
INNER JOIN sys.assembly_files AS af
ON sa.assembly_id = af.assembly_id
WHERE sa.is_user_defined = 1;

Leave a Reply

Your email address will not be published. Required fields are marked *