Posted by www.ITjobfeed.com on 02/27/07 14:33
Obviously you could run traces while the db is running-- although this could
cause some resource descrease.
You could also do direct searches in all the sys tables for instances of the
keywords you are using
--
Jack Vamvas
___________________________________
The latest IT jobs - www.ITjobfeed.com
<a href="http://www.itjobfeed.com">UK IT Jobs</a>
<oraustin@hotmail.com> wrote in message
news:1172498745.473644.252660@t69g2000cwt.googlegroups.com...
> Our database(s) are all over the place - no documentation - lot's of
> rubbish and unused stuff.
> I'm managing a project focusing on data quality that covers code
> changes, alterations to DTS packages, schema changes etc etc.
>
> What I'd like to do is see where the bit I want to change is being
> used.
> that might mean what stored procs use a field and what sprocs use that
> sproc.
> maybe it's which dts packages use a sproc (and again up the
> hieararchy)
>
> The list is a long one but basically I need to know what the effects
> are of changes.
> Is there a tool out there that lets me navigate a database to that
> level of detail - I understand something along the same lines is
> available for MS Access but I can't find it for SQL Server.
>
> Thanks
>
[Back to original message]
|