Friday, October 12, 2012

SQL Query to list stored procedure inner objects

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