When a SQL Server object is created that references another SQL Server object, such as a stored procedure called from a trigger, that dependency is recorded by the database engine. This article details how to get at that dependency information.

This story continues at http://www.databasejournal.com/featu...SQL-Server.htm