Auditing inserts updates etc

• xp_xclk

  SSC Enthusiast

  Points: 172

  More actions

  April 21, 2004 at 11:23 pm

  #101975

  Hello

  We are hoping to convert a package that runs on ingres to sql server.

  We have a requirement to report modifications (Insert, Update, Delete) to tables into our database.

  Under SqlServer, we were thinking of using triggers, however, the package is written to be "independent of the database", and therefore triggers will not work (in fact when triggers are added the package fatally crashes!).  This was probably why they didn't use the Ingres equivalent of triggers either.

  Under Ingres, we used an Ingres utility that interogated the Ingres journal file, and based on this, we could report modifications to the relevant tables.

  What we are looking for is a solution that will allow us to identify modifications to particular tables under SqlServer.

  Any ideas

  thanks

  Jeremy

• David Scotland-132255

  SSCertifiable

  Points: 5599

  More actions

  April 22, 2004 at 4:53 am

  #503779

  Never used this but you could give it a try

  http://www.logpi.com/

  Dave