Credits:
Description
Code
SELECT @@SERVERNAME AS Referencing_Server ,DB_NAME() AS Referencing_Database ,so.Type_Desc AS Referencing_Object_Type ,OBJECT_SCHEMA_NAME(so.object_id) AS Referencing_Object_Schema ,so.name AS Referencing_Object_Name ,Referenced_Server_Name AS Referenced_Server ,Referenced_Database_Name AS Referenced_Database ,Referenced_Schema_Name AS Referenced_Object_Schema ,Referenced_Entity_Name AS Referenced_Object_Name ,CASE WHEN Referenced_Database_Name IS NULL THEN 0 ELSE 1 END AS Is_Cross_Database_Reference ,CASE WHEN Referenced_Server_Name IS NULL THEN 0 ELSE 1 END AS Is_Cross_Server_Reference FROM sys.sql_expression_dependencies sed INNER JOIN sys.objects so ON sed.referencing_id = so.object_id WHERE is_ambiguous = 0; |