Posted by Cindy on 10/03/07 23:53

On Oct 3, 1:52 pm, Ed Murphy <emurph...@socal.rr.com> wrote:
> Cindy wrote:
> > If we had the ability to generate a database table that lists joins
> > that were used - imagine a tool where you plug in the names of 4
> > tables, for example, and then you get a report where you see all the
> > fields, join types, and join type operators that were used between
> > those 4 tables - along with the frequency of use. It seems it would
> > go a long way toward getting a database in better shape to document
> > common relationships.
>
> You might want to run a Profiler trace for a while, send output to a
> new table, then query the table for accesses to a table that you're
> interested in. You can also look at sysobjects and syscomments to
> determine which views access a given table (especially if the Profiler
> output cites the view rather than the underlying tables; I've mostly
> used Profiler to deal with stored procedures accessing tables directly,
> so I don't know the answer to that one without testing it).

Good idea - thanks all!

[Back to original message]