Post reply

Identifying Changes in Table Records

  • December 4, 2003 at 4:40 am

    #83579

    Hi People,

    I would like to know if there is some way (via trans log and/or data dictionary) by which one can identify records which have been changed or added.

    SELECT *

    FROM tblUsers

    WHERE Record Has Changed

    OR Record Has benn Updated

    Thanks Alot

    Nicholas.

  • December 4, 2003 at 4:44 am

    #484568

    By default SQL Server does not offer this functionality. But we can achieve this thru Triggers, Timestamp colomn or comparision.

    .

  • December 4, 2003 at 4:47 am

    #484570

    Or have a third party tool like Lumigent LogExplorer.

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • December 5, 2003 at 8:06 am

    #484832

    You can turn on C2 auditing for the server. This will write an audit trail to the hard drive. The size of of these files can get large very fast.

    exec sp_configure 'C2 audit mode', 1

    go

    reconfigure

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply