SQL Server Query to list stored procedure inner objects:
Please mention Actual procedure/Funtion/View Name in Place of 'StoredProcedureName'
SELECT Object_name(referencing_id) ParentObject,
referenced_entity_name InnerObject,
type_desc,
create_date,
modify_date
FROM sys.sql_expression_dependencies d
INNER JOIN sys.objects o
ON d.referenced_entity_name = o.name
WHERE Object_name(referencing_id) = 'StoredProcedureName'
Thanks,
Dinesh Babu
No comments :
Post a Comment