Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009

    Unanswered: Logs for table updates

    I was wondering if it was possible to find out whether a table has been updated in Sql Server 2000 (service pack 4)? Does Sql Server keep logs of changes (add, delete, or changed/updated) records? If so, what system tables or stored procedures could I use to look up the changes? Thanks.


  2. #2
    Join Date
    Dec 2007
    London, UK
    It may be possible to retrieve some info from the log file(s) using a tool like:
    Apex SQL Log : Audit data changes, rollback and reconstruct transactions

    SQL Server 2000 is out of mainstream support. If you upgrade to 2008 Enterprise you can use the Change Data Capture feature to log any changes in user-readable form.

Posting Permissions

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