I was trouble shooting a slow running stored procedure and found the main culprit was the use of a scalar user defined function (UDF). As you know when a scalar UDF is used, it can cause real performance issues. I was able to solve the issue by removing the affending function but then started wondering if any of my other stored procedures were having the same issue without me knowing it.
So I came up with this script that looks at all the functions in a given database and then searches for them in all the stored procedures. It will give you a list of the stored procedure names and a count of the UDFs in each. Then it will give you a list of stored procedure and the names of the UFDs called by that stored procedure.
Beware that if you have a large number of functions and / or stored procedures, it can run for awhile. I would run it during the off hours on a prduction server just to be safe.