CREATE PROCEDURE SP1
AS
BEGIN
SELECT GETDATE() AS DATE
END
CREATE PROCEDURE SP2
AS
BEGIN
EXEC SP1
END
CREATE PROCEDURE SP3
AS
BEGIN
EXEC SP1
END
CREATE PROCEDURE SP4
AS
BEGIN
EXEC SP1
END
SELECT referencing_entity_name
FROM sys.dm_sql_referencing_entities (‘SP1’, ‘OBJECT’);
OR
Select name from sys.procedures
where OBJECT_DEFINITION(OBJECT_ID) like ‘%SP1%’