FN-FORUM: Can anyone recommend a SQL tool that...

date posted 3rd August 2005 09:13

Lets you list out database object dependancies ? So that if you have a
function that is used by 4 stored procedures, one of which is used by
another stored procedure which goes to a table in a different database,
e.g.,

Function < SP < SP < server2.table

The sp_depends system SP is no use because if you have recursive stored
procedures or functions then the dependancy information doesn't get
created and I'm not sure it's possible to recreate. So it's going to be
an external tool that can analyse the database objects, parse them and
extract allt he objects used by each one before drilling down into each
one.

Cheers
Andy