anushahanna
asked on
Tables & SP dependency
I can look in information_schema.routine s 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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ritesh the code you gave might be only specific to SQL 2008?
ASKER
Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.sql_expression_depend