Click here to Skip to main content
15,895,142 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
How to get list of user defined procedures that uses a particular User defined function.


Thanks,
Deepak
Posted

Visit link...
http://blog.strictly-software.com/2009/12/find-text-inside-stored-procedure-or.html[^]
pass your functionName to search as parameter in above link store procedure
Happy Coding!
:)
 
Share this answer
 
Comments
Maciej Los 4-Jun-13 7:21am    
+5
Aarti Meswania 4-Jun-13 7:39am    
Thank you!
:)
deepakdynamite 5-Jun-13 0:05am    
Thanks Aarti... You saved my hours... Thanks Alot
Aarti Meswania 5-Jun-13 5:57am    
Welcome!
Glad to help you!: )
hi,

Check the following Code
SQL
SELECT DISTINCT OBJECT_NAME(ID) FROM syscomments WHERE text LIKE '%Your_UDF_Name%'

Regards,
GVPrabu
 
Share this answer
 
v2
Comments
Maciej Los 4-Jun-13 7:20am    
+5!
gvprabu 4-Jun-13 7:31am    
thank u.... :-)
For starters ...
SELECT * FROM INFORMATION_SCHEMA.ROUTINES ...

Robust ... and more robust if used in conjunction with some known information such as table columns:
SPECIFIC_CATALOG    SPECIFIC_SCHEMA SPECIFIC_NAME   ROUTINE_CATALOG ROUTINE_SCHEMA  ROUTINE_NAME    ROUTINE_TYPE    MODULE_CATALOG  MODULE_SCHEMA   MODULE_NAME UDT_CATALOG UDT_SCHEMA  UDT_NAME    DATA_TYPE   CHARACTER_MAXIMUM_LENGTH    CHARACTER_OCTET_LENGTH  COLLATION_CATALOG   COLLATION_SCHEMA    COLLATION_NAME  CHARACTER_SET_CATALOG   CHARACTER_SET_SCHEMA    CHARACTER_SET_NAME  NUMERIC_PRECISION   NUMERIC_PRECISION_RADIX NUMERIC_SCALE   DATETIME_PRECISION  INTERVAL_TYPE   INTERVAL_PRECISION  TYPE_UDT_CATALOG    TYPE_UDT_SCHEMA TYPE_UDT_NAME   SCOPE_CATALOG   SCOPE_SCHEMA    SCOPE_NAME  MAXIMUM_CARDINALITY DTD_IDENTIFIER  ROUTINE_BODY    ROUTINE_DEFINITION  EXTERNAL_NAME   EXTERNAL_LANGUAGE   PARAMETER_STYLE IS_DETERMINISTIC    SQL_DATA_ACCESS IS_NULL_CALL    SQL_PATH    SCHEMA_LEVEL_ROUTINE    MAX_DYNAMIC_RESULT_SETS IS_USER_DEFINED_CAST    IS_IMPLICITLY_INVOCABLE CREATED LAST_ALTERED
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900