Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Object dependencies in sql server 2005

Author  Topic 

anjaliv
Starting Member

10 Posts

Posted - 2011-06-20 : 15:01:18
Hi,

I am new to sql server 2005. I need to find dependencies between database objects. I have used SQL dependency tracker tool by red gate. But it will show 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?
Thanks in advance.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-07-08 : 05:08:10
I dont think there is an easy way of doing it. You should first create the objects and then refer in other objects

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -