Hi

Is it possible to logg witch tables and fields in a
database that are used.

/Maria

Yes, but how depends on what you are asking.

1. You can query tables that have records.
2. You can add a timestamp to a table and determine if new records have been
added.

As far as having SQL Server monitor this activity, it gets easier in version
2005, which opens up a wide number of sources of information for
administration.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************
<anonymous (AT) discussions (DOT) microsoft.com> wrote