http://www.sqlservercentral.com/blogs/basits-sql-server-tips/2012/08/12/how-to-list-all-clr-objects-inside-your-database/

Printed 2014/04/19 07:56AM

How to list all CLR objects inside your database?

2012/08/12

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-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.