Viewing post 1 (of 1 total)
You can use the below to find out the parent procedure
SELECT*
FROMsys.dm_sql_referencing_entities('dbo.' + @ChildProcedureName ,'OBJECT')
February 4, 2012 at 12:32 am
#1442723