How to check whether the StoreProcedure or Function or Objects used in other StoreProcedure or Function or Objects.

Hi,
   Here I will Query you how to check whether the Store Procedure or Function is used in other Objects. Place your Procedure or Function by replacing ‘Procedure_OR_Function_Name’ with your StoreProcedure or Function name and run the Query. You will get the Result if the object is used.

Query

    SELECT OBJECT_NAME(id)
    FROM syscomments
    WHERE [text] LIKE '% Procedure_OR_Function_Name %'

    GROUP BY OBJECT_NAME(id)