Find SQL Server dependencies
Let's say you've created some fantastic stored procedure or User Defined Function (UDF) in SQL Server. You then want to make a change to the proc or function and you want to know all the other procs that call it. Naively, you may think that Enterprise Manager or sp_depends will tell you that information. But it won't.
In order to find all callers of your function, you can use a query like this:
SELECT object_name(id), Text
FROM SysComments
WHERE Text LIKE '%MyFunc%'