Check out the sys.assembly_modules
view:
select * from sys.assembly_modules
This should list all functions and the assemblies they’re defined in. See the Books Online help page about it.
Returns one row for each function,
procedure or trigger that is defined
by a common language runtime (CLR)
assembly.