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.
USE AdventureWorks
GO
SELECT specific_name,specific_schema
FROM information_schema.routines
WHERE routine_type='function'
GO
Reference : Pinal Dave (http://blog.SQLAuthority.com)
This is another way to do the same thing:
SELECT *
FROM sys.objects
WHERE type_desc = ‘SQL_SCALAR_FUNCTION’
Please refer to: http://whereclause.com/blog/?p=26
Hi all,
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….