Getting List of CLR’s Registered in Database in SQL Server
In this article, I will provide information on how to get the list of CLRs registered in the database in SQL Server.
In some cases in SQL Server there may be a need to get the list of CLRs registered in the database.
You can easily do this using the code below.
SELECT o.name AS ObjectName, a.name AS Assembly, o.type_desc AS ObjectType FROM sys.assembly_modules am JOIN sys.objects o ON am.object_id = o.object_id JOIN sys.assemblies a ON a.assembly_id = am.assembly_id WHERE a.is_user_defined = 1 UNION SELECT at.name, a.name, 'Type' FROM sys.assembly_types at JOIN sys.assemblies a ON at.assembly_id = a.assembly_id WHERE a.is_user_defined = 1;
Good luck to everyone in business and life.