Finding dependency between objects

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

Finding dependency between objects

Postby Bartakke Kiran » Mon Jun 20, 2011 8:44 pm

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?
Bartakke Kiran
 
Posts: 1
Joined: Mon Jun 20, 2011 8:35 pm

Postby Chris Auckland » Wed Jun 22, 2011 11:33 am

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
Chris Auckland
 
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