SELECT DISTINCT '['+user_name(b.uid)+'].['+b.name+']' AS 对象名,b.type AS 类型
FROM sysdepends a,sysobjects b
WHERE b.id=a.depid
AND a.id=OBJECT_ID('过程名');
EXEC SP_DEPENDS '过程名';
SELECT DISTINCT referenced_entity_name
FROM sys.dm_sql_referenced_entities ('dbo.HookCheck', 'object');