az*****@hotmail.com (Bodi) wrote in
news:89**************************@posting.google.c om:
Hi,
Is there a way in SQL Server, or Access to determine what fields are
being used in reports or joins, etc?
Scenario:
Field A in Table 1 is going to be either deleted or change data types,
and I'd like to know what impact that will have.
Yes...No?
Thanks,
Bodi
(s/field/column/g to appease Mr. Celko.)
Given that reports are something that a client creates, there's no way SQL
Server can report on what columns are used by a report.
The "Generate SQL script" function of SQL Enterprise Manager can be told to
include dependent objects, which means that if you generate the script for
Table 1, you can also get all tables and views that depend on table 1.
If you put a trace on your server, you can catch all statements issued
against a particular table or column. Or, you could add a trigger to your
table that could catch all inserts/updates/deletes against it. Not
selects, though, I don't think. Trace would seem to be your only option
there.