Example 1
Select * from vwDependencies where name = 'procname'
finds all tables, routines, triggers invoked by procname
Example 2
select * from vwDependencies v inner join
sys.syscomments c on v.name = object_name(c)
where c.text = '['''']code[''']'
find all stored procedures that have 'code' embedded in them and display all the dependencies thereof. Useful for finding hardcoded values that could otentiall be inserted into more than one table.
Example 3
select * from vwDependencies v inner join
sys.syscomments c on v.name = object_name(c)
where c.text = '['''']code[''']' and updates = 1
find the tables updated in Example 2.
Thanks to Angel Rappalo who published the Routine Dependency Visualizer upon which this work is based.
