Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    1

    Unanswered: table access trace

    Hi All,

    how can we trace the actions on a table in sybase ?

    how could i see the what happens in my table ?

    is there any logging mechanism which keeps actions for a table or object ?

    thanks and regards...

  2. #2
    Join Date
    Sep 2004
    Location
    Stockholm, Sweden
    Posts
    28
    Hi,
    Changes are noted in the database log, but it can be considered for internal use only since they only stay there for a while. If you want a history of your database you should redesign the datamodel as a temporal one. If you are unfamiliar with this concept, try to google for "temporal databases".

    /Mats

Posting Permissions

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