Printed 2017/08/21 10:13AM

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

Copyright © 2002-2017 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.