Pls correct me if i'm wrong....
Have your tried sp_depends ?
Note : This feature will be removed in a future version of Microsoft SQL Server.
Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Use sys.dm_sql_referencing_entities and sys.dm_sql_referenced_entities instead.