How do I audit insert/delete/update etc

From: Aris (aroutis_at_yahoo.com)
Date: 04/30/03

  • Next message: Jobi: "connect using named pipes / tcpip" 
    Date: Wed, 30 Apr 2003 01:45:29 -0700

    What I use is triggering on insert/update events,
    and mirror tables.

    Aris Routis
    DBA/Senior Software Developer
    Delta Singular
    Greece
    >-----Original Message-----
    >Helo!
    >Does anyone know how to audit insert/delete/update etc in
    >a database. Want like to have all that information in a
    >file to view history.
    >I'm running Sql2000 and 6.5.
    >
    >Regards Johan
    >.
    >

  • Next message: Jobi: "connect using named pipes / tcpip"

    Relevant Pages

    • Re: replication
      ... mode, when a session begins, the mirror server synchronizes the mirror ... database with the principal database as quickly as possible. ... substantial if the principal server is under a heavy work load or the ...
      (comp.databases.ms-sqlserver)
    • RE: Database Mirroring or Log Shipping?
      ... Log Shipping nothing but moving tlog from Primary to Secondary once restored ... "Because the mirror database is in a recovering state, ... snapshots are not an option for us b/c we have SQL 2005 STD. ...
      (microsoft.public.sqlserver.replication)
    • RE: Database Mirroring or Log Shipping?
      ... "Because the mirror database is in a recovering state, ... snapshots are not an option for us b/c we have SQL 2005 STD. ... Maybe Log Shipping is an alternative, but thought that I read that Log ...
      (microsoft.public.sqlserver.replication)
    • RE: Database Mirroring or Log Shipping?
      ... I used SSMS to configure the Log Shipping in 2005 and it seems to get the ... Josh Blair (hfdev) ... "Because the mirror database is in a recovering state, ...
      (microsoft.public.sqlserver.replication)
    • Re: AIX and Oracle Cold Backup
      ... I assume you are not doing archiving on this database since you are doing ... the database down to do cold backups every month because of the downtime. ... mirror set on another aix box then do a cold back of those disks. ... delivering the e-mail to the intended recipient, any disclosure, copying, ...
      (AIX-L)