Blog Post

How to list all CLR objects inside your database?

I wrote the following query that returns the list of all CLR functions/procedures/objects exists inside your database:

SELECT o.object_id AS [Object_ID]
      ,schema_name(o.schema_id) + '.' + o.[name] AS [CLRObjectName] 
      ,o.type_desc AS [CLRType] 
      ,o.create_date AS [Created] 
      ,o.modify_date AS [Modified] 
      ,a.permission_set_desc AS [CLRPermission] 
FROM sys.objects o 
INNER JOIN sys.module_assembly_usages ma
    ON o.object_id = ma.object_id 
INNER JOIN sys.assemblies a
    ON ma.assembly_id = a.assembly_id

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating