--

-- Get a list of objects that a particular sproc, view, etc is dependent on.

--

SELECT DISTINCT o1.name AS Item, o2.name AS DependentOn

FROM sysdepends d

JOIN sysobjects o1 ON d.id = o1.id

JOIN sysobjects o2 ON d.depid = o2.id

WHERE o1.name = /* Add your queried item here. */;

 

--

-- Given an object name find all items that are dependent on it.

--

SELECT DISTINCT o1.name as Item, o2.name as DependentOn

FROM sysdepends d

JOIN sysobjects o1 ON d.id = o1.id

JOIN sysobjects o2 ON d.depid = o2.id

WHERE o2.name = /*Add your queried item here. */;