특정 프로시저와 연관있는 객체 찾기

Select
    a.Name,
    dependObjectType = Case c.xType When 'U' Then 'Table' When 'P' Then 'Procedure' When 'TF'
          Then 'Function' End,
    dependObject = c.Name
From
    sysobjects a
        Join (Select id,depid From sysdepends group by id,depid) b On a.id = b.id
        Join sysobjects c On b.depid = c.id
Where
    a.xtype = 'P' and left(a.name,2) <> 'dt'
        and a.name like '%프로시저명%'
Order By a.Name,dependObjectType