Auditing

From my reading of the online book it appears SQL can log all changes made
to each database, how do you switch this on and where is the file. What I am
trying to achieve is to build a monitoring process to identify what changes
a user performed for each session.
Thanks in advance.SQL Server does not have this ability. The log is to ensure database
integrity and not for auditing purposes. You have several choices to audit
user actions. One is to create triggers on each table that you wish to
monitor and write code to store the information into audit tables of your
design. Or you can use a 3rd party product such as Entegra from
www.lumigent.com.
Andrew J. Kelly
SQL Server MVP
"Con" <conaus@.hotmail.com> wrote in message
news:Ow409b56DHA.2568@.TK2MSFTNGP10.phx.gbl...

quote:

---

> From my reading of the online book it appears SQL can log all changes made
> to each database, how do you switch this on and where is the file. What I

---

am

quote:

---

> trying to achieve is to build a monitoring process to identify what

---

changes

quote:

---

> a user performed for each session.
> Thanks in advance.
>

---