Few days ago, I wrote about SQL SERVER – Find All The User Defined Functions (UDF) in a Database. Regular reader of this blog Madhivanan has suggested following alternate method to do the same task of finding all the user defined functions in database.
Reference : Pinal Dave (https://blog.sqlauthority.com)
This is another way to do the same thing:
WHERE type_desc = ‘SQL_SCALAR_FUNCTION’
Please refer to:
I need a query which give name of all stored procedure and view which are using a specific function.
For Example:- i have a User defined function in my database named “usp_split”.
I want to get list of all Stored Procedure and View which are using this function.
Thanks in advance.
EXEC sp_depends ‘usp_split’
thanks a lot madhivanan….
How to find function definition in sql server ( ex for SP we use sp_helptext ‘SPName’)