Red Gate forums :: View topic - Finding dependency between 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

Finding dependency between objects

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



Joined: 20 Jun 2011
Posts: 1

PostPosted: Mon Jun 20, 2011 8:44 pm    Post subject: Finding dependency between objects Reply with quote

I am trying to find the dependencies between the database objects and I come to know that ool shows only those dependencies which are written into DB metadata.
For example, if you create SP which callls other Sp (child) which weren't created yet (or not saved to DB yet), it will miss such dependency.

Is there any way to find such dependencies?
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Wed Jun 22, 2011 11:33 am    Post subject: Reply with quote

Thanks for your post.

It sounds like you're more looking to find invalid references to objects in your schema, rather than dependencies between objects.

We have another tool called SQL Prompt 5 which has a feature called 'find invalid objects'. When you run this it will search through your database and find any objects that have bad references. i.e. references to missing columns in views, stored procedures that don't exist etc.

This might be what you're looking for.

I hope this helps.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
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