Re: Can you Log Individual database usage?

From: Andrew J. Kelly (ajkellynospam_at_attbi.com)
Date: 06/24/03 

Date: Mon, 23 Jun 2003 20:08:36 -0400

You would have to use a tool such as profiler or one of the 3rd party
monitoring tools on a constant basis to do something like that. But you
will end up with a lot of data that you will have to weed through to find
the answers. There really isn't any good way to do this. Of coarse you
could always set the suspected obsolete db's to read only and see if anyone
complains<g>. 

-- 
Andrew J. Kelly
SQL Server MVP
"Kevin" <kkohn@strykerendo.com> wrote in message
news:039101c339cf$e1a92cc0$a601280a@phx.gbl...
> Does anybody know if it is possible to log which users
> access which databases over a span of time on SQL 7?
> We are migrating and I hope to clean up obsolete
> databases.
>
>