We have a database that has been copied, including stored procedures and some user defined functions. I'd like to check whether a UDF is being used. Is there a way to see which stored procedures call the UDF?
You can find out the referencing entity dependencies for your function or any other database entities by using DMV
dm_sql_referencing_entities. An example statement is as below.
Select referencing_schema_name, referencing_entity_name, referencing_id, referencing_class_desc, is_caller_dependent from sys.dm_sql_referencing_entities ('dbo.ufn_MyFunction', 'OBJECT');