Audit Log

Hello,
I wanted a query regarding archiving the data from the log files. Really wha
t I wanted here is as follows:
When we change the data through the application, we can have the log to see
who has changed what data. But when the data is modified through the SQL
Server Enterprise Manager or Query Analyzer we can not have the log. But I
think this will be recorded in the log files. But how can I archive this
data. Means can I write some queries or stored procedures to get the
modifications done in the database?
--With Regards,
Sheshadrinath.Ran UPDATE trigger would be one way.
"Sheshadrinath R" <SheshadrinathR@.discussions.microsoft.com> wrote in
message news:8F77796A-071B-4609-8E0E-F0275E2A7434@.microsoft.com...
> Hello,
> I wanted a query regarding archiving the data from the log files. Really
> wha
> t I wanted here is as follows:
> When we change the data through the application, we can have the log to
> see
> who has changed what data. But when the data is modified through the SQL
> Server Enterprise Manager or Query Analyzer we can not have the log. But I
> think this will be recorded in the log files. But how can I archive this
> data. Means can I write some queries or stored procedures to get the
> modifications done in the database?
> --With Regards,
> Sheshadrinath.R|||Hi,
true said you can do it with INSERTED AND UPDATED TABLE , please go through
the article on the same topic as you ask at :
http://www.netdscure.co.in/Articles/AuditDML.htm
:-)
Regards
--
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"Sheshadrinath R" wrote:

> Hello,
> I wanted a query regarding archiving the data from the log files. Really w
ha
> t I wanted here is as follows:
> When we change the data through the application, we can have the log to se
e
> who has changed what data. But when the data is modified through the SQL
> Server Enterprise Manager or Query Analyzer we can not have the log. But I
> think this will be recorded in the log files. But how can I archive this
> data. Means can I write some queries or stored procedures to get the
> modifications done in the database?
> --With Regards,
> Sheshadrinath.R