Link to home
Start Free TrialLog in
Avatar of anushahanna
anushahannaFlag for United States of America

asked on

Tables & SP dependency

I can look in information_schema.routines to see all the SPs. But I need a report like the foll:

TableName1, <List Of all the SPs that reference table1, separated by delimiter>
TableName2, <List Of all the SPs that reference table2, separated by delimiter>
......
for all the tables in the DB.

can you please suggest a way to accomplish this?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of RiteshShah
RiteshShah
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of anushahanna

ASKER

Ritesh, I am getting this error:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.sql_expression_dependencies'.
Ritesh the code you gave might be only specific to SQL 2008?