sp_depends will show you the dependencies for an object in sql, but here's a really cheap way to execute that for everything. i had someone ask me how to do this in sql the other day so here it is. you can also just tear into sp_depends and use that with a CTE as well.
set transaction
isolation level
read uncommitted
declare @a sysname
declare c cursor
FAST_FORWARD for
select specific_name from INFORMATION_SCHEMA.ROUTINES
open c
while (1=1)
begin
fetch next
from c into @a
if @@fetch_status
<> 0 break
exec sp_depends
@a
end
close c
deallocate c