方法1：使用sp_depends

sp_depends 'dbo.First'
 GO

方法2：使用information_schema.routines

SELECT *
 FROM information_schema.routines ISR
 WHERE CHARINDEX('dbo.First',ISR.ROUTINE_DEFINITION) > 0
 GO

方法3：使用DMV sys.dm_sql_referencing_entities

SELECT referencing_schema_name,referencing_entity_name,referencing_id,referencing_class_desc,is_caller_dependent
 FROM sys.dm_sql_referencing_entities ('dbo.First','OBJECT');
 GO