How do I list all table dependencies for a set of stored procedures easily?

JustinButler · August 5, 2021 7:45PM

I have a large production database that has hundreds of sprocs and hundreds of tables. I need to gather all of the tables needed for a specific set of sprocs (not everything). What is the easiest way to do this? If I add just stored procedures I am looking for it doesn't list all the tables like I would expect. What am I missing?

Eddie D · August 11, 2021 1:25PM

Hi JustinButler, thank you for your forum post.

According to https://documentation.red-gate.com/sdt/making-a-dependency-diagram when a user adds an object, it should also automatically add the objects that use that object - which is the problem since the tables won't use the sproc.

This means you most likely need to do this bit to have the process to add things that the object uses:

By default, SQL Dependency Tracker also adds all objects that reference the objects you chose to add.
To change this behavior:
Click Options.
The Project Options dialog opens.
Click the Diagram tab, and select the options you want.
For information about the diagram options and what they mean, see Diagram options.
Click OK.

And in the diagram options tab the user will need to check the boxes on the bottom part so that objects the sproc uses/references are also added

Image: https://documentation.red-gate.com/sdt/files/44861921/44861922/1/1409236909550/SDT_diagram_options.png

I hope the above answers your question.

Many Thanks
Eddie

How do I list all table dependencies for a set of stored procedures easily?

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk