Post reply

Transaction logs

  • February 10, 2009 at 5:15 am

    #218372

    Hi Guys,

    Is it possible to investigate the transaction logs to idenftify when changes were made to data in a particlaur table. If so, where can i find it i.e. what is the default path?

    Note, this table is effectivley a dimensional table which does not update/ change very frequently at all.

    Thanks for you help.

    Steve

  • February 10, 2009 at 9:12 am

    #941347

    The path to the tran log is irrelevant, though it's set when you create a database. The log is part of the database and if queried is as part of the database (like the mdf file)

    In 2005, to get audit info from the tran log you'll have to buy a 3rd party product, and they're not cheap. The log is not for audits. It's there to ensure the consistency of the database and it's for SQL's use.

    If you want to audit changes to a table, set up triggers on that table.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 2 (of 2 total)

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