SELECT DISTINCT s.name, p.name,
db = COALESCE(d.referenced_database_name, DB_NAME()),
obj = COALESCE(d.referenced_schema_name, s.name) + N'.'
+ d.referenced_entity_name
FROM sys.sql_expression_dependencies AS d
INNER JOIN sys.procedures AS p
ON p.[object_id] = d.referencing_id
INNER JOIN sys.schemas AS s
ON p.[schema_id] = s.[schema_id]
ORDER BY p.name, obj;
No comments:
Post a Comment