Suppose you were asked ‘Find me all procedures that use the sp_send_dbmail procedure’
1
2
3
4
SELECT *
FROM sys.all_sql_modules AS asm
INNER JOIN sys.objects AS o ON o.object_id = asm.object_id
WHERE asm.definition LIKE '%sp_send_dbmail%'
Run this on the database you want to check.