Finding a DLL SQL Assembly with only the Database in SQL Server

Question

How do I find a DLL for a SQL Assembly in SQL Server if I only have the database?

Answer 1

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