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...

quote:

---

> 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

quote:

---

> 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...

quote:

---

> 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...
a[QUOTE]
by[QUOTE]
> a
>

---

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

Read the transaction log (ldf) file. My first post ever :)

Hi!

The purpose is to se history of which user updated, inserted or deleted a row in the database.

Can't seem to find any publications from microsoft on how to parse and interpret the log file.

Any documentation on how the log file is structured?
Is it possible to obtain this information through the system views

I don't want to use triggers.

Thanks

Consider the use of a third-party application for this job. That is money that's well spent.

|||

Thanks for the reply.

I know there exist som applications that can read log files, like Lumigent Log Explorer.

But it would be nice with an freeware version

|||

If you really want to learn, here the docuemnt on basic level.. I found few months back very unexpectedly... Nice one....

But this document is not sufficient to start programing with Tx Log files.. As Frank says you can use the 3rd party tools.. there are lot of products available on the market...

https://www.blackhat.com/presentations/bh-usa-07/Fowler/Presentation/bh-usa-07-fowler.pdf

|||

J-A.G. wrote:

I know there exist som applications that can read log files, like Lumigent Log Explorer.

But it would be nice with an freeware version

TANSTAAFL

But in order to learn you can always use something like the undocumented

DBCC LOG (Northwind, -1)

|||

good frank!

This undocumented command works on sql2000?

|||

Yes it does. But as with all undocumented features the use is at your own risk.

|||Tks!