Post reply

Transaction on database

  • May 8, 2015 at 12:47 pm

    #317307

    Hello everyone,

    i would like to know it's possible to find all transaction(insert, delete,update) on a database for a day. if yes what can i do.

    thank you.

  • May 8, 2015 at 1:35 pm

    #1796716

    Il your database is in FULL recovery mode, you could use something like Apex Log Explorer to retrieve all transactions from transaction log backups.

    Otherwise, there is the option to set up a SQL trace or a Extended events trace to capture all inserts/updates/deletes, but it can harm performances.

  • May 9, 2015 at 9:52 am

    #1796813

    eboucicaut (5/8/2015)

    Hello everyone,

    i would like to know it's possible to find all transaction(insert, delete,update) on a database for a day. if yes what can i do.

    thank you.

    Is this an interview question?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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