Re: Audit Log

an UPDATE trigger would be one way.

"Sheshadrinath R" <SheshadrinathR@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:8F77796A-071B-4609-8E0E-F0275E2A7434@xxxxxxxxxxxxxxxx
> 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


.

Relevant Pages

  • Re: IISState File Help Needed
    ... Not from the .log files. ... There is from the .dmp files, ... will give you the page names which may tell you what queries are running. ... Basically, it looks like the query was created, a connection ...
    (microsoft.public.inetserver.iis)
  • Re: Parse log files for data
    ... If it grabs the whole line that's ... I can easily remove the " query= " from the beginning of each ... Here's a sample entry from one of the log files (just the beginning of ... so I modified the regex accordingly to ...
    (comp.lang.perl.misc)
  • Re: Importing XML for Newbies
    ... Why not just use an XQuery implementation to query them direct? ... I see no requirement here to involve a database at all. ... Create a DB for storing the log files? ...
    (microsoft.public.sqlserver.xml)
  • Parse log files for data
    ... I have a bunch of custom log files with database queries in them, ... I'm pretty sure this is the perfect exercise for a perl script. ... * Open, in order, all log files named yyyymmdd.log in the current ... INSERT" or " query = UPDATE", write that entire line starting from the ...
    (comp.lang.perl.misc)