Hi Ankush,

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.

http://technet.microsoft.com/en-us/library/ms189487.aspx

Regards,

Durani