Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

logging SELECT's on tables

0 views
Skip to first unread message

chooven

unread,
Oct 17, 2002, 11:29:25 AM10/17/02
to

I have a database that I need to know when and how much the tables
are being used. What I need is a way to log the user and the IP would
be great..

Thanks for any input

--
Posted via http://dbforums.com

BP Margolin

unread,
Oct 17, 2002, 7:33:19 PM10/17/02
to
See if using SQL Server Profiler can accommodate your needs. Documentation
on SQL Server Profiler is available in the SQL Server Books Online.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"chooven" <mem...@dbforums.com> wrote in message
news:1940178.1...@dbforums.com...

Jim Andersen

unread,
Oct 18, 2002, 6:25:08 AM10/18/02
to
> > I have a database that I need to know when and how much the tables
> > are being used. What I need is a way to log the user and the IP would
> > be great..

Restrict access to tables. Only go through stored procs, that write to a
logfile.

/jim


0 new messages