Newbie-How to tell when Database last used

I Inherited a SQL 2000 Server with some databases I think are no longer used
.
I'm not sure on some of them what apps may be using them. How can I tell
when a database or any of its tables were last used? I don't really care
what the specific transactions were, just when it was touched. There are
database maint jobs backing up the databases. Does this imply that the
datestamps of the files change when they are backed up, and therefore not a
good indication of when they were last used?
Thanks."Coop" <Coop@.discussions.microsoft.com> wrote in message
news:33770A94-B003-400A-88F6-9DE689625A91@.microsoft.com...
>I Inherited a SQL 2000 Server with some databases I think are no longer
>used.
> I'm not sure on some of them what apps may be using them. How can I tell
> when a database or any of its tables were last used? I don't really care
> what the specific transactions were, just when it was touched. There are
> database maint jobs backing up the databases. Does this imply that the
> datestamps of the files change when they are backed up, and therefore not
> a
> good indication of when they were last used?
> Thanks.
There's no easy way to do this.
The timestamp on the file for example only changes when the database is
opened or the file size is changed.
You can setup a profiler to watch the database.
Or simply detach it and see who squawks first.
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Greg D. Moore (Strider) wrote:
> "Coop" <Coop@.discussions.microsoft.com> wrote in message
> news:33770A94-B003-400A-88F6-9DE689625A91@.microsoft.com...
> There's no easy way to do this.
> The timestamp on the file for example only changes when the database is
> opened or the file size is changed.
> You can setup a profiler to watch the database.
> Or simply detach it and see who squawks first.
>
Taking the DB offline may be simplier...