You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
5 lines
425 B
5 lines
425 B
SELECT ISNULL(CONVERT(varchar,AM.execute_as_principal_id),'CALLER') as ExecuteAs, P.type, AF.name AS assembly_name, AM.assembly_class, AM.assembly_id, AM.assembly_method, P.object_id, S.name as owner, P.name as name
|
|
FROM sys.procedures P
|
|
INNER JOIN sys.schemas S ON S.schema_id = P.schema_id
|
|
LEFT JOIN sys.assembly_modules AM ON AM.object_id = P.object_id
|
|
LEFT JOIN sys.assemblies AF ON AF.assembly_id = AM.assembly_id |