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

date posted 3rd August 2005 11:42

http://www.sqlmanager.net/en/products

Does it for the postgres databases, and they do a manager for SQL Server
as well. If you activate the SQL monitor; you can see the commands it
issues to do things like list dependencies.

Lite Versions free

> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] On
> Behalf Of Andy Macnaughton-Jones
> Sent: 03 August 2005 09:51
> To: FN-FORUM / [EMAIL REMOVED]
> Subject: FN-FORUM: Can anyone recommend a SQL tool that...
>
>
>
> 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
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>