Getting List of CLR’s Registered in Database in SQL Server

Hello everyone,

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.

54 Views

Yavuz Selim Kart

I try to explain what I know in software and database. I am still improving myself by doing research on many programming languages. Apart from these, I am also interested in Graphic Design and Wordpress. I also have knowledge about SEO and Social media management. In short, I am a determined person who likes to work hard.

You may also like...

Don`t copy text!