Red Gate forums :: View topic - Missing Dependent Objects
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Dependency Tracker 2
SQL Dependency Tracker 2 forum

Missing Dependent Objects

Search in SQL Dependency Tracker 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
tadewusi



Joined: 24 Apr 2007
Posts: 3

PostPosted: Tue Apr 24, 2007 11:23 am    Post subject: Missing Dependent Objects Reply with quote

I have been using SQL dependency tracker for sometimes now. It looked good initially. I recently discovered that the tool doesn't track all dependencies on a specific object. I'm working on a project that involves daily use of this tool. I have to manually write SQL script to extract/track dependencies across multiple databases.
The weird part of this tool is that it will display the target object as being used by another object, but it will never display the object's dependencies when it is the only object in the project.
Confused I updated from schema but to no avail.

Is there something I'm not doing right? May be configuration settling?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6649

PostPosted: Tue Apr 24, 2007 10:38 pm    Post subject: Reply with quote

Hello,

There is an option in 'Project Options' called 'Add objects that the selected objects use'. This should allow you to choose one object, and Dependency Tracker will pull all of the related objects into the diagram.

If you have any further questions, please let me know.
Back to top
View user's profile Send private message
tadewusi



Joined: 24 Apr 2007
Posts: 3

PostPosted: Wed Apr 25, 2007 9:18 am    Post subject: Reply with quote

I tried just now. It is still not giving its dependencies. Like I said, if you choose one of the known dependencies, the object will appear as a dependent object. Question
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6649

PostPosted: Mon Apr 30, 2007 9:14 am    Post subject: Reply with quote

Is the object type a table? I think that if the table is related to another table by a foreign key, you need to add the table that actually has the foreign key constraint on it first.
Back to top
View user's profile Send private message
tadewusi



Joined: 24 Apr 2007
Posts: 3

PostPosted: Mon Apr 30, 2007 2:42 pm    Post subject: Reply with quote

It's a function. The problem has corrected itself. I think there is something wrong somewhere. I don't know why this problem should have occured in the first instance. I had to rely on using T-SQL scripts to get the dependent objects.
Your technical team should please look into this anomaly in the next version.
Back to top
View user's profile Send private message
sreed



Joined: 23 Jul 2007
Posts: 1

PostPosted: Mon Jul 23, 2007 3:32 pm    Post subject: Reply with quote

I am having the same issue.

I have 3 table functions A, B, and C.
function A uses funciton B, which in turn uses function C.

Dependecy Tracker finds the dependency b/t B & C, but not A & B. I have even recompiled all of the functions in the order C, B, A, and that did not work. However, "View Dependencies" in SQL Server does pick up the dependencies.

Any thoughts?

Thanks,
Shane
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group