Visualizes SQL Server object dependencies.
Moderators: David Atkinson, Anu Deshpande, Luke Jefferson
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?
- Posts: 1
- Joined: Mon Jun 20, 2011 8:35 pm
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.
- Posts: 757
- Joined: Tue Oct 24, 2006 2:12 pm
- Location: Red Gate Software Ltd.
Return to SQL Dependency Tracker 2
Who is online
Users browsing this forum: No registered users and 0 guests