Can anypne help me and give me a script.
Script to find table dependencies of all stored procedure in a database.
Thanks in advance.
I don't have a script but you could start with these two DMVs, they may provide you what you need:
Alternatively, try the trial of Redgate's SQL Dependency Tracker, then if you like it, buy it :D Its saved us tonnes of time in the past and the export options are brilliant.
21 People are following this question.