TSQL to show available CLR objects -
SELECT objects.object_id
,schema_name(objects.schema_id) + '.' + objects.[name] AS [CLRObjectName]
,objects.type_desc as [CLRType]
,objects.create_date as [Created]
,objects.modify_date as [Modified]
,assemblies.permission_set_desc AS [CLRPermission]
FROM sys.objects objects
INNER JOIN
sys.module_assembly_usages module_assembly_usages
ON objects.object_id = module_assembly_usages.object_id
INNER JOIN
sys.assemblies AS assemblies
ON module_assembly_usages.assembly_id = assemblies.assembly_id
No comments:
Post a Comment