Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2005
    Posts
    2

    Unanswered: Audit Table actions

    Hi,
    i'm looking for a way to audit a table in a schema bedised knowing who
    and when it was touched the actual code which had been used.
    does anyone know of an elegant way to perform that ?
    thanks in advance
    shlomi

  2. #2
    Join Date
    Dec 2003
    Posts
    1,074
    Designer calls it 'journaling', but basically you use a trigger to log changes to the table in another table.

    -cf

  3. #3
    Join Date
    Apr 2005
    Posts
    2

    thank u - but this is not what i had in mind

    thanks, i'm looking for a soluton in the form of audit operation not a trigger

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •