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
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)