Read/edit history

I have inherited several SQL 7 database and would like to know is there a
way for me to determine the last time they were accessed or written to by a
user or application?
--
Any and all contributions are greatly appreciated ...
Regards TJHi,
You have to either,
1. Write triggers to audit the activity
2. Enable the SQL Profiler.
FYI, You can make use of Sysprocesses table for online users, but once he
log off the entry will be removed.
Thanks
Hri
MCDBA
"TJ" <nospam@.nowhere.com> wrote in message
news:u3Hy83i2DHA.4060@.TK2MSFTNGP11.phx.gbl...
> I have inherited several SQL 7 database and would like to know is there a
> way for me to determine the last time they were accessed or written to by
a
> user or application?
>
> --
> Any and all contributions are greatly appreciated ...
> Regards TJ
>
>|||Thx so much!
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:#8l9Fhl2DHA.556@.TK2MSFTNGP11.phx.gbl...
> Hi,
> You have to either,
> 1. Write triggers to audit the activity
> 2. Enable the SQL Profiler.
> FYI, You can make use of Sysprocesses table for online users, but once he
> log off the entry will be removed.
> Thanks
> Hri
> MCDBA
> "TJ" <nospam@.nowhere.com> wrote in message
> news:u3Hy83i2DHA.4060@.TK2MSFTNGP11.phx.gbl...
> > I have inherited several SQL 7 database and would like to know is there
a
> > way for me to determine the last time they were accessed or written to
by
> a
> > user or application?
> >
> >
> > --
> > Any and all contributions are greatly appreciated ...
> > Regards TJ
> >
> >
> >
> >
>sql