How to get list of Procedures that uses a particular function

Question

0.00/5 (No votes)

See more:

SQL-Server

How to get list of user defined procedures that uses a particular User defined function.

Thanks,
Deepak

Posted 4-Jun-13 1:11am

deepakdynamite

Add a Solution

3 solutions

Solution 3

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

Posted 4-Jun-13 9:52am

RedDk

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

gvprabu · Accepted Answer · 2013-06-04T01:17:00

Solution 2

hi,

Check the following Code

SQL

SELECT DISTINCT OBJECT_NAME(ID) FROM syscomments WHERE text LIKE '%Your_UDF_Name%'

Regards,
GVPrabu

Posted 4-Jun-13 1:17am

gvprabu

Updated 4-Jun-13 1:18am

v2

Comments

Maciej Los 4-Jun-13 7:20am

+5!

gvprabu 4-Jun-13 7:31am

thank u.... :-)

Aarti Meswania · Accepted Answer · 2013-06-04T01:15:00

Solution 1

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

Posted 4-Jun-13 1:15am

Aarti Meswania

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