need help

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

need help

Postby gopinath » Wed Jun 28, 2006 8:07 am

I am a new user of Dipendency tracker.i have tried to display the dipendency of the particular table.it shows all the tables and strored procedures which is depending on that table.it has very huge no of dependent objects.so it is very difficult to fit the diagram properly.
i want to display only stored procedures which is depending on a particular table.can u please help me ?

thanks

regards,
gopi.
gopinath
 
Posts: 1
Joined: Wed Jun 28, 2006 7:07 am

Postby Brian Donahue » Wed Jun 28, 2006 5:40 pm

Hi Gopi,

The way I did this was to start a new project, then add only the one table that I was interested in from the list of tables in the database. Now I had a display of only the objects that were linked to that table. To weed out everything but the stored procedures, you can use the drop-down list on the right-hand side to show only the stored procedures. Then, in the right-hand pane, you end up with a list of nothing but stored procedures that reference that table.

Maybe there is another way of doing this, but this is how I managed to do it.
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests