Re: Audit

From: SriSamp (ssampath_at_sct.co.in)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 08:51:23 +0530

The quickest option is to use Triggers. You can of-course use a third part
product like Lumigent that audits using the transaction log (and not
triggers), but you will need to incur a cost for the tool. You can write a
simple tool to generate triggers on the required tables and then start using
them. 

-- 
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"John Smith" <rpm_107@yahoo.com> wrote in message
news:e5Zr9TeFEHA.2600@TK2MSFTNGP12.phx.gbl...
> Is there a quick method to audit all transactions (edit, update and
deletes)
> and store the audit trail in a separate table (prod_table,
prod_table_audit)
> against all tables w/i a database?
>
> Thanks.
>
>

Relevant Pages

  • Re: Audit logging an adp
    ... Allen Browne's audit code. ... Some people may be tempted to suggest using SQL Server triggers, ... but without an adequate security model your audit trail ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Audit logging an adp
    ... if Access MDB had triggers; I would probably be using it right now lol. ... Allen Browne's audit code. ... Some people may be tempted to suggest using SQL Server triggers, ... but without an adequate security model your audit trail ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Results of Altering Trigger NOT FOR REPLICATION
    ... audit tables and they are therefore being kept in synch that way. ... altered the triggers so that they are NOT FOR REPLICATION. ... > the trigger to NFR and replicate both tables. ...
    (microsoft.public.sqlserver.replication)
  • Re: How to know which tables is updated ?
    ... You could use profiler to audit certain types of activity & subsequently see what activity has occured through time. ... You could use triggers &/or default values to maintain a list of who & when records are added. ... is there any utility in Sql Server 2000 or any kind of third party tool available? ...
    (microsoft.public.sqlserver.server)
  • Re: Tracking object state for auditing
    ... the puprose of "tracking" would be to ultimately "audit" the changes ... creating triggers and the like is not ... something the "powers that be" will allow. ... > A very very simple way to track changes to data in a database is to ...
    (comp.object)
Quantcast