• Liked the idea of quickly getting a list of dependent procs. I took your sql and modified it...

    SELECT

    SCHEMA_NAME(o.schema_id) + '.' + o.name AS proc_name,

    SCHEMA_NAME(o2.schema_id) + '.' + o2.name AS dependent_proc_name

    FROM

    sysdepends d

    LEFT JOIN sys.objects o

    ON d.id = o.object_id

    LEFT JOIN sys.objects o2

    ON d.depid = o2.object_id

    ANDo2.Type = o.Type

    WHERE

    o.Type = 'p'

    AND o2.object_id IS NOT NULL

    ORDER BY

    1, 2