Audit Log

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sheshadrinath R - 20 Dec 2005 14:27 GMT

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

Reply to this Message

David J. Cartwright - 20 Dec 2005 14:32 GMT

an UPDATE trigger would be one way.

> Hello,
> I wanted a query regarding archiving the data from the log files. Really
[quoted text clipped - 11 lines]
> --With Regards,
> Sheshadrinath.R

Reply to this Message

Andy Davis - 21 Dec 2005 04:31 GMT

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

Signature

Andy Davis
Activecrypt Team
--------------------------------------------
SQL Server Encryption Software
http://www.activecrypt.com

> Hello,
> I wanted a query regarding archiving the data from the log files. Really wha
[quoted text clipped - 9 lines]
> --With Regards,
> Sheshadrinath.R

Reply to this Message